tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Umberto Nicoletti <unicole...@arpa.veneto.it>
Subject Re: JDBCRealm and Oracle Not working
Date Tue, 21 May 2002 07:29:11 GMT


Chad Perry wrote:
> 
> 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?

I am reporting (hope I got it right) what I learned form earlier
threads:

lib is for jar that you want tomcat to load
common/lib is for jars that you want tomcat AND your app to load
WEB-INF/lib is for jars that you want your app to load

> 
> 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>

-- 
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>


Mime
View raw message