This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tomcat JDBC Realm using MS Access DB

 
ZouK kie
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic