Tommi I had this exact problem last night, and solved it (eventually). I'd need to check my code (I'm at work, with Jrun, not at home with Tomcat!) but I think the connectionURL needs to lose the user and password, and you need to add two additional name/value pairs to <Realm...> : connectionUser and connectionPassword (I think: check the JDBC-Realm docs).
Check the docs, give that a try, and if it doesn't work let me know (though I doubt I'll be able to answer before Monday - sorry!). Best of luck John John Niven > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: 18 January 2002 15:11 > To: [EMAIL PROTECTED] > Subject: AW: problems with JDBCRealm and oracle > > > Hello Michael! > Yes I'm able to connect to Oracle with scott/tiger@db02, but > the realm doesn't work. Thanks tommi > > -----Urspr�ngliche Nachricht----- > Von: Michael Wentzel [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 18. Januar 2002 14:11 > An: 'Tomcat Users List' > Betreff: RE: problems with JDBCRealm and oracle > > > > My tomcat 4.0.1 runs on a WinNT-machine. In server.xml i' > > have configured a > > JDBC Realm with the following code: > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > > driverName="oracle.jdbc.driver.OracleDriver" > > > > connectionURL="jdbc:oracle:thin:@iv003866:1521:db02?user=scott > > ;password=tige > > r" > > userTable="users" userNameCol="user_name" > > userCredCol="user_pass" > > userRoleTable="user_roles" roleNameCol="role_name" /> > > > > But when I try to start tomcat I get the following error messages: > > Catalina.start: LifecycleException: Exception opening > > database connection: > > a.sql.SQLException: Ung�ltige Argumente in Aufruf (= invalid > > arguments when > > calling) > > LifecycleException: Exception opening database connection: > > java.sql.SQLExce > > on: Ung�ltige Argumente in Aufruf > > at > > org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) > > at > > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:11 > > Are you able to log into that database directly through the > oracle admin tools using that username and password? > > > --- > Michael Wentzel > Software Developer > Software As We Think - http://www.aswethink.com > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > ************************************************************** > ************ > Diese E-Mail und angehaengte Dateien sind vertraulich und > ausschliesslich > fuer den oder die als Empfaenger eingetragenen Personen > bestimmt. > Sollten Sie diese Nachricht aufgrund eines Fehlers oder > Irrtums > erhalten haben, informieren Sie bitte den Systemverwalter > oder Absender > der Nachricht. > > > > Diese Fussnote bestaetigt auch, dass diese E-Mail auf Viren > ueberprueft > wurde. Dies stellt jedoch keine Garantie auf voellige > Virenfreiheit dar. > > > Bayerische Versorgungskammer > http://www.versorgungskammer.de ************************************************************************** -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
