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]
