Tomcat 4.1 Issue

From: Ed (edzackery_at_hotmail.com)
Date: 01/20/04 

Date: Tue, 20 Jan 2004 15:56:11 GMT

Trying to connect to two different databases and utilizing the password
protection in my application using similar code below:

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="sun.jdbc.odbc.JdbcOdbcDriver"
          connectionURL="jdbc:odbc:Test"
          connectionName="anything"
          connectionPassword="anything"
          digest="SHA"
          userTable="Users" userNameCol="UserName"
userCredCol="UserPassword"
          userRoleTable="Users" roleNameCol="RoleTomcat" />

 <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="sun.jdbc.odbc.JdbcOdbcDriver"
          connectionURL="jdbc:odbc:Test2"
          connectionName="anything"
          connectionPassword="anything"
          digest="SHA"
           userTable="Users" userNameCol="UserName"
userCredCol="UserPassword"
          userRoleTable="Users" roleNameCol="RoleTomcat" />

When I use the above code it only authenticates against the first database
via the ODBC connection Test and not Test2.

Essentially what I want to do is to declare more then one connectionURL
because all the other information is the same. Is this possible or am I on
the wrong track?

Thanks for any help!

Ed

Relevant Pages

  • Tomcat 4.1 Issue
    ... Trying to connect to two different databases and utilizing the password ... protection in my application using similar code below: ... via the ODBC connection Test and not Test2. ...
    (comp.lang.java.programmer)
  • Re: Can a multi user Access db be used via Terminal Services?
    ... What of databases were multiple users were in, but not utilizing the ... One of the current backlashes we're getting from our IT group is that ...
    (comp.databases.ms-access)
  • Re: Copyrighted Game Records
    ... AFAIK there is not much protection for databases of non-copyrighted facts ...
    (rec.games.go)