By James Taylor on Oct 02, 2014
As the Oracle DB adapter supports the ANSI SQL 92 language specification, it enables connectivity to a number of databases through a common framework. This post demonstrates connecting to an Ingres database via the Oracle DB adapter. It should also be noted that this blog can be applied to any 3rd party DB.
The versions that are used here are:
- Oracle SOA Suite 12.1.3
- Ingres DB 10.1 (Linux)
If you have different versions the procedure to connect should be the same. The screenshots will be different though.
This blog post is broken into 2 stages, client connectivity via JDeveloper, and server connection via the Weblogic Console. For both deployments the jdbc file is required. for ingress this can be found in the following location:
In order to develop against a database you need the client IDE connectivity to the database. With JDeveloper you can utilize the SQL Worksheet providing a consistent development tool across all databases.
- Download the jdbc file iijdbc.jar and put in in the following location:
- Start up JDeveloper and create a new DB connection
- Enter in the following details, go to step 4 to configure the Driver Class
- When you select Generic JDBC Driver you will need to import the Driver Class the screen shots provide the required information.
When you click OK you should see something like this
- Now Test the connectivity.
You can now develop a service using the DB Adapter connecting to an Ingres database.
The next steps are for configuring Weblogic so the adapter will work at run time.
- On the server where SOA Suite is installed, copy the iijdbc.jar file to the following
- Edit the WEBLOGIC_CLASSPATH to include the iijdbc.jar. This is done by editing the following file:
append the following to the WEBLOGIC_CLASSPATH
- If the Weblogic is started you will need to restart in order for the jar file to be initialized.
- Login to the Weblogic console
domain -> Services -> Data Sources
- If in production mode Lock & Edit the session in the Change Centre
- Click the New Button
- Enter in details to meet your requirements:
JNDI Name: jdbc/ingres
Database Type: Ingres
- Select the JDBC driver, I selected the XA version.
- On the transaction option page just select Next
- Enter in your connection details
Database Name: iidbdb
- Change the driver to, and test the connection
- Click Finish, then go back into the configuration for Ingres and choose your targets
- Also on the Configuration tab, scroll down and expand the Advanced options. Make the following changes:
Check the "Test Connections on Reserve" check box
Enter "SQL SELECT 1 FROM iitables" in the init SQL text box.
- Save and Activate your changes.
- You have now established connectivity to Ingres now you need to configure the adapter.
- Create a new Lock & Edit session in Weblogic console
- Navigate to
Deployments -> DbAdapter -> Configuration -> Outbound Connection Pool -> New
- Select the javax.resource.cci.ConnectionFactory radio box then Next
- Enter the JNDI name, and click Finish
- If this is the first DB Adapter you have created it will ask to create a deployment plan. Follow your standards for this and continue.
- Navigate back to the configuration for the Ingres Database
Deployments -> DbAdapter -> Configuration -> Outbound Connection Pool -> eis/DB/ingres
- 2 changes are required.
- Save and Activate the Changes
- The last step is to recompile the DB adapter to pick up all the changes.
- Create a new Lock & Edit Session
- Navigate to
Deployments -> Check DbAdapter
- Click Update then Finish, then Activate the changes
- You are now complete, your code will connect to the ingress database.