u set the classpath to orcledriver classses which are in oracle installed
folder.
myoracle/orant/jdbc/lib/classes12.zip or anyother type of driver which u
need. ( this is oracle thin driver )
u can connect to oracle thin driver using the code
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
databaseConnection =
DriverManager.getConnection("jdbc:oracle:thin:@ORACLE_SERVER_NAME:PORT:SERVICE_NAME","USERNAME","PASSWORD");
Hope this helps
ram
>From: sharma Sumeet <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Error in Connecting to Oracle
>Date: Thu, 15 Feb 2001 13:49:08 +0530
>
>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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
___________________________________________________________________________
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
