Could you please help me to create a JDBC connection polling in Oracle application server. I can able to create a connection pooling for oracle database. But my requirement is DB2 database conncection pooling and data source configuration in Oracle Aps server. When I tried to configure, I'm getting an error like "Unable to create : com.ibm.db2.jcc.DB2Driver Missing class: com.ibm.db2.jcc.DB2Driver Dependent class: oracle.oc4j.sql.config.DataSourceConfigUtils Loader: oc4j:10.1.3 Code-Source: /D:/oc4j_extended_101330/j2ee/home/lib/oc4j-internal.jar Configuration: in META-INF/boot.xml in D:\oc4j_extended_101330\j2ee\home\oc4j.jar This load was initiated at ascontrol.web.ascontrol:0.0.0 using the Class.forName() method. The missing class is available from the following locations: 1. Code-Source: /D:/oc4j_extended_101330/j2ee/home/shared-lib/db2jcc/1.1/db2jcc.jar (from in /D:/oc4j_extended_101330/j2ee/home/config/server.xml) This code-source is available in loader db2jcc:1.1. This shared-library can be imported by the "ascontrol" application. 2. Code-Source: /D:/oc4j_extended_101330/j2ee/home/applib/db2jcc.jar (from in /D:/oc4j_extended_101330/j2ee/home/config/server.xml) This code-source is available in loader global.libraries:1.0. This shared-library can be imported by the "ascontrol" application. "
Connection Details are Datasource Class Name: com.ibm.db2.jcc.DB2Driver (I tried with com.ibm.db2.jcc.DB2DataSource also) JDBC URL: jdbc:db2j:net://sattest:446/DBAU
Can you please tell me is there any other way to resolve this?
Regards Kasi..
Roger Chung-Wee
Ranch Hand
Joined: Sep 29, 2002
Posts: 1683
posted
0
Have you added the db2jcc.jar to the classpath?
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
kasi pandian
Greenhorn
Joined: Feb 01, 2008
Posts: 12
posted
0
Can you please help me where we can set the classpath for db2jcc.jar? I added this jar into D:\oc4j_extended_101330\j2ee\home\lib folder.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.