Information for creating JDBC connections
Use default values when you create JDBC connections if specific values are not provided. For more information, see the application server documentation.
WebLogic
Use the following values if your application server is WebLogic:
SQLServer
-
Database Driver: Microsoft™ MS SQL Server Driver (Type 4) Versions: 2012, 2012 SP1 and SP3, 2014, 2014 SP1, 2016 SP1
-
Default port: 1433
-
Driver class:
com.microsoft.sqlserver.jdbc.SQLServerDriver
-
Driver URL: jdbc:sqlserver://<your_db_host>[\\<named_instance>]:<your_db_port>;databaseName=<your_db_name>
-
Properties: Add user=<your_db_user_name>
Oracle
-
Driver: Other
-
Default port: 1521
-
Driver class:
oracle.jdbc.OracleDriver
-
Driver URL: jdbc:oracle:thin:@<your_db_host>:<your_db_port>:<your_db_service_name>
Enter the driver URL by using the format that is shown. Unica applications do not allow the use of Oracle's RAC (Real Application Cluster) format for JDBC connections.
- Properties: Add user=<your_db_user_name>
DB2®
-
Driver: Other
-
Default port: 50000
-
Driver class:
com.ibm.db2.jcc.DB2Driver
-
Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>
-
Properties: Add user=<your_db_user_name>
MariaDB
- Database type: MYSQL
- Driver: mariadb-java-client-2.5.1.jar
- Default port: 3306
- Driver class: org.mariadb.jdbc.Driver
- Driver URL: jdbc:mariadb://<your_db_host>:<PORT>/<Your_DB_user_name>
- Properties: Add user=<your_db_user_name>
- Password=<your_db_user_password>
WebSphere®
Use the following values if your application server is WebSphere®:
SQLServer
-
Driver: N/A
-
Default port: 1433
-
Driver class:
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
-
Driver URL: jdbc:sqlserver://<DBhostName>:1433;databaseName=<DBName>
In the Database Type field, select User-defined.
After you create the JDBC Provider and data source, navigate to the Custom Properties for the data source, and add or modify properties as follows.
- serverName=<your_SQL_server_name>
- portNumber =<SQL_Server_Port_Number>
- databaseName=<your_database_name>
-
Name: webSphereDefaultIsolationLevel
-
Value: 1
-
Datatype: Integer
Oracle
-
Driver: Oracle JDBC Driver
-
Default port: 1521
-
Driver class:
oracle.jdbc.OracleDriver
-
Driver URL: jdbc:oracle:thin:@<your_db_host>:<your_db_port>:<your_db_service_name>
Enter the driver URL by using the format that is shown. Unica applications do not allow the use of Oracle's RAC (Real Application Cluster) format for JDBC connections.
DB2®
-
Driver: JCC Driver Provider
-
Default port: 50000
-
Driver class:
com.ibm.db2.jcc.DB2Driver
-
Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>
- Click the data source that you created. Go to the Custom Properties for the data source.
- Select the Custom properties link.
- Set the value for the
resultSetHoldability
property to1
. If you do not see theresultSetHoldability
property, create theresultSetHoldability
property and set its value to1
. - Set the value for the
webSphereDefaultIsolationLevel
property to2
. If you do not see thewebSphereDefaultIsolationLevel
property, create thewebSphereDefaultIsolationLevel
property and set its value to2
.
-
Name: webSphereDefaultIsolationLevel
-
Value: 2
-
Datatype: Integer
MariaDB
- Database type: User_define
- Implementation class name = org.mariadb.jdbc.MySQLDataSource
- Driver: mariadb-java-client-2.5.1.jar
JNDI custom properties
- Component-managed authentication alias = Select the authentication details for user
- Mapping-configuration alias = WSLogin
- portNumber = 3306
- relaxAutoCommit=true
- databaseName = <DATABASE NAME>
- serverName = the host name of the MariaDB server
- user = the user name of the MariaDB server
- password = the password associated with the user name
Tomcat
Use the following values if your application server is Tomcat:
- Driver: mariadb-java-client-2.5.1.jar
- Default port: 3306
- Driver class: org.mariadb.jdbc.Driver
- Driver URL: jdbc:mariadb://<your_db_host>:<PORT>/<Your_DB_user_name>
- Properties: Add user=<your_db_user_name>
- Properties: Add password=<your_db_password>
JBoss
Specify the native library path of the database driver JAR file on your server.
Use the following values if your application server is JBoss:
SQL Server
- Database Driver: Microsoft MS SQL Server Driver (Type 4) Versions: 2012, 2012 SP1 and SP3, 2014, 2014 SP1, 2016 SP1
- Default port: 1433
- Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
- Driver URL: jdbc:sqlserver://<your_db_host>:<your_db_port>;databaseName=<your_db_name>,validconnection-checker-class>
- name:
org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker
For example:
/subsystem=datasources/data-source=UnicaPlatformDS:add(jndiname=" java:/UnicaPlatformDS",connection-url="jdbc:sqlserver://localhost:1433;databaseName=plat11",driver-name=sql,username= sa,password=test1234,valid-connection-checker-classname="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker") **
Oracle
- Driver: Oracle JDBC Driver
- Default port: 1521
- Driver class: oracle.jdbc.OracleDriver
- Driver URL:jdbc:oracle:thin:@<your_db_host>:<your_db_port>:<your_db_service_name>
DB2
- Driver: JCC Driver Provider
- Default port: 50000
- Driver class: com.ibm.db2.jcc.DB2Driver
- Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>
- valid-connection-checker class-name= org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker
MariaDB
- Database Driver: mariadb-java-client-2.5.1.jar
- Default port:
3306
- Driver class: org.mariadb.jdbc.Driver
- Driver URL: jdbc:mariadb://<your_db_host>:<PORT>/<Your_DB_user_name>
- Properties:
Add user=<your_db_user_name>
- Properties:
Add password=<your_db_password>
- Driver module xa-datasource-class= org.mariadb.jdbc.MySQLDataSource