Monday, January 31, 2011

Configure ViaServ or any Type 4 JDBC Drivers with Oracle SOA 11g

For a large County Administration Agency in California, MindTelligent team was assigned the task of integration LEA/CJIS applications using Oracle 11g SOA technology. One of the significant tasks was to configure the SOA servers to have seamless integration is CA Datacom Database with Oracle  and SQL Server data stores.

This section discusses the steps to configure ViaServ OR any Type 4 JDBC Driver with Oracle SOA 11g

Weblogic 10.3.3. is shipped with a several drivers that can be used "out of the box" and no configuration may be required. The drivers shipped with Weblogic include Adabas for z/OS,   
CICS/TS for z/OS,Cloudscape, DB2, DB2 for i5/OS, DB2 for z/OS, Derby,
EnterpriseDB, FirstSQL,IMS/DB for z/OS, IMS/TM for z/OS, Informix, Ingres,
MS SQL Server, MaxDB MySQL, Oracle, PointBase,PostgreSQL,
Progress, Sybase,VSAM for z/OS,

For this specific client of of mine I had to configure the Type 4 JDBC driver,
which is not pre-configured with with Weblogic. This following 
section discusses the steps to be taken to configure and 
seamlessly use the driver with weblogic and SOA managed servers.

  • Copy Viajdbc.jar to directory/oracle/Oracle/Middleware/wlserver_10.3/server/lib/ViaJdbc.jar
  • Change the WEBLOGIC_CLASSPATH variable in the file in the /oracle/Oracle/Middleware/wlserver_10.3/common/bin directory to reflect the path of the driver jar file
  • For the Driver to be visible from SOA targets, it is imperative that we copy the Viaserv.jar file to the directory /oracle/Oracle/Middleware/Oracle_SOA1/soa/modules/oracle.soa.ext_11.1.1.3
  • Restart the admin and managed servers 
  • Create the Data Source.
  • Create a Connection Pool. 
  •  For questions, comments and feedback,  please contact: Harvinder Singh Saluja

ForgeRock: Open AM. Install Open AM 5.5 with Tomcat 8.0 - Part 1- Install Tomcat

This BLOG thread discusses on steps to install and configure Open AM 5.5 with Tomcat 8.0. Install Tomcat. You can always find the l...