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.
WebSphere
Use the following values if your application server is WebSphere:
- 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.
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.
- Name:
webSphereDefaultIsolationLevel
. - Value: 2
- Datatype: Integer
- 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 user = password=<your_db_password>
- Driver module xa-datasource-class= org.mariadb.jdbc.MySQLDataSource
- Database Driver: onedb-jdbc-complete-8.0.0-SNAPSHOT.jre8.jar
- Database Port :20195
- Driver: Informix JDBC Driver
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL: jdbc:informix-sqli://<your_db_host>/<your_db_name>:INFORMIXSERVER=<your_db_servername>;
- Database Driver: db2jcc4.jar
- Database Port :50000
- Driver class:
com.ibm.db2.jcc.DB2Driver
- Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>
JBoss
Specify the native library path of the database driver JAR file on your server. For example: db2jcc4.jar/ojdbc8.jar/mssql-jdbc-7.0.0.jre8.jar.jar.
Use the following values if your application server is JBoss:
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>,valid-connection-checker-class-name =org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker
For example :/subsystem=datasources/data-source=UnicaPlatformDS:add(jndi-name="java:/UnicaPlatformDS",connection-url="jdbc:sqlserver://localhost:1433;databaseName=plat11",driver-name=sql,user-name=sa,password=test1234,valid-connection-checker-class-name="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>
For example
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 user = password=<your_db_password>
- Driver module xa-datasource-class= org.mariadb.jdbc.MySQLDataSource
- Database Driver: onedb-jdbc-complete-8.0.0-SNAPSHOT.jre8.jar
- Database Port :20195
- Driver: Informix JDBC Driver
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL: jdbc:informix-sqli://<your_db_host>/<your_db_name>:INFORMIXSERVER=<your_db_servername>;
- Database Driver: db2jcc4.jar
- Database Port :50000
- Driver class:
com.ibm.db2.jcc.DB2Driver
- Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>
Tomcat
Specify the native library path of the database driver JAR file on your server. For example: mariadb-java-client-2.5.2.jar/onedb-jdbc-8.0.0.1-complete.jar/ojdbc8.jar/mssql-jdbc-7.0.0.jre8.jar.
Use the following values if your application server is Tomcat:
SQLServer
- Database Driver: Microsoft MS SQL Server Driver (Type 4) Versions: SQL Server (e) 2014, 2016 SP1, 2017, 2019
- Default port:
1433
- Driver class:
com.microsoft.sqlserver.jdbc.SQLServerDriver
- Driver type:
javax.sql.DataSource
- Driver URL: jdbc:sqlserver://<your_db_host>[\\<named_instance>]:<your_db_port>;databaseName=<your_db_name>
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>
- Driver: MariaDB JDBC Driver
- 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>
- Database Driver: onedb-jdbc-complete-8.0.0-SNAPSHOT.jre8.jar
- Database Port :20195
- Driver: Informix JDBC Driver
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL: jdbc:informix-sqli://<your_db_host>/<your_db_name>:INFORMIXSERVER=<your_db_servername>;
- Database Driver: db2jcc4.jar
- Database Port :50000
- Driver class:
com.ibm.db2.jcc.DB2Driver
- Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>