This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
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.
Joined: Jan 08, 2003
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 220.127.116.11.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
Joined: Jul 18, 2001
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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com