Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need help configuring JDBC Realm on Tomcat 4.0.1

843859Jul 12 2006 — edited Jul 19 2006

I'm getting the following error:

(from DOS prompt)

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)

Here's my attempted configuration:

            <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
                 driverName="sun.jdbc.odbc.JdbcOdbcDriver"
                connectionURL="jdbc:odbc:DSNname@host_string:1521:ORCL?user=user_name;password=pwd_name"
                userTable="chg_users" userNameCol="user_name" userCredCol="user_pass"
                userRoleTable="chg_users_roles" roleNameCol="role_name" />

Any help would be appreciated!

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2006

Added on Jul 12 2006

#java-database-connectivity-jdbc

10 comments

118 views