RE: JDBC Realm error

2006-07-14 Thread Propes, Barry L
I got the error solved with this, Mark. Thanks so much. At least the actual JDBC realm error has been resolved. However, I'm not gaining access to the Oracle DB tables for some reason. I had gotten one user in the log about java.sql.SQLException: ORA-00904: "USER_NAME": invalid

RE: JDBC Realm error

2006-07-14 Thread Propes, Barry L
- From: Mark Shifman [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 5:03 PM To: Tomcat Users List Subject: Re: JDBC Realm error The oracle driver library that seems to work is ojdbc14.jar http://download.oracle.com/otn/utilities_drivers/jdbc/9205/ojdbc14.jar I just set up a JDBCRealm the

RE: JDBC Realm error

2006-07-13 Thread Propes, Barry L
thanks, Mark. What about ojdbc14_g? That's what I have. Would that work? -Original Message- From: Mark Shifman [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 5:03 PM To: Tomcat Users List Subject: Re: JDBC Realm error The oracle driver library that seems to work is ojdbc1

Re: JDBC Realm error

2006-07-13 Thread Mark Shifman
le) and then quickly disappears! -Original Message- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 3:00 PM To: Tomcat Users List Subject: Re: JDBC Realm error Why don't you try using the same dbURL you use in the java code -- "jdbc:odbc:DSNName". A

RE: JDBC Realm error

2006-07-13 Thread Propes, Barry L
h! -Original Message- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 3:19 PM To: Tomcat Users List Subject: Re: JDBC Realm error Is your Realm configured as follows: You're orignal Realm won't work because you're mixing the Oracle schema and the J

Re: JDBC Realm error

2006-07-13 Thread David Smith
age- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 3:00 PM To: Tomcat Users List Subject: Re: JDBC Realm error Why don't you try using the same dbURL you use in the java code -- "jdbc:odbc:DSNName". Also add in the attributes connectionName for the

RE: JDBC Realm error

2006-07-13 Thread Propes, Barry L
well, Tomcat didn't like that at all! It tries to come up (the console) and then quickly disappears! -Original Message- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 3:00 PM To: Tomcat Users List Subject: Re: JDBC Realm error Why don't you try usin

RE: JDBC Realm error

2006-07-13 Thread Propes, Barry L
Realm error Why don't you try using the same dbURL you use in the java code -- "jdbc:odbc:DSNName". Also add in the attributes connectionName for the auth username to the database and connectionPassword for the auth password to same. --David Propes, Barry L wrote: >I

Re: JDBC Realm error

2006-07-13 Thread David Smith
Why don't you try using the same dbURL you use in the java code -- "jdbc:odbc:DSNName". Also add in the attributes connectionName for the auth username to the database and connectionPassword for the auth password to same. --David Propes, Barry L wrote: I'm not sure if this is the method of

JDBC Realm error

2006-07-13 Thread Propes, Barry L
I'm not sure if this is the method of which to go about posting my problem or issue, but here goes. I've tried configuring my JDBC realm in Tomcat 4.0.1 the last 2 days with no success. Sure, I can mess up the app or get the protection to engage and kick to a login page, but my Oracle configu