• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

URGENT! problem with Oracle ConnectionPoolDataSource

 
Himal Chuli
Ranch Hand
Posts: 118
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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\classes12.zip
JNDI name = jdbc/OracleDatasource
Created the following 3 Resource Properties (the panel underneath the Datasource panel)
A) serverName
java.lang.String
kirant
B) URL
java.lang.String
jdbc racle:thin:@kirant:1521:jaguar
Note:jaguar is my database name

C) portNumber
java.lang.Integer
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?
thanks.
 
thakur thakur
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
-Thakur
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic