tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Ruby <st...@rubysolutions.com>
Subject Re: database connection problem when run nt service
Date Tue, 19 Dec 2000 23:47:10 GMT

Make sure the DSN you are trying to get to is a System DSN and not
a User DSN,  tomcat will run as a different user when run as a service
unless you specify otherwise. User DSN can only be seen by the user
it was created by.


H Deng wrote:
> 
> Thanks for the tip. It does not seem to be related with the user permission
> since the same code works fine when tomcat is running as a stand alone
> application(startup). The problem only appears when tomcat is running as a
> service(net start jakarta). The exception I get is
> 
> java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified.
> 
> >From: Jared Clinton <JaredC@esd.nec.com.au>
> >
> >I am extremly new to tomcat, although I suspect that it is to do with the
> >NT
> >user that tha service logs in as and the permissions in the database that
> >the user has?
> >
> >?Stab in the dark?
> >
> >Jared Clinton.
> >
> > > -----Original Message-----
> > > From: H Deng [mailto:deng_h1579@hotmail.com]
> > > Sent: Tuesday, 19 December 2000 17:10
> 
> > > Hi everyone, I installed apache 1.3.4 and tomcat 3.2.1 on
> > > windows NT4.0
> > > /windows 2000 and tried to set up tomcat to run NT service. I used
> > > mod_jk.dll to test a simple java code to connect to a database and it
> > > worked fine. However, when I tried to use jk_nt_service.exe,
> > > other part
> > > of the the java program can run but the connection to the
> > > database can't
> > > be establised. The following code gives a SQLException:
> > >
> > > dbCon =3D DriverManager.getConnection("jdbc:odbc:book");
> > >
> > > but the same code worked fine with mod_jk.dll.
> > >
> > > I tried to put rt.jar (which contains DriverManager.class) in the
> > > classpath in wrapper.properties:
> > >
> > > wrapper.class_path=3D$(wrapper.java_home)\jre\lib\rt.jar
> > >
> > > but it did not help.
> > >
> > > Please help me. Thanks in advance.
> > >
> > >
> > >
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com

Mime
View raw message