Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Migrating from Oracle 9i to 10g in WSAD and getting exception

 
Priya Chawla
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Migrating from Oracle 9i to 10g

My java application is using Oracle 9i, Now we need to migrate to oracle 10G
I am using WSAD 5.1.1
I have made following changes in server configuration to migrate to 10g

Variables Section:
I have changed in 'Variable' section of server configuration settings 'ORACLE_JDBC_DRIVER_PATH' to the location where my Oracle client is installed
for example
D:\oracle\product\10.2.0\client_2\jdbc\lib to have classes12.zip path

JDBC Provider:
I am using 'Oracle JDBC oci8 Driver' as a JDBC Provider

Resource:
I have changed my connection URL to jdbcracleci8:username/password@ora10g

Now when I am starting my server i am getting following error

java.sql.SQLException: DSRA9002E: ResourceException with error code null: javax.resource.spi.ResourceAllocationException
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1339)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1064)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1571)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:622)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:424)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:216)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:191)


Can somebody please help me in this regard
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic