Unica Platform
Create the JDBC connection in web application server
The Unica Platform web application must be able to communicate with its system table database using a JDBC connection. You must create this JDBC connection in the web application server where you plan to deploy Unica Platform.
You can allow the installer to create this data source when you install Unica
Platform. To enable automatic data source creation during installation, on the
Datasource Creation panel, select the Create Datasource check box and supply
information about your application server.The installer creates the data source
using UnicaPlatformDS
as the JNDI name.
The following sections provide information on creating JDBC connections on different application servers.
WebLogic
Use the following values if your application server is WebLogic.
OneDB
- Driver: OneDB JDBC Driver
- Default port:
<onedb port>
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL:
jdbc:informixsqli://<your_db_host>:<your_db_service_port>/<your_db_name>
- Properties:
INFORMIXSERVER user=<your_db_user_name>
Tomcat
Use the following values if your application server is Tomcat.
- Driver: ONEDB JDBC Driver
- Default port:
<onedb port>
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL:
jdbc:informixsqli://<your_db_host>:<your_db_service_port>/<your_db_name>
- Properties:
Add user=<your_db_user_name>
JBOSS
Use the following values if your application server is JBOSS.
- Database driver: onedb-jdbc-8.0.0.1-complete.jar
- Default port:
<onedb port>
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL:
jdbc:informix-sqli://<your_db_host>:<your_db_service_port>/<your_db_name>:INFORMIXSERVER=<Informix_servername>
-
valid-connection-checker class-name=
org.jboss.jca.adapters.jdbc.extensions.informix.InformixExceptionSorter
- driver:
xa-datasource-class-name= com.informix.jdbc.IfxDriver