tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hassan" <hsaj...@ntlworld.com>
Subject Re: [OFF-TOPIC] Re: JDBC and MS Access DB connectivity.
Date Thu, 05 Jun 2003 21:25:41 GMT
Hi John,

>From the functional specs on
http://industry.java.sun.com/products/jdbc/drivers, EasySoft's driver does
not support DataSources!

>From Tomcat 4 documentation, it appears as you need to have a jar file
(physical copy) of the driver placed in common/lib directory in order for
Tomcat to set its classpath. Is this the case for built in generic drivers
also, such as sun.jdbc.odbc.

I'm getting the error ' Driver  not found in the classpath.' when I try
DataSource mechanism.

Hassan

----- Original Message -----
From: "John Turner" <tomcat-user@johnturner.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Thursday, June 05, 2003 9:48 PM
Subject: [OFF-TOPIC] Re: JDBC and MS Access DB connectivity.


>
> MS Access = bad bridge driver = bad
>
> If you must use MS Access, you will need a bridge driver.  The best you
can
> do is a Type 3 driver, like the one at easysoft.com.
>
> If that isn't an option, the Type 1 bridge driver is part of the Java 2
> SDK: package sun.jdbc.odbc.  Check the SDK docs.
>
> John
>
> On Thu, 5 Jun 2003 21:26:32 +0100, Hassan <hsajjad@ntlworld.com> wrote:
>
> > I'm trying to use DataSource objects (eventually connection pooling)
with
> > MS
> > Access Database.
> > My question is, do we have to have an ODBC-JDBC Bridge driver in place
in
> > $CATALINA_HOME/common/lib/ location for using javax.sql.DataSource
> > objects
> > to create connections to the database.
> > If so, where do I get this jar file for the driver?
> >
> > cheers
> > Hassan
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
>
>
>
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>



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


Mime
View raw message