This section discusses the steps to configure ViaServ OR any Type 4 JDBC Driver with Oracle SOA 11g 220.127.116.11
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_18.104.22.168
- Restart the admin and managed servers
- Create the Data Source.
- Create a Connection Pool.
- For questions, comments and feedback, please contact: Harvinder Singh Saluja