Thanks for the reply. NOTE: You would think that the JDBCRealm would only need the Oracle driver in the ~/lib dir?
Also, I would wish the Java Exception would be something like a "DRIVER NOT FOUND EXCEPTION" instead of an "incorrect exception" that makes you think it is something else... In fact I'm a little confused that the stack trace would include: "java.sql.SQLException: oracle.jdbc.driver.OracleDriver" (See below) This makes me think it is indeed some kind of CLASS LOADING issue? Because if the driver was indeed in the wrong place how could the stack trace find the java.sql.SQLException: oracle.jdbc.driver.OracleDriver Exception? hmmmm When I get time I'm going to get into the code on this one.... -CP >>> [EMAIL PROTECTED] 05/21/02 12:29AM >>> 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 > > >>> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >To: Tomcat Users List <[EMAIL PROTECTED]> > >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 [EMAIL PROTECTED]; run by ezmlm > >Precedence: bulk > >List-Unsubscribe: <mailto:[EMAIL PROTECTED]> > >List-Subscribe: <mailto:[EMAIL PROTECTED]> > >List-Help: <mailto:[EMAIL PROTECTED]> > >List-Post: <mailto:[EMAIL PROTECTED]> > >List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org> > >Delivered-To: mailing list [EMAIL PROTECTED] > >X-Antivirus: nagoya (v4198 created Apr 24 2002) > >Message-ID: <[EMAIL PROTECTED]> > >X-Mailer: Mozilla 4.74 [en] (WinNT; U) > >X-Accept-Language: en > >References: <[EMAIL PROTECTED]> > >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:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > ><mailto:[EMAIL PROTECTED]> > > > >-- > >Umberto Nicoletti - [EMAIL PROTECTED] | [EMAIL PROTECTED] > >Tel. 049-8239380 (assistenza) > > > >"We'll try to make different mistakes this time." - Larry Wall > > > >-- > >To unsubscribe, e-mail: > ><mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: > ><mailto:[EMAIL PROTECTED]> > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- Umberto Nicoletti - [EMAIL PROTECTED] | [EMAIL PROTECTED] Tel. 049-8239380 (assistenza) "We'll try to make different mistakes this time." - Larry Wall -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
