wood burning stoves 2.0*
The moose likes JDBC and the fly likes Oracle Aps Server - Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Aps Server - Connection Pooling" Watch "Oracle Aps Server - Connection Pooling" New topic
Author

Oracle Aps Server - Connection Pooling

kasi pandian
Greenhorn

Joined: Feb 01, 2008
Posts: 12
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

Joined: Sep 29, 2002
Posts: 1683
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
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.
 
Consider Paul's rocket mass heater.
 
subject: Oracle Aps Server - Connection Pooling
 
Similar Threads
Deployement problem in oc4j with hibernate + JPA and Spring
Deploying a JSF 1.2 webapp with an EJB 3.0
Connection authorization failure occurred
Deployement problem in oc4j with hibernate + JPA and Spring
oc4j AnnotatedNoClassDefFoundError