Environment: Weblogic 5.1.0 , Oracle 8i. Driver: Thin Driver
I have put the Classes12.zip of Oracle in classpath. But Still when I run my
code I get the error
----------
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
java.lang.NullPointerException:
---------------------------
My code is as usual:
---------------------------
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:NEXTSTEP:1528:ORCL",
"MTS", "MTS");
----------------------
What could be the problem for this ???? I'm just practicing for myself, so
if somebody suggest me to use different driver to be able to connect to
Oracle then I am ready to do that.
Please help me.
-----Original Message-----
From: sharma Sumeet [mailto:[EMAIL PROTECTED]]
Sent: 02/15/2001 02:19
To: [EMAIL PROTECTED]
Subject: Re: Error in Connecting to Oracle
hi
which driver type r u using,,,,,,,,
sumeet
> -----Original Message-----
> From: Shukla, Amit [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 2:28 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Error in Connecting to Oracle
>
> I did change my path and now I'm getting this error
>
> ==========
> ...
> ...
> ---------- LOGIN ERROR CODE: 24327
> Wed Feb 14 13:24:38 CST 2001:<I> <JDBC Pool> Sleeping in createResource()
> Wed Feb 14 13:24:39 CST 2001:<E> <JDBC Pool> Failed to create connection
> pool "oraclePool"
> weblogic.common.ResourceException: weblogic.common.ResourceException:
> Could not create pool connection. The DBMS driver exception was:
> java.sql.SQLException: ORA-24327: need explicit attach before
> authenticating
> a user - (MTS/********)
>
> at
> weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:143)
> at weblogic.jdbcbase.oci.Driver.connect(Driver.java:157)
> at java.sql.DriverManager.getConnection(DriverManager.java:457)
> at java.sql.DriverManager.getConnection(DriverManager.java:137)
> at
> weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connecti
> on
> EnvFactory.ja
> va:172)
> at
> weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connecti
> on
> EnvFactory.ja
> va:109)
> at
> weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator
> .j
> ava, Compiled
> Code)
> at
> weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
> Compiled Code)
> at
> weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:3
> 30
> )
> at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
> Compiled Code)
> ...
> ...
> ====================================
>
> What could be the problem in this ???
>
> Amit
>
> -----Original Message-----
> From: kavitha Ramasamy [mailto:[EMAIL PROTECTED]]
> Sent: 02/12/2001 04:02
> To: [EMAIL PROTECTED]
> Subject: Re: Error in Connecting to Oracle
>
>
> Set your path to weblogic\bin\oci815_8 where weblogicoci dll file is
> residing.
>
> Kavitha.
> ----- Original Message -----
> From: "Shukla, Amit" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, February 12, 2001 4:20 PM
> Subject: Error in Connecting to Oracle
>
>
> > Hello,
> > This is the first time I'm trying to connect to Oracle from my
> > servlet on Weblogic 5.1. I have Oracle 8i on my machine. In the
> > Weblogic.properties file, I have added the following code:
> > =============
> > weblogic.jdbc.connectionPool.oraclePool=\
> > url=jdbc:weblogic:oracle,\
> > driver=weblogic.jdbc.oci.Driver,\
> > loginDelaySecs=1,\
> > initialCapacity=4,\
> > maxCapacity=10,\
> > capacityIncrement=2,\
> > allowShrinking=true,\
> > shrinkPeriodMins=15,\
> > refreshMinutes=10,\
> > testTable=dual,\
> > props=user=MTS;password=MTS;server=NEXTSTEP
> >
> > weblogic.allow.reserve.weblogic.jdbc.connectionPool.oraclePool=\
> > MTS
> > weblogic.allow.reset.weblogic.jdbc.connectionPool.oraclePool=\
> > MTS
> > weblogic.allow.shrink.weblogic.jdbc.connectionPool.oraclePool=\
> > MTS
> > ============================
> > When I run my Weblogic server it gives the following message:
> > =====================
> > ...
> > ...
> > Delaying 1 seconds before making a oraclePool pool connection.
> > java.sql.SQLException: System.loadLibrary threw
> > java.lang.UnsatisfiedLinkError
> > with the message 'no weblogicoci36 in java.library.path'.
> > at weblogic.jdbcbase.oci.Driver.connect(Driver.java:116)
> > at
> >
> weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connecti
> on
> > EnvFactory.ja
> > va:149)
> > at
> >
> weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connecti
> on
> > EnvFactory.ja
> > va:109)
> > at
> >
> weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator
> .j
> > ava, Compiled
> > Code)
> > at
> >
> weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
> > Compiled Code)
> > at
> >
> weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:3
> 30
> > )
> > at
> weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
> > Compiled Code)
> > at
> weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
> > at
> > weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
> > at java.lang.reflect.Method.invoke(Native Method)
> > at
> weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
> > at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java,
> > Compiled Code)
> > at
> >
> weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
> > Mon Feb 12 15:01:45 CST 2001:<I> <JDBC Pool> Sleeping in
> createResource()
> > Mon Feb 12 15:01:46 CST 2001:<E> <JDBC Pool> Failed to create connection
> > pool "oraclePool"
> > weblogic.common.ResourceException: weblogic.common.ResourceException:
> > Could not create pool connection. The DBMS driver exception was:
> > java.sql.SQLException: System.loadLibrary threw
> > java.lang.UnsatisfiedLinkError
> > with the message 'no weblogicoci36 in java.library.path'.
> > at weblogic.jdbcbase.oci.Driver.connect(Driver.java:116)
> > at java.sql.DriverManager.getConnection(DriverManager.java:457)
> > at java.sql.DriverManager.getConnection(DriverManager.java:137)
> > ....
> > ....
> > ==================================
> > That is why when I try to connect to oracle thrugh my code then it gives
> me
> > NullPointerException
> >
> > Could you please let me know, what special settings do I need to do for
> > WebLogic in order to Connect to Oracle.
> >
> > Thanks.
> >
> >
> __________________________________________________________________________
> _
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
