Friday Oct 03, 2014

Oracle SOA Suite DB Adapter for Ingris

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:

$INGRES_HOME/lib/iijdbc.jar

JDeveloper

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.

  1. Download the jdbc file  iijdbc.jar and put in in the following location:

    %JDEV_HOME%\jdeveloper\jdev\lib

  2. Start up JDeveloper and create a new DB connection



  3. Enter in the following details, go to step 4 to configure the Driver Class



  4. 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



  5. 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.

Configuring Weblogic

  1. On the server where SOA Suite is installed, copy the iijdbc.jar file to the following

    $WLS_HOME/server/lib

  2. Edit the WEBLOGIC_CLASSPATH to include the iijdbc.jar. This is done by editing the following file:

    $MW_HOME/oracle_common/common/bin/commEnv.sh

    append the following to the WEBLOGIC_CLASSPATH

    ${CLASSPATHSEP}${WL_HOME}/server/lib/iijdbc.jar

  3. If the Weblogic is started you will need to restart in order for the jar file to be initialized.

  4. Login to the Weblogic console

  5. Navigate

    domain -> Services -> Data Sources

  6. If in production mode Lock & Edit the session in the Change Centre

  7. Click the New Button

  8. Enter in details to meet your requirements:

    Name: ingres
    JNDI Name: jdbc/ingres
    Database Type: Ingres



  9. Select the JDBC driver, I selected the XA version.



  10. On the transaction option page just select Next

  11. Enter in your connection details

    Database Name: iidbdb
    Hostname: hostname.oracle.com
    Port: 21071
    Username: ingres
    Password: *****



  12. Change the driver to, and test the connection

    com.ingres.jdbc.IngresDriver



  13. Click Finish, then go back into the configuration for Ingres and choose your targets

  14. 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.



  15. Save and Activate your changes.

  16. You have now established connectivity to Ingres now you need to configure the adapter.

  17. Create a new Lock & Edit session in Weblogic console

  18. Navigate to

    Deployments -> DbAdapter -> Configuration -> Outbound Connection Pool -> New

  19. Select the javax.resource.cci.ConnectionFactory  radio box then Next



  20. Enter the JNDI name, and click Finish

    eis/DB/Ingres



  21. 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.

  22. Navigate back to the configuration for the Ingres Database

    Deployments -> DbAdapter -> Configuration -> Outbound Connection Pool -> eis/DB/ingres

  23. 2 changes are required.

    PlatformClassName:  org.eclipse.persistence.platform.database.DatabasePlatform
    XADataSourceName: jdbc/ingres



  24. Save and Activate the Changes

  25. The last step is to recompile the DB adapter to pick up all the changes.

  26. Create a new Lock & Edit Session

  27. Navigate to

    Deployments -> Check DbAdapter



  28. Click Update then Finish, then Activate the changes

  29. You are now complete, your code will connect to the ingress database.

Thursday May 27, 2010

Using JCA Adapter with OSB 11.1.1.3

[Read More]
About

Discussions and Examples using Oracle Fusion Middleware. Some image links are broken when using Firefox, Safari, and Chrome. If you want to see the full image please use IE.

Twitter:@james8001

tumblr hit counter vistors, thanks for your support

Search

Archives
« June 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today