aspose file tools*
The moose likes BEA/Weblogic and the fly likes Connection Pool :Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Connection Pool :Error " Watch "Connection Pool :Error " New topic
Author

Connection Pool :Error

Anand Kuwadia
Greenhorn

Joined: Jan 08, 2003
Posts: 3
While trying to create a connection pool in weblogic6.1 using the following configuration settings
URL jdbc.weblogic.oracle
Driver Classname weblogic.jdbc.oci.Driver
properties user-...
server-...
passwd ...
I am not able to create an active connection pool
I get the following error
java.lang.reflect.InvocationTargetException: weblogic.management.DistributedManagementException: Distributed Management [1 exceptions]
Can any one help
Anand
Ajith Kallambella
Sheriff

Joined: Mar 17, 2000
Posts: 5782
Moving this discussion to BEA/WebLogic forum.....


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
There is some configuration involved when using the JDriver. Take a look at this document: Installing WebLogic jDriver for Oracle.
If you still can't get it to work then write back and I go step by step.
Anand Kuwadia
Greenhorn

Joined: Jan 08, 2003
Posts: 3
hi,Chris
I have followed all the steps in proper order,yet I am getting some errors
Let me List the steps I have followed
I have Win NT m/c with Oracle 8.1.6.0.0 and bea weblogic server6.1
1] I have set the System Path to include the directory that contains my driver
i.e I have included
c:\bea\wlserver6.1\bin\oci817_8
in my path.
2] Also I have included the directory in which vendor-supplied libraries from Oracle reside

D:\Oracle\Ora81\bin
3] Also included the following in System Classpath for weblogic files
C:\bea\wlserver6.1\lib\weblogic.jar
4] Have Put the 2 files tnsnames.ora and listener.ora reqd by oracle(With appropriate descriptors) in Ora\admin\..
5] Tried to create a connection Pool through Weblogic Console(With proper configuration details)

But got the error

Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating a user


Please Help
Anand
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Originally posted by Anand Kuwadia:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating a user

This means that you database connection information for Oracle (in tnsnames.ora and/or sqlnet.ora) is wrong. Do a tnsping from commandline on the Oracle SID you are trying to connect to from WebLogic. Most likely it will fail. Resolve that issue and you should be set.
 
 
subject: Connection Pool :Error