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 15:40:39 GMT
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>


Mime
View raw message