Christopher Schultz-2 wrote:
>
>
> This is a standard class that comes with the Sun JRE. There is no need
> for any additional JAR files.
>
> I would advise the OP to check online for how to connect Java to Access
> in general before adding Tomcat into the mix. Using MS Access requires
> you to setup an ODBC DataSource in Windows. Have you done that? Is it
> called "Auth"? The connection URL was "jdbc:odbc:Auth", so it should be.
>
>
Yes, sun.jdbc.odbc.JdbcOdbcDriver is in the Java distrubition rt.jar, and I
did not think it had to be added to Tomcat/common/lib, but I tried it
anyhow. It had no effect.
Yes, I did set up and configure a DSN, named Auth, in the ODBC Data source
administrator. I can connect to Auth via JDBC-ODBC from a stand alone Java
Application I wrote. I am able to access Auth it and display its tables. I
did state this in my original message.
The ODBC data source is definitely working, but I cannot get Tomcat to
connect to it. The driver sun.jdbc.odbc.JdbcOdbcDriver is definitely
working because I use it in my stand alone Java application to connect to
Auth and display its tables.
I do not seem to be able to get Tomcat to connect to any ODBC data source.
The ODBC administrator has a trace function. When I access Auth from my
stand alone Java App, it generates a bunch of log entries in the ODBC log.
When I start Tomcat, and try to open a secured document, zero entries are
generated in the ODBC log. It is as if Tomcat does not know ODBC exists.
Christopher Schultz-2 wrote:
>
>
> I've never used Access with Java (or by itself, for that matter), but
> I've seen connection URLs like this, too:
>
> "jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);
> DBQ=D:\\path_to_db\db.mdb;PWD=mypass"
>
> This appears to define it's own data source instead of requiring you to
> create one in the control panel.
>
>
The server.xml Realm entry which I used (below) was copied directly from the
original server.xml supplied with Tomcat, where it was commented out. I
commented out the Realm entry which directs Tomcat to use the
tomcat-users.xml file for authentication. All I did was change
"jdbc:odbc:CATALINA" to "jdbc:odbc:Auth", and edit the names of the tables
and columns to reflect my actual MSAccess database.
<Realm className="org.apache.catalina.realm.JDBCRealm"
driverName="sun.jdbc.odbc.JdbcOdbcDriver"
connectionURL="jdbc:odbc:Auth"
userTable="User" userNameCol="UserName" userCredCol="Password"
userRoleTable="User_Role" roleNameCol="RoleName" />
Do I need to make some other entry in server.xml? Do I need to make an
entry in some other configuration file?
Thanks for any additional hints you can provide.
--
View this message in context:
http://www.nabble.com/Using-MSAccess-database-for-container-authentication-tf4249487.html#a12097330
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
