Awesome! Glad I could help =) Now if I could find some good documentation on mod_jk ...
Kevin Andryc wrote: > You are right on the money :)! Thanks!! > > Kevin > > Kevin Andryc > Web Systems Engineer > MISER > http://www.umass.edu/miser/ > Phone: (413)-545-3460 > [EMAIL PROTECTED] > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Eddie Bush > Sent: Monday, July 01, 2002 11:41 AM > To: Tomcat Users List > Subject: Re: JDBC Realm with Oracle > > I don't use Oracle, so I could be way off - but it sounds like it doesn't > know > how to deal well with the URL you've provided. My suggestion would be to > try > using the connectionName="dbUsername" and connectionPassword="dbPassword" > attributes in your Realm element. > > HTH, > > Eddie > > Kevin Andryc wrote: > > > I have searched the archives, but I have not seen a solution. I keep > getting > > an error (shown below) when I try to use the JDBC Realm with Oracle. I can > > connect fine from within a Servlet, but not from the Realm. Here is my > code > > and the error: > > > > server.xml > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > > driverName="oracle.jdbc.driver.OracleDriver" > > > > > connectionURL="jdbc:oracle:thin:@oracle.server.priv:1521:oracledb?user=usr;p > > assword=pass" > > userTable="users" userNameCol="user_name" > > userCredCol="user_pass" > > userRoleTable="user_roles" roleNameCol="role_name" /> > > > > Error: > > Catalina.start: LifecycleException: Exception opening database > connection: > > jav > > a.sql.SQLException: invalid arguments in call > > LifecycleException: Exception opening database connection: > > java.sql.SQLExcepti > > on: invalid arguments in call > > at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) > > > > ) > > at > > org.apache.catalina.core.StandardService.start(StandardService.java:3 > > 88) > > 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.process(Catalina.java:179) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > > sorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) > > ----- Root Cause ----- > > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) > > at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857) > > at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:189) > > at > > oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246) > > > > at > > oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja > > va:365) > > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260) > > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) > > 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:3 > > 88) > > 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(DelegatingMethodAcces > > sorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) > > > > Thanks, > > Kevin > > > > Kevin Andryc > > Web Systems Engineer > > MISER > > http://www.umass.edu/miser/ > > Phone: (413)-545-3460 > > [EMAIL PROTECTED] > > > > -- > > 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]> > > -- > 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]>
