tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randy Layman <randy.lay...@aswethink.com>
Subject RE: Connecting to a database
Date Tue, 02 Jan 2001 16:25:38 GMT

	Any database that you can connect to using Java you can connect to
in Tomcat.  Like all software problems, this one probably has many
solutions, but the only one I know of is the JDBC-ODBC bridge (a url like
jdbc:odbc:<ODBC Name>).  These classes are installed as part of the JVM (its
optional so check your release to see if its there).  More information is on
the JavaSoft site about JDBC at http://java.sun.com/products/jdbc/index.html
and http://java.sun.com/j2se/1.3/docs/guide/jdbc/index.html.  One thing to
note, at least on Windows, the DLL is not thread safe and will cause you a
number of problems if you try and execute 2 commands (even in 2 different
connections) at the same time.  I'm unsure if this problem exists on Solaris
(the JDBC website implies that it has been implemented for Solaris, but I've
never used it).

	Yes, Access can be accessed using SQL.  It doesn't support the more
complicated stuff that you can do in SQL Server (i.e. Transactions and
Stored Procedures), but it supports enough that you can generally get the
job done.

	Randy

-----Original Message-----
From: Mick Sullivan [mailto:micksul@hotmail.com]
Sent: Tuesday, January 02, 2001 11:42 AM
To: tomcat-user@jakarta.apache.org
Subject: Connecting to a database


Dows anyone know how to connect to say an access database using tomcat
Can you use SQL on access??
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, email: tomcat-user-help@jakarta.apache.org

Mime
View raw message