Data Sources are used to connect your Oracle database.
JRI Publisher supports both JDBC and JNDI Data Source types included with JRI.
JDBC Data Sources are stored in a flat file at:
JDBC Data Sources have the following form:
#==================================================================== # JDBC datasource configuration # http://www.orafaq.com/wiki/JDBC#Thin_driver # additional jdbc configurations, please uncomment #==================================================================== [datasource:test] name=test url=jdbc:oracle:thin:@127.0.0.1:1521:XE username=my_oracle_user password=my_oracle_user_pwd
JNDI Data Sources are stored in a database and referenced in the application server rather than stored in a flat file as with JDBC Data Sources.
JNDI Data Sources have the following form:
#==================================================================== # Native JNDI datasource, to be configured in the application server # name: jndi_test #==================================================================== [datasource:jndi_test] type=jndi name=jndi_test
Data Sources can be added, edited and removed from the JRI Publisher Module via the Data Source tab, as shown below
The default view on clicking the tab is the List view, as shown below.
To add a Data Source, click on the Add tab at top.
Select the desired Data Source type and enter the required information as shown below. Then click the Add button:
On the main Data Source tab we can confirm the Data Source has been added:
To remove a Data Source, click on the Remove tab and select the Data Source you wish to remove using the drop-down selector as shown below: