Unica Interact
Create JDBC connections in the web application server
Use the following table to create JDBC connections to the databases that hold the Interact, Campaign, and Platform tables:
Deployed web application | JDBC connections required to the databases |
---|---|
Unica Campaign |
In the web application server where Campaign is deployed, create JDBC connections to the databases that hold the following tables:
|
Unica Interact runtime environment (The Unica Interact runtime environment is typically deployed in a different JVM from Unica Campaign) |
In the web application server where the Unica Interact runtime environment is deployed, create JDBC connections to the databases that hold the following tables:
All JNDI names are recommended, unless otherwise indicated. |
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
- Properties:
jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password>
For example:
jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password
WebSphere
Use the following values if your application server is WebSphere.
- Database Type: OneDB JDBC Driver
- Default port:
<onedb port>
- Driver class:
com.informix.jdbc.IfxDriver
Driver URL:
For example:jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password
jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password
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:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password>
For example:
jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password
JBOSS
Use the following values if your application server is JBOSS.
- Database Driver: ONEDB JDBC Driver
- Default port:
<onedb port>
- Driver class:
com.informix.jdbc.IfxDriver
- Driver URL:
jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password>
For example:
jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password
-
valid-connection-checker class-name=
org.jboss.jca.adapters.jdbc.extensions.informix.InformixExceptionSorter