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]
