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 identifier so I dropped and recreated the username and password and role tables. Now, I'm not seeing much of an error, but getting this message in the access log. 165.xxx.xxx.xx - - [14/Jul/2006:18:07:54 -0600] "GET /chngctrl/admin/j_security_check?j_username=username&j_password=userpass HTTP/1.1" 302 654 Any thoughts? -----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 ojdbc14.jar http://download.oracle.com/otn/utilities_drivers/jdbc/9205/ojdbc14.jar I just set up a JDBCRealm the other day using it following the realm howto http://tomcat.apache.org/tomcat-5.5-doc/realm-howto.html and it worked like a charm. You can also easily create a datasource for your webapp and use it to get connections. http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html mas Propes, Barry L wrote: > precisely it is, as you typed below. > > I'd actually like to toss the JDBC-ODBC bridge software, as I've heard some > unstable things about it, maybe this included, but am a little uncertain as > to how to truly go about getting the Oracle driver I need. I don't claim to > be an expert on Oracle, but I downloaded two zip files - ora9018 and > ORA92065.zip. I unzipped these, but neither seems to place a new driver on my > machine, nor does it include an exe file that would ostensibly install such. > > I've also downloaded three different OTN zipped files, huge in nature, which > I think would install the connectivity client and other components, which I > already have on my machine. > > Is there a way to just "cherry pick" to the actual driver? And get it on the > box in question? The process doesn't seem to be real intuitive! > > Any feedback is appreciated, though! > > -----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: > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="sun.jdbc.odbc.JdbcOdbcDriver" > connectionURL="jdbc:odbc:DSNName" > connectionName="user_name" > connectionPassword="password" > userTable="chg_users" > userNameCol="user_name" > userCredCol="user_pass" > userRoleTable="chg_users_roles" > roleNameCol="role_name" /> > > You're orignal Realm won't work because you're mixing the Oracle schema > and the JDBC-ODBC bridge connection schema. If you use the JDBC-ODBC > bridge, you have to use a connection string for that driver. You could > (and this is MUCH better in my opinion) toss the JDBC-ODBC bridge > software and just use a true Oracle JDBC driver with a standard Oracle > connection string. > > --David > > Propes, Barry L wrote: > > >> 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 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 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 configuration doesn't work. >>> >>> For starters, I use the following driver and can connect regularly to do >>> inserts, selects and updates just fine. >>> >>> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); >>> String dbURL = "jdbc:odbc:DSNName"; >>> String usernm = "user_name"; >>> String pwd = "password"; >>> Connection connection = DriverManager.getConnection(dbURL, usernm, pwd); >>> >>> >>> Here are some errors I get when I do the following: >>> Configure the Realm like so: >>> --------- >>> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" >>> driverName="sun.jdbc.odbc.JdbcOdbcDriver" >>> connectionURL="jdbc:odbc:DSNName:@169.xxx.xx.xxx:1521:SID?user=user_name;password=password" >>> userTable="chg_users" userNameCol="user_name" userCredCol="user_pass" >>> userRoleTable="chg_users_roles" roleNameCol="role_name" /> >>> --------- >>> >>> Starting service Tomcat-Standalone >>> Apache Tomcat/4.0.1 >>> 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.ContainerBase.start(ContainerBase.java:1108) >>> >>> at >>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307 >>> ) >>> at >>> org.apache.catalina.core.StandardService.start(StandardService.java:3 >>> 88) >>> ---------------------------------------------------------------------------------------------------------------------- >>> Then, if I try configuring like the following: >>> ---------------------------------------------- >>> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" >>> driverName="sun.jdbc.odbc.JdbcOdbcDriver" >>> connectionURL="jdbc:odbc:DSNName:@169.xxx.xx.xxx:1521:SID.WORLD" (or >>> just SID w/o WORLD) >>> connectionName="user_name" >>> connectionPassword="password" >>> userTable="chg_users" userNameCol="user_name" userCredCol="user_pass" >>> userRoleTable="chg_users_roles" roleNameCol="role_name" /> >>> ------------------------------------------------- >>> >>> I get this error: >>> --------------------------- >>> >>> Starting service Tomcat-Standalone >>> Apache Tomcat/4.0.1 >>> Catalina.start: LifecycleException: Exception opening database connection: >>> jav >>> a.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name too >>> long >>> LifecycleException: Exception opening database connection: >>> java.sql.SQLExcepti >>> on: [Microsoft][ODBC Driver Manager] Data source name too long >>> at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615) >>> at >>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) >>> >>> at >>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307 >>> ) >>> .... >>> ----- Root Cause ----- >>> java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name >>> too lon >>> g >>> >>> --- >>> >>> >>> any help at all would be appreciated and if I went about posing my question >>> in the wrong manner I apologize and will be glad to receive instuctions on >>> the proper protocol >>> >>> Barry Propes >>> CitiFinancial Mortgage - >>> Workflow Enhancements Group >>> 972-657-1128 >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> --------------------------------------------------------------------- >> To start a new topic, e-mail: users@tomcat.apache.org >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> --------------------------------------------------------------------- >> To start a new topic, e-mail: users@tomcat.apache.org >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
