aspose file tools*
The moose likes IDEs, Version Control and other tools and the fly likes WSAD specific directions for creating an Oracle Data Source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "WSAD specific directions for creating an Oracle Data Source" Watch "WSAD specific directions for creating an Oracle Data Source" New topic
Author

WSAD specific directions for creating an Oracle Data Source

Jeff Kinsey
Greenhorn

Joined: Jan 08, 2002
Posts: 19
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

Joined: Jan 08, 2002
Posts: 19
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

Joined: Jul 12, 2002
Posts: 21
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

Joined: Jul 12, 2002
Posts: 21
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

Joined: Mar 25, 2001
Posts: 1751
    
    2
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WSAD specific directions for creating an Oracle Data Source