...
https://access.redhat.com/documentation/en-us/red_hat_jboss_enterprise_application_platform/7.2/html/configuration_guide/datasource_management#jdbc_drivers
JDBC Driver configuration
When configuring the JDBC drivers for blueriq, a library xml element needs to be added to the server.xml, the library xml elements needs to contain an "id" attribute which is used as reference later on. In the fileset element the dir attribute must be set to the directory containing designated support driver. In this example oracle is used.
Code Block |
---|
|
<library id="oracle-lib">
<fileset dir="C:\drivers" includes="ojdbc8.jar"/>
</library> |
Once the library element is added it can be used inside the application element to add the library to the application classloader. Inside the classloader element the attribute "commonLibraryRef" is set the newly created id of the library element.
Code Block |
---|
language | xml |
---|
title | Classloader |
---|
|
<application id="Blueriq" location="blueriq-runtime-application-12.0.0.0.war" name="Blueriq" context-root="runtime" autoStart="true">
<classloader commonLibraryRef="oracle-lib"/>
</application> |
JNDI datasources configuration
JDNI datasources are driver specifc, in the examples only the supported drivers are shown.
Oracle
In the xml element jdbcDriver, the libraryRef attribute is set to the library id. In the properties.oracle element the connection URL, user and password attributes need to be set in order to create a database connection. Fill in the blanks at <...> with your own configuration.
Code Block |
---|
language | xml |
---|
title | JNDI Oracle |
---|
|
<dataSource id="CustomerDataSource" jndiName="jdbc/customer">
<jdbcDriver libraryRef="oracle-lib"/>
<properties.oracle URL="jdbc:oracle:<driverType>:@<server_name>:<port>:<SID>" user="user" password="password"/>
</dataSource> |
Microsoft SQL Server
In the xml element jdbcDriver the libraryRef attribute is set to the library id. In the properties.microsoft.sqlserver element, fill in the attributes with your own configuration.
Code Block |
---|
language | xml |
---|
title | JNDI MSSQL |
---|
|
<dataSource id="CustomerDataSource" jndiName="jdbc/customer">
<jdbcDriver libraryRef="mssql-lib"/>
<properties.microsoft.sqlserver databaseName="database" portNumber="portnr" serverName="server" user="user" password="password"/>
</dataSource> |