Mark, On that .jar file link file, where do I extract all of that to? Or do I just save it as a .jar? Last night I clicked the link and immediately it wants to pop up a dialog box and have me save it as a .zip file. Do I need to rename it to a .jar?
Thanks, Barry -----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]
