File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC Driver as Jar file??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Driver as Jar file???" Watch "JDBC Driver as Jar file???" New topic
Author

JDBC Driver as Jar file???

Sven Anderson
Ranch Hand

Joined: Apr 14, 2004
Posts: 58
Hi,
I'm using Tomcat writing a simple Tomcat application. Im also using Tomcat JDBC Realm authentication. In the instruction manual it says:
Place a copy of the JDBC driver you will be using inside the $CATALINA_HOME/server/lib directory (if you do not need it visible to web applications) or $CATALINA_HOME/common/lib (if it will be used both by Tomcat 4 and by your apps). Note that only JAR files are recognized!
This is the driver my using accessing my Ms Access database sun.jdbc.odbc.JdbcOdbcDriver
But where can I find the JAR-file Im supposed to copy?
Regards
Erik
Nathaniel Stoddard
Ranch Hand

Joined: May 29, 2003
Posts: 1258
Erik,
Have you tried doing a google search for that term? Or perhaps a search of Microsoft's website?


Nathaniel Stodard<br />SCJP, SCJD, SCWCD, SCBCD, SCDJWS, ICAD, ICSD, ICED
Raj Chila
Ranch Hand

Joined: Mar 18, 2004
Posts: 128

Hi,
I think what you are refering to is a driver that uses the native ODBC to communicate with the database, typically the Driver and the Database should reside on the same machine. The JDBC driver that communicates with the ODBC is bundled along with the jre, so you it will be automatically visible to the tomcat instance and to all the applications that are running.
so all you need is you create a ODBC System DSN for your Database and that write your connection related stuff. and it should work.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Driver as Jar file???