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.

Note:

If you are not using the default port setting for your database, make sure that you change it to the correct value.

Tomcat

Use the following values if your application server is Tomcat:

MariaDB

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>

Postgres

Driver: postgresql-42.5.4.jar
Default port: 5432
Driver class: org.postgresql.Driver
Driver URL: jdbc:postgresql://<DB_host>:<PORT>/<DB_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

Note:

From version 12.1.0.2, use:

MariaDB ODBC connector version 3.1.6 for Windows and Linux
MariaDB ODBC connector version 3.1.9 for SUSE operating system

MariaDB ODBC connector versions


Microsoft Windows	Maria DB ODBC Connector: 3.1.6 Download link: https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.6/mariadb-connector-odbc-3.1.6-win64.msi
RHEL	Maria DB ODBC Connector: 3.1.6 Download link: https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.6/mariadb-connector-odbc-3.1.6-ga-rhel7-x86_64.tar.gz
SUSE	Maria DB ODBC Connector: 3.1.9 Download link: https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.9/mariadb-connector-odbc-3.1.9-sles123-amd64.tar.gz

Example for Microsoft Windows: Set the following configuration in ODBC Driver Manager following the Statements parameter:


SET SQL_MODE='PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_KEY_OPTIONS';

Example for SUSE/Linux: Set the following configuration in odbc.ini:


[<CampaignSystem>]
Driver=/usr/local/mariaDBConnector/lib/libmaodbc.so
DATABASE=<DATABASE_NAME>
DESCRIPTION=MariaDB
SERVER=<DATABASE_SERVER>
UID=<USER_NAME>
PASSWORD=<PASSWORD>
PORT=3306
InitStmt=SET
SQL_MODE='PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_KEY_OPTIONS';

Attention:

Use MariaDB database user name. Do not use root and unica*03 as username and password for UA_SYSTEM_TABLES datasource.

MariaDB JAVA Client (JDBC Client): Download the version 2.4.0 client using the following link: https://mariadb.com/kb/en/library/about-mariadb-connector-j/

Note:

For AIX, we do not support MariaDB as System and User Database.
For environments running RHEL 9 with MariaDB as the system or user database, it is recommended to configure the BulkInsertBlockSize parameter to a value of 1 in the MariaDB data source template. This setting ensures that NULL values are correctly preserved in date columns, preventing the MariaDB ODBC Connector from defaulting to '0000-00-00'.
The OwnerForTableDisplay field should be left blank for MariaDB System and User database datasource templates.

PostgreSQL

Database Driver: postgresql-42.5.4.jar
Default port: 5432
Driver class: org.postgresql.Driver
Driver URL: jdbc:postgresql://<DB_host>:<PORT>/<DB_name>
Properties: Add user=<your_db_user_name>
Properties: Add password=<your_db_password>
Driver module xa-datasource-class= org.postgresql.xa.PGXADataSource