Win a copy of Spring Boot in Practice this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

Oracle Aps Server - Connection Pooling

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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..
 
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic