Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WSAD specific directions for creating an Oracle Data Source

 
Jeff Kinsey
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone have a link that specifically describes how to define an Oracle DataSource to the default test server in WSAD?
Thanks,
Jeff
 
Jeff Kinsey
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Rambo Rambabu
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think there is a typo in this posting.
origial posting says
-----------------
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
--------------------------
Note that Value should read as
jdbc racle:thin@.... instead of jdbc.oralce:thin@....

When I tried with jdbc.oracle:thin, I got staleconnection exception.
--Rambo
 
Rambo Rambabu
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
special characters causing problem. i don't know how to put them off. Anyway, for Value,
after jdbc, we need to put a : instead of .
-- Rambo
 
Michael Matola
whippersnapper
Ranch Hand
Posts: 1819
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
special characters causing problem. i don't know how to put them off.
If you want to suppress certain character combinations from turning into smilies, check the "Disable smilies in this post" option at the bottom of the screen when posting.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic