• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

WSAD specific directions for creating an Oracle Data Source

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
whippersnapper
Posts: 1843
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic