Return-Path: <cw288@hotmail.com>
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 84773 invoked from network); 8 Nov 2000 19:34:26 -0000
Received: from f309.pav1.hotmail.com (HELO hotmail.com) (64.4.30.184)
  by locus.apache.org with SMTP; 8 Nov 2000 19:34:26 -0000
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Wed, 8 Nov 2000 11:34:00 -0800
Received: from 192.31.86.34 by pv1fd.pav1.hotmail.msn.com with HTTP;
	Wed, 08 Nov 2000 19:33:59 GMT
X-Originating-IP: [192.31.86.34]
From: "c cw288" <cw288@hotmail.com>
To: tomcat-user@jakarta.apache.org
Subject: Re: FW: How to connect JDBC-ODBC in Tomcat
Date: Wed, 08 Nov 2000 14:33:59 EST
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F309kvdIBirXXeQM7gy00002a55@hotmail.com>
X-OriginalArrivalTime: 08 Nov 2000 19:34:00.0176 (UTC)
 FILETIME=[D7ED1F00:01C049BA]
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

Hi Maurice,

In web.xml, I replaced following param names.
What do you meant by param-value?

<init-param>
        <param-name>sun.jdbc.odbc.JdbcOdbcDriver</paramName> //This is the 
driver class
        <param-value>my.driver.ClassName</param-value>  //???
</init-param>

<init-param>
        <param-name>jdbc:odbc:TrainDatabase</paramName>  // This is my 
database name (url)
        <param-value>jdbc:my_url</param-value>           //??
</init-param>


In my Java servlet program, I declared my drive and url as followed:

    private String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
    private String dbURL = "jdbc:odbc:TrainDatabase";

Thanks,



>
> > -----Original Message-----
> > From:	Maurice le Rutte [SMTP:maurice@lerutte.net]
> > Sent:	Tuesday, November 07, 2000 3:07 PM
> > To:	tomcat-user@jakarta.apache.org
> > Subject:	Re: How to connect JDBC-ODBC  in Tomcat
> >
> > -----Oorspronkelijk bericht-----
> > >Hi All,
> > >
> > >I have an Applet-Servlet application that work on Java Web Server
> > >engine and can access the Access database through JDBC-ODBC (System 
>DSN).
> > >
> > >When I placed my application on Tomcat and run it, it does not know
> > >where to look for the database. How I do setup this connection so that
> > >my application will run as is it run on Java Web Server?
> >
> >
> > Just specify the init params in your web.xml. For example:
> >
> > In web.xml:
> >
> > <init-param>
> >         <param-name>jdbc.driverclass</paramName>
> >         <param-value>my.driver.ClassName</param-value>
> > </init-param>
> >
> > <init-param>
> >         <param-name>jdbc.url</paramName>
> >         <param-value>jdbc:my_url</param-value>
> > </init-param>
> >
> > <init-param>
> >         <param-name>jdbc.username</paramName>
> >         <param-value>me</param-value>
> > </init-param>
> >
> > <init-param>
> >         <param-name>jdbc.password</paramName>
> >         <param-value>secret</param-value>
> > </init-param>
> >
> > For access you use the sun.jdbc.JdbcOdbcBridge class and the url is
> > jdbc:odbc:DSN. You donut need a user/password.
> >
> > Maurice le Rutte.

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.