SQL Server 2000: JDBC
Hi! I am investigating the error messages below. These messages come once in a while and sometime together as a bunch. We are using connection pooling inside a servlet and also using some classes (in Jsp) without connection Pooling. Error making pool: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. Error connecting: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write All help will be appreciated! Lalit - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL Server 2000: JDBC
Hello lalit, we too had the problem of connection reset by peer and then we changed the Driver.Now we are using SourceForge driver jtds.jar.May be this may solve ur problem. If anyone can find a better alternative please inform us. Regards, Sreekanth >
Re: SQL Server 2000: JDBC
Hei, I used to have that problem i am not sure but this happens when you dont close the connections i guess. Use "sp_who" STORED procedure to check the logged on users to SQL2000.. sree kanth wrote: Hello lalit, we too had the problem of connection reset by peer and then we changed the Driver.Now we are using SourceForge driver jtds.jar.May be this may solve ur problem. If anyone can find a better alternative please inform us. Regards, Sreekanth No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.8/114 - Release Date: 9/28/2005 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: SQL Server 2000: JDBC
-Original Message- From: sree kanth [mailto:[EMAIL PROTECTED] Sent: vendredi 30 septembre 2005 05:27 To: Tomcat Users List; Lalit Batra Subject: Re: SQL Server 2000: JDBC Hello lalit, we too had the problem of connection reset by peer and then we changed the Driver.Now we are using SourceForge driver jtds.jar.May be this may solve ur problem. If anyone can find a better alternative please inform us. Regards, Sreekanth I did the same, changed to jtds. I don't know if jtds is the best solution, but the main tips if you use SQL Server is *not* to use the Microsoft driver. Hibernate developers also recommend not to use it... -- Nicolas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL Server 2000: JDBC
We are closing all connections but we see that still lots of process are open in SQL server. Dont know what exactly is the cause, open connections or a weak driver. On 9/30/05, Karasek-XID, Nicolas <[EMAIL PROTECTED]> wrote: > > > -Original Message- > From: sree kanth [mailto:[EMAIL PROTECTED] > Sent: vendredi 30 septembre 2005 05:27 > To: Tomcat Users List; Lalit Batra > Subject: Re: SQL Server 2000: JDBC > > Hello lalit, > we too had the problem of connection reset by peer and then we changed > the > Driver.Now we are using SourceForge driver jtds.jar.May be this may > solve ur > problem. > If anyone can find a better alternative please inform us. > Regards, > Sreekanth > > > I did the same, changed to jtds. I don't know if jtds is the best > solution, but the main tips if you use SQL Server is *not* to use the > Microsoft driver. Hibernate developers also recommend not to use it... > > -- > Nicolas > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SQL Server 2000: JDBC
i suppose its a driver problem. I too had faced the same problem.More the MS SQL driver works in a very different ways that the query executed is different logically from the query supplied by us. Regards, Sreekanth
Re: SQL Server 2000: JDBC
Hi, Generally this error occurs when the connection between tomcat and the database is down, or the connection object is using a connection that is poor. For instance, if your tomcat is running, and for some reason, the database goes down and then restart, you will receive this error. So, before sending a sql command, you should test if the connection is good. If it isn't, kill it and start another one. I'm not sure, but if you use dbcp it will do it for you. Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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.SQLServerDriver 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Put msutil.jar, mssqlserver.jar, and msbase.jar in WEB-INF/lib and all will be happy. - Original Message - From: "Michael Ni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 9:32 PM 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Tomcat ignores your CLASSPATH variable. For more information about tomcat handles classloaders, see here: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/class-loader-howto.html -Tim Michael Ni wrote: 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.SQLServerDriver 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
copy common\lib directory -Original Message- From: Michael Ni [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:32 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
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" <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:32 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Mine works fine. The only place I have the ms*.jar files on my system is webapps\\WEB-INF\lib -- I have a Win2K Dell laptop running jdk1.4.0 and Tomcat 4.1.18, connecting to SQL2K through a firewall -- the same box running SQL2K also hosts a duplicate application, and I've even had a Sun SPARCserver 20 running SuSE Linux 7.3, blackdown jdk1.3.1 and tomcat 4.1.12 connecting to the SQL server just fine. Maybe delete your C:\Tomcat 4.1\work\* directories to force Tomcat to recompile your JSPs. I've had it go squirrelly on me in the past when making lots of changes. I can't imagine why you're having this problem. - Original Message - From: "Michael Ni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 10:19 PM Subject: RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > > 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" <[EMAIL PROTECTED]> > >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >To: "Tomcat Users List" <[EMAIL PROTECTED]> > >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:[EMAIL PROTECTED] > >Sent: Tuesday, February 25, 2003 10:32 AM > >To: [EMAIL PROTECTED] > >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.SQ L > >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: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > _ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:32 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
I see you just got it working: exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'sa'.[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'sa'. - Original Message - From: "Ian Hunter" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 10:26 PM Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > Mine works fine. The only place I have the ms*.jar files on my system is > webapps\\WEB-INF\lib -- I have a Win2K Dell laptop running > jdk1.4.0 and Tomcat 4.1.18, connecting to SQL2K through a firewall -- the > same box running SQL2K also hosts a duplicate application, and I've even had > a Sun SPARCserver 20 running SuSE Linux 7.3, blackdown jdk1.3.1 and tomcat > 4.1.12 connecting to the SQL server just fine. > > Maybe delete your C:\Tomcat 4.1\work\* directories to force Tomcat to > recompile your JSPs. I've had it go squirrelly on me in the past when making > lots of changes. > > I can't imagine why you're having this problem. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
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\\* than to worry about lots of little jars in common... - Original Message - From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> 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:[EMAIL PROTECTED] > >> Sent: Tuesday, February 25, 2003 10:32 AM > >> To: [EMAIL PROTECTED] > >> 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: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > _ > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > > http://join.msn.com/?page=features/virus > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
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" <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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\\* than to worry about lots of little jars in common... - Original Message - From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> 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:[EMAIL PROTECTED] > >> Sent: Tuesday, February 25, 2003 10:32 AM > >> To: [EMAIL PROTECTED] > >> 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: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > _ > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > > http://join.msn.com/?page=features/virus > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
You're welcome -- this is one of the great things about the Jakarta project and open source software in general -- a great user community. - Original Message - From: "Michael Ni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 10:49 PM Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
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" <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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\\* than to worry about lots of little jars in common... - Original Message - From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> 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:[EMAIL PROTECTED] > >> Sent: Tuesday, February 25, 2003 10:32 AM > >> To: [EMAIL PROTECTED] > >> 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: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > _ > > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > > http://join.msn.com/?page=features/virus > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands,
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
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 <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: Tomcat Users List <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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\\* than to worry about lots of little jars in common... - Original Message - From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> 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:[EMAIL PROTECTED] > >> Sent: Tuesday, February 25, 2003 10:32 AM > >> To: [EMAIL PROTECTED] > >> 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 m
Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
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 <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: Tomcat Users List <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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\\* than to worry about lots of little jars in common... - Original Message - From: "Peng Tuck Kwok" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <[EMAIL PROTECTED]> > >> 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:[EMAIL PROTECTED] > >> Sent: Tuesday, February 25, 2003 10:32 AM > >> To: [EMAIL PROTECTED] > >> 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? > >> > >> > >> > >> > >> &
RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
On Feb 24, Michael Ni had something to say about RE: Tomcat and Microsoft... > >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 I have it working with the following server.xml entry: driverClassName com.microsoft.jdbc.sqlserver.SQLServerDriver url jdbc:microsoft:sqlserver://localhost:1433 username myusername password mypassword maxActive 20 maxIdle 10 maxWait 100 It's based on the entry in http://www.autenroad.com/~jpajor/JNDIArticle.htm -- mattwarden mattwarden.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]