Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem when developing EJB using WSAD to config Oracle DataSource

 
henry_cui
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic