tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Perry" <cpe...@sddpc.org>
Subject Re: JDBCRealm and Oracle Not working
Date Mon, 20 May 2002 19:54:52 GMT
Ok, you need to put the classes12_01.jar file in the ~/common/lib dir also.

On install, the classes12_01.jar is in the ~/lib, which is NOT enough to get the JDBCRealm
working
with Oracle.

WHY you need that jar in both places:
~/lib  and  ~/common/lib is still a mystery/issue!

Could anyone shed some like on this issue?

PS:
Here is a interesting discussion on this issue:
http://groups.google.com/groups?q=Tomcat+Realm+4&hl=en&lr=&ie=UTF8&oe=UTF8&selm=5Rzc8.12%24U83.40693%40mencken.net.nih.gov&rnum=3



Thanks!

-CP


>>> chadhperry@hotmail.com 05/20/02 07:22AM >>>
By default the drvier (classes12_01.jar) is placed in Apache Tomcat 4.0\lib.

I can connect to Oracle just fine in a JSP or servlet!

It is the JDBCRealm functionality that is broken. :-(

-Late


>From: Umberto Nicoletti <unicoletti@arpa.veneto.it>
>Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>To: Tomcat Users List <tomcat-user@jakarta.apache.org>
>Subject: Re: JDBCRealm and Oracle Not working
>Date: Mon, 20 May 2002 09:40:53 +0200
>MIME-Version: 1.0
>Received: from [192.18.49.131] by hotmail.com (3.2) with ESMTP id 
>MHotMailBEB1F421001340043721C0123183E4A90; Mon, 20 May 2002 00:43:34 -0700
>Received: (qmail 5127 invoked by uid 97); 20 May 2002 07:43:22 -0000
>Received: (qmail 5115 invoked by uid 98); 20 May 2002 07:43:22 -0000
>>From tomcat-user-return-20073-chadhperry Mon, 20 May 2002 00:45:26 -0700
>Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
>Precedence: bulk
>List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
>List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
>List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
>List-Post: <mailto:tomcat-user@jakarta.apache.org>
>List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
>Delivered-To: mailing list tomcat-user@jakarta.apache.org 
>X-Antivirus: nagoya (v4198 created Apr 24 2002)
>Message-ID: <3CE8A885.DD41C1B7@arpa.veneto.it>
>X-Mailer: Mozilla 4.74 [en] (WinNT; U)
>X-Accept-Language: en
>References: <F146ZqbzaFBGZTqQZoo00003f12@hotmail.com>
>X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
>
>Hi,
>You must put the jdbc driver in a place where tomcat can find it.
>As of my experience a suitable place is TOMCAT_HOME/lib or common/lib
>(or something like that).
>
>Regards,
>umberto
>
>Chad Perry wrote:
> >
> > Trying to get Oracle 8i to work with with the JDBCRealm:
> > Tomcat 4.0.4b3
> > JDK 1.4.0
> > OS Win2000 Server
> >
> > I guess tomcat-JDBCRealm doesn't work with Oracle? It would be AWESOME 
>if I
> > could get this
> > to work! Could somebody verify that I'm not dorking out? Thanks!!
> >
> > Here is my Realm element:
> >
> >       <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> >
> >                driverName="oracle.jdbc.driver.OracleDriver"
> >
> >                
>connectionURL="jdbc:oracle:thin:@192.168.0.10:1521:TestDB"
> >
> >                connectionName="XXXXX"
> >
> >                connectionPassword="XXXXX"
> >
> >                userTable="GOLDEN.APP_USER" userNameCol="USER_NAME"
> > userCredCol="PASSWORD_TXT"
> >
> >                userRoleTable="GOLDEN.APP_ROLE" roleNameCol="ROLE_NAME"/>
> >
> > EXCEPTION BELOW - Occurs on Start up:
> >
> > Starting service Tomcat-Standalone
> > Apache Tomcat/4.0.4-b3
> > Starting service Tomcat-Apache
> > Apache Tomcat/4.0.4-b3
> > Catalina.start: LifecycleException:  Exception opening database 
>connection:
> > java.sql.SQLException:
> > oracle.jdbc.driver.OracleDriver
> > LifecycleException:  Exception opening database connection:
> > java.sql.SQLException: oracle.jdbc.driv
> > er.OracleDriver
> >         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
> >         at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
> >         at
> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
> >         at
> > org.apache.catalina.core.StandardService.start(StandardService.java:388)
> >         at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
> >         at 
>org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
> >         at 
>org.apache.catalina.startup.Catalina.process(Catalina.java:179)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at
> > 
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at
> > 
>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:324)
> >         at 
>org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
> > ----- Root Cause -----
> > java.sql.SQLException: oracle.jdbc.driver.OracleDriver
> >         at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538)
> >         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
> >         at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
> >         at
> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
> >         at
> > org.apache.catalina.core.StandardService.start(StandardService.java:388)
> >         at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
> >         at 
>org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
> >         at 
>org.apache.catalina.startup.Catalina.process(Catalina.java:179)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at
> > 
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at
> > 
>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:324)
> >         at 
>org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
> >
> > MISC RESEARCH:
> >
> > The bug report belows makes me think this is still an issue even
> > in Apache Tomcat/4.0.4-b3:
> > http://nagoya.apache.org/bugzilla/show_bug.cgi?id=5660 
> >
> > _________________________________________________________________
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx 
> >
> > --
> > To unsubscribe, e-mail:   
><mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail: 
><mailto:tomcat-user-help@jakarta.apache.org>
>
>--
>Umberto Nicoletti - unicoletti@arpa.veneto.it | sysmaster@arpa.veneto.it 
>Tel. 049-8239380 (assistenza)
>
>"We'll try to make different mistakes this time." - Larry Wall
>
>--
>To unsubscribe, e-mail:   
><mailto:tomcat-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: 
><mailto:tomcat-user-help@jakarta.apache.org>
>




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>




--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message