Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Aps Server - Connection Pooling

 
kasi pandian
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,

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
Posts: 1683
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you added the db2jcc.jar to the classpath?
 
kasi pandian
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic