File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes Problem when developing EJB using WSAD to config Oracle DataSource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Problem when developing EJB using WSAD to config Oracle DataSource " Watch "Problem when developing EJB using WSAD to config Oracle DataSource " New topic
Author

Problem when developing EJB using WSAD to config Oracle DataSource

henry_cui
Greenhorn

Joined: Sep 08, 2001
Posts: 5
Hi there,
I tried to create EJB using WSAD with Oracle DB. Here is what I have done:
1. Edit a database:
name: OracleDriver
Implementation class name: oracle.jdbc.pool.OracleConnectionPoolDataSource
URL prefix: jdbc racle:thin:@127.0.0.1:1521:sample
class path: E:\Oracle\Ora81\jdbc\lib\classes12.zip
2. Add a dataSource:
name: ITSOWSAD
JNDI name: jdbc/ITSOWAD
database name: sample
Default user id: scott
Default password: tiger
But when I launch the test environment, I got the following message:
Failed to start EJB, Invalid Oracle URL specified: OracleDataSource.makeURL
Does anyone know the reason?
Thanks.
Henry
maha veer
Greenhorn

Joined: Oct 02, 2002
Posts: 3
Hi,
Please follow the steps:
Step1
In the JDBC Driver List
Name: OracleDriver(It is upto you).
Description: Oracle Driver For ORCL Database (it is optional)
Implementation class name: oracle.jdbc.pool.OracleConnectionPoolDataSource
URL Prefix: (Leave it blank)
Class path: C:/orant/jdbc/lib/classes12.zip (it is your class path)
Step2
Data source defined in the JDBC driver selected above
Name: OracleDS(it is upto you)
JNDI name:jdbc/cons
Description: Oracle Data Source For ORCL(it is optional)
Database name: orcl
Default user ID:scott
Default user password: tiger
other things, you leave as it is.
Step3
Resource properties defined in the data source selected above
Name: URL
Type: java.lang.String
Value: jdbc racle:thin:@localhost:1521 rcl
Description: Oracle JDBC Url Resource (it is optional)
Step 3 is required for oracle database(properitary things).


Mahaveer<br />Singapore
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem when developing EJB using WSAD to config Oracle DataSource