Hi, I'm having some trouble setting up my JDBC Provider on WAS 6.0 to connect to an Oracle 9i DB. Here's what I've done, minus actual hostnames/usernames/passwords:
- Created "Oracle JDBC Provider"
Implementation Class: oracle.jdbc.pool.OracleCOnnectionPoolDataSource
- Saved that
- Created a new Data Source
JNDI Name: jdbc/data_source
Data Store: Oracle 9i and prior data store helper
- Set up J2C Authentication Alias with db username/password
ci8:@oracle_database (I've tried it with a number of variations)
- Tested that - get errors like:
Test connection failed for data source data_source_name on server server_name at node node_name with the following exception: javax.management.RuntimeMBeanException: null nested runtime exception is com.ibm.ws.exception.WsRuntimeException: java.lang.IllegalArgumentException: resolve against non-hierarchical or relative base.
I really don't get what the "non-hierarchical or relative base" stuff means.
Any help would be greatly appreciated.
[ December 08, 2005: Message edited by: Kevin Wright ]