The following worked for me:
John Sefler posted on ibm.software.websphere.studio.appication-site-developer
Here is what works for me when connecting to Oracle from the WebSphere Test
Environment:
1. Edit your Server Configuration and switch to the "Data source" tab.
2. From the
JDBC driver list, Add...
Name: OracleJdbcDriver
Description: Oracle 8i, v8.17
Implementation class name: oracle.jdbc.pool.OracleConnectionPoolDataSource
URL prefix: <-- none
Class path: C:\<your absolute path to the Oracle driver>\classes12.zip
3. Select the newly added JDBC driver and from the Data source defined in
the JDBC driver selected above, choose Add...
Name: Oracle Datasource
JNDI name: jndi4oracle <-- use your desired jndi name
Database name: ORA817 <-- use your oracle database name
Default user ID: <your id on the oracle machine>
Default user password: <your password on the oracle machine>
4. Select the newly added data source and from the Resource properties
defined in the data source selected above, choose Add...
Name: URL
Type: java.lang.String
Value: jdbc.oracle:thin:@your.machine.company.com:1521
ra817 <-- in your
case, your.machine.company.com is probably "ida", and ora817 is probably
"id03"
Description: Oracle server URL
I hope this helps,
John Sefler