File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes URGENT! problem with Oracle ConnectionPoolDataSource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "URGENT! problem with Oracle ConnectionPoolDataSource" Watch "URGENT! problem with Oracle ConnectionPoolDataSource" New topic

URGENT! problem with Oracle ConnectionPoolDataSource

Himal Chuli
Ranch Hand

Joined: Aug 06, 2002
Posts: 118
hi folks,
i am trying to implement EJB in WSAD and Oracle8i. I created a CMP entity bean and bound with the follwing:
Implementation Class = oracle.jdbc.pool.OracleConnectionPoolDataSource
URL prefix = jdbc racle
Classpath = C:\Oracle\Ora90\jdbc\lib\
JNDI name = jdbc/OracleDatasource
Created the following 3 Resource Properties (the panel underneath the Datasource panel)
A) serverName
jdbc racle:thin:@kirant:1521:jaguar
Note:jaguar is my database name

C) portNumber
1521 (default)
i tried testing my sessionbean that access the CMP entity bean. gives me the following error:

i am just lost here. could you please tell me what's wrong going on here?

thakur thakur

Joined: Dec 06, 2002
Posts: 9
You would have given type of the URL property as String make it java,lang.String and also 'url' should be URL in capitals which you have I guess.
I don't think that you need to give the port as a property as you can give the complete JDBC conenct string inside the URL.
I agree. Here's the link:
subject: URGENT! problem with Oracle ConnectionPoolDataSource
It's not a secret anymore!