The moose likes Tomcat and the fly likes Tomcat JDBC Realm using MS Access DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat JDBC Realm using MS Access DB" Watch "Tomcat JDBC Realm using MS Access DB" New topic

Tomcat JDBC Realm using MS Access DB

ZouK kie

Joined: May 26, 2004
Posts: 2
Hi everyone,

I have a question hopes to be resolved.

I'm currently working on Tomcat server side security management using MS access database instead of mysql/oracle/etc. I have came across informations that databases such as mysql requires certain driver *.jar that needed to be placed into common/lib dir in tomcat inorder for the JDBCRealm to work.

Can anyone advice me on how exactly JDBCRealm works with MS access? Does it need any driver or just set through the control panel - DSN setting for driver? Do we need to downloand any MS Access .jar file to be placed in Tomcat common/lib dir?

I would appreciate if anyone happens to do the task of JDBCRealm with MS access database to advise me on the steps to succesfully setting up the security login for different users/roles. As i have tried to search through websites regarding informations on the "JDBCRealm using MS access database", i have none or zero results related to my doubts instead, i find most of helps focus on JDBCRealm using MySQL db/ Oracle Db.

I thank you anyone who view this thread.
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

to work with MS Access, there are a number of third-party database drivers (ie: those jar files you asked about).

However, there's also one provided by sun in the jdk. It's the jdbc-odbc bridge driver. Its use is *strongly* discouraged in a production environment. However, if you're only testing or learning, it might be alright.

Since it's included in the JDK, you won't need to download additional jars.
I agree. Here's the link:
subject: Tomcat JDBC Realm using MS Access DB
jQuery in Action, 3rd edition