tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Andryc <kand...@miser.umass.edu>
Subject RE: JDBC Realm with Oracle
Date Mon, 01 Jul 2002 20:55:16 GMT
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>


Mime
View raw message