tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peng Tuck Kwok <pengt...@makmal.net>
Subject Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Date Tue, 25 Feb 2003 04:13:18 GMT
Tomcat ignores the classpath, the only variable you need to setup on 
win2k (at least for me ) was the JAVA_HOME.

Michael Ni wrote:
> Exact problem is tomcat can't read from the CLASSPATH and needs the 
> actual files inside the web-inf folder.  So basically to get a 
> connection you need to
> 1 install the sdk
> 2 install tomcat
> 3 get all the environmental variables correct
> 4 install the driver
> 5 (this is my problem) place a copy of the driver inside the web-inf folder
> 
> finally you can have your jsp pages find the driver and then query the 
> database.
> 
> mike
> learned a lot in the past few days
> 
> 
> 
> 
> 
> 
>> From: Peng Tuck Kwok <pengtuck@makmal.net>
>> Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>> To: Tomcat Users List <tomcat-user@jakarta.apache.org>
>> Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
>> Date: Tue, 25 Feb 2003 11:57:15 +0800
>>
>> Ok, good to hear you got it to work but I'm curious, what was exact 
>> cause of the problem ?
>>
>> Michael Ni wrote:
>>
>>> Thank you Ian Hunter and the rest of the tomcat crew!!!
>>>
>>> Just got it to work!!!  I'm a grateful student from University of 
>>> Pennsylvania trying to make a web application but new to java.  I'm 
>>> spoiled by asp and IIS but I figure its time to move on to more 
>>> powerful software.  Thanks Everyone you guys are awesome.
>>>
>>> Mike Ni
>>>
>>>
>>>
>>>
>>>
>>>
>>>> From: "Ian Hunter" <ihunter@hunterweb.net>
>>>> Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>>> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>>> Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
>>>> Date: Mon, 24 Feb 2003 22:29:35 -0500
>>>>
>>>> One reason to use WEB-INF\lib is if you plan on distributing your 
>>>> app or
>>>> deploying it to a different system, it's easier to move 
>>>> \webapps\<app>\*
>>>> than to worry about lots of little jars in common...
>>>>
>>>> ----- Original Message -----
>>>> From: "Peng Tuck Kwok" <pengtuck@makmal.net>
>>>> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>>> Sent: Monday, February 24, 2003 10:31 PM
>>>> Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
>>>>
>>>>
>>>> > Uhm michael, you need to decide where you want to put the jars in the
>>>> > first place, if you want the driver available to all webapps then you
>>>> > put it there. If you just want it for your webapp then you can put it
>>>> > into the lib directory. I'm not sure if it will cause major 
>>>> problems but
>>>> > it's best to put it in one place at one time first.
>>>> > Also please check your spelling for your driver in the jsp code, 
>>>> you may
>>>> > have mispelled it and caused it to look for something else.
>>>> >
>>>> >
>>>> >
>>>> >
>>>> > Michael Ni wrote:
>>>> > >
>>>> > > ive copied to my
>>>> > > C:\Tomcat 4.1\webapps\ROOT\WEB-INF\lib
>>>> > > C:\Tomcat 4.1\common\lib
>>>> > > and it still doesn't work.
>>>> > >
>>>> > > has anyone actually got their scripts to query from SQL Server
2000
>>>> > > using the Microsoft SQL Server 2000 JDBC Driver?  seems like sun
>>>> > > products never work with microsofts
>>>> > >
>>>> > > michael ni
>>>> > >
>>>> > >
>>>> > >
>>>> > >> From: "Galbayar Dorjgotov" <galbayar@mobinet.mn>
>>>> > >> Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>>> > >> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>>> > >> Subject: RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver

>>>> issue
>>>> > >> Date: Tue, 25 Feb 2003 11:15:44 +0800
>>>> > >>
>>>> > >> copy common\lib directory
>>>> > >>
>>>> > >> -----Original Message-----
>>>> > >> From: Michael Ni [mailto:mikeni123@hotmail.com]
>>>> > >> Sent: Tuesday, February 25, 2003 10:32 AM
>>>> > >> To: tomcat-user@jakarta.apache.org
>>>> > >> Subject: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
>>>> > >>
>>>> > >>
>>>> > >> My goal is to use JSP to query from my Microsoft SQL Server
2000.
>>>> > >>
>>>> > >> I have successfully created my environments and installed the

>>>> drivers
>>>> for
>>>> > >> the Microsoft SQL Server 2000 JDBC.
>>>> > >>
>>>> > >> However when i run my script i get the following error
>>>> > >>
>>>> > >> Driver not found:java.lang.ClassNotFoundException:
>>>> > >>
>>>> com.microsoft.jdbc.sqlserver.SQLServerDrivercom.microsoft.jdbc.sqlserver.SQL

>>>>
>>>>
>>>> > >>
>>>> > >> ServerDriver
>>>> > >> exception: java.sql.SQLException: No suitable driverNo suitable

>>>> driver
>>>> > >>
>>>> > >> you can see for yourself at the following url
>>>> > >>
>>>> > >> http://128.91.107.144:8080/test/home.jsp
>>>> > >>
>>>> > >> I attached my home.jsp page.  Does tomcat need to have the

>>>> microsoft
>>>> > >> drivers
>>>> > >> physically in the folder or subfolders of c:\Tomcat 4.1?  All
i 
>>>> did was
>>>> > >> create the CLASSPATH which assigned CLASSPATH to the 3 jar
driver
>>>> files.
>>>> > >> I've been stuck on this issue for 3 days.  Can anyone help
me?
>>>> > >>
>>>> > >>
>>>> > >>
>>>> > >>
>>>> > >>
>>>> > >> _________________________________________________________________
>>>> > >> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
>>>> > >> http://join.msn.com/?page=features/virus
>>>> > >>
>>>> > >>
>>>> > >>
>>>> > >> 
>>>> ---------------------------------------------------------------------
>>>> > >> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>>> > >> For additional commands, e-mail: 
>>>> tomcat-user-help@jakarta.apache.org
>>>> > >
>>>> > >
>>>> > >
>>>> > > _________________________________________________________________
>>>> > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
>>>> > > http://join.msn.com/?page=features/virus
>>>> > >
>>>> > >
>>>> > > 
>>>> ---------------------------------------------------------------------
>>>> > > 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
>>>> >
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>
>>> _________________________________________________________________
>>> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
>>> http://join.msn.com/?page=features/junkmail
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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
> 
> 
> 
> _________________________________________________________________
> Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
> http://join.msn.com/?page=features/featuredemail
> 
> 
> ---------------------------------------------------------------------
> 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