aspose file tools*
The moose likes JDBC and the fly likes Migrating from Oracle 9i to 10g  in WSAD and getting exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Migrating from Oracle 9i to 10g  in WSAD and getting exception" Watch "Migrating from Oracle 9i to 10g  in WSAD and getting exception" New topic
Author

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

Priya Chawla
Greenhorn

Joined: Jul 26, 2006
Posts: 2
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Migrating from Oracle 9i to 10g in WSAD and getting exception