Forums Register Login

JDBC Driver as Jar file???

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Erik,
Have you tried doing a google search for that term? Or perhaps a search of Microsoft's website?
+Pie Number of slices to send: Send
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.
Can't .... do .... plaid .... So I did this tiny ad instead:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 969 times.
Similar Threads
javax. servlet. ServletException: Name myoracle is not bound in this Context
Cannot create JDBC driver of class '' for connect URL 'null'
connectionURL to SQL Server 2005
tomcat and jndi resource
Application Classpath
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 06:23:42.