File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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.
 
Consider Paul's rocket mass heater.
 
subject: Connection Pool :Error