Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

jDriver/Oracle help

0 views
Skip to first unread message

Garvin F. Dean

unread,
Mar 29, 2001, 7:51:53 PM3/29/01
to
I've got an Oracle connection pool and I'm trying to test the connection
with dbping and I keep getting a login exception. I can definitely
attach to the db via sqlplus with the user/password, but have no joy
with weblogic. Here's the error:

LOGIN ERROR CODE: 24327

java.sql.SQLException: ORA-24237: need explicit attach before
authenticating a user - (username/*********@xxx.yyy.zzz.nnn:1521:DBNAME)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:161)
...

my configuration is:

wls 6.0
linux (mandrake)
oracle 8i

url: jdbc:oracle:thin:@xxx.yyy.zzz.nnn:1521:DBNAME
driver classname: oracle.jdbc.driver.OracleDriver

testtable=dual
Properties
user=username
password=password
dll=ocijdbc8
protocol=thin

All help will be greatly appreciated! I'm in a crunch for time, so
please help as soon as possible.

garvin.vcf

Garvin F. Dean

unread,
Mar 29, 2001, 8:16:35 PM3/29/01
to

ORACLE_HOME is set properly and the release is 8.1.7.0.0

Thanks!

garvin.vcf

Manmari

unread,
Jun 21, 2001, 5:37:12 PM6/21/01
to
Did you find a solution for this? if you did, please post. I also have the
same problem.


"Garvin F. Dean" <gar...@gfdeaninc.com> wrote in message
news:3AC3DE73...@gfdeaninc.com...

Manak Pushkarna

unread,
Jun 22, 2001, 9:03:10 AM6/22/01
to

Hi,
For your Connection pool go to configurations>connections>
specify some values for all the enteries and restart ur server.
Check for ur name bindings also.
Hope this solves ur query.
0 new messages