Oracle Access through Sun J2EE Server

[mobilop]

I'm using Sun J2EE Server 1.3 and Oracle 8.1.7
I am trying to use an EJB to access Oracle DB with the Thin Driver, specified via JNDI lookup:
jdbcracle:thin:scott/tiger@localhost:1521rcl8
Using this URL in a standard Java program works perfect.
The code inside the EJB is taken from an example and works perfect with Cloudscape Database:
DataSource ds = (DataSource) ic.lookup(dbName);
con = ds.getConnection();
However using oracle, i get a javax.ejb.CreateException Exception, saying that not specifying any user name and password in thin driver is not supported which doesnt make any sense, since this data is provided in the url.

thanks for your help.

"javax.ejb.CreateException: Keine Benutzer- oder Kennwortangabe in THIN-Treiber nicht unterstuetzt"

 

[MiddlewareOnline]

Why don't you use connection pool feature and define a data source to this connection. That should work inside the BEAN.

MiddlewareOnline.COM

http://www.MiddlewareOnline.com

IBM MQ Series Certified Consultants
A SARVAM PORTAL

http://www.SarvamInc.com