tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eddie Bush <ekb...@swbell.net>
Subject Re: JDBC Realm with Oracle
Date Mon, 01 Jul 2002 16:13:06 GMT
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
> kandryc@miser.umass.edu
>
> -----Original Message-----
> From: adabbs@mta1.rcsntx.swbell.net [mailto:adabbs@mta1.rcsntx.swbell.net]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
> > kandryc@miser.umass.edu
> >
> > --
> > 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>
>
> --
> 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