tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jared Clinton <Jar...@esd.nec.com.au>
Subject RE: database connection problem when run nt service
Date Wed, 20 Dec 2000 02:06:03 GMT
Is your datasource a user dsn, system dsn or a file dsn?

I think the differences there are that they have different levels of
visibility, try making it one or the other and see what happens.

Hope this helps, Jared.



> -----Original Message-----
> From: H Deng [mailto:deng_h1579@hotmail.com]
> Sent: Wednesday, 20 December 2000 10:35
> To: tomcat-user@jakarta.apache.org
> Subject: RE: database connection problem when run nt service
> 
> 
> 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