Monday, January 31, 2011

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

For a large County Administration Agency in California, MindTelligent team was assigned the task of integration LEA/CJIS applications using Oracle 11g 11.1.1.3 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 11.1.1.3


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 commEnv.sh 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

No comments:

Post a Comment

SOA Cloud 12c GIT Repository

When a project is created, you can choose to initialize the project with one project Git repository for the project. A Maven repository is a...