JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » Microsoft SQL Server  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to topicthreaded modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 SQL Server 2000 Driver for JDBC Service Pack 3 [精華]
jini

SoftLeader Taiwan

版主

發文: 1266
積分: 23
於 2004-08-17 08:03 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

driverName:
com.microsoft.jdbc.sqlserver.SQLServerDriver

URL:
jdbc:Microsoft:sqlserver://my-virtualserver:1433;DatabaseName=Pubs

And sp3 bug fix list

Modifications from Service Pack 2 August 2003 to Service Pack 3 May 2004

Issue # | Description of issue

DEF0000192 | When a query timed out, the driver did not throw the query timeout exception at execute time.

DEF0000386 | Connection.nativeSQL did not return the SQL that the driver sent to the database.

DEF0000395 | Driver generated a NullPointerException when executing subsequent SQL commands on a statement object after a cancel was issued on the statement object.

DEF0000643 | SQLWarning class only received the warning message and the error code was always returned as 0.

DEF0000686 | Batch update processing was modified. The driver now handles batch statements that do not return update counts or resultsets.


jini edited on 2004-08-17 08:14
reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
airskys





發文: 12
積分: 0
於 2004-09-02 09:29 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
好东东

是2004年7月6号才出的

直接下载

http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/setup.exe


reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
markcool66





發文: 20
積分: 0
於 2005-07-15 11:09 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
補充:因為想試看看,所以重頭流程跑一下,所以有下面的1.2.3

1.首先到微軟的網站下載

http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

在上個網頁,可以下載 mssqlserver.tar 及 setup.exe 其中一項。 .tar有二層的壓縮,所以要解壓二次。

2.解壓縮及安裝完成之後,可以在 msjdbc\lib 之中找到 msbase.jar,mssqlserver.jar,msutil.jar的檔案。

3.將這三個檔案,放到$Tomcat_Home\common\lib 之中,提供Tomcat使用。

 或許是檔案放到 $Tomcat_Home\webapps\XXXX(自己的WEB)\WEB-INF\lib之中,這樣就可以從JSP的程式去使用。


browser edited on 2005-07-15 11:18
reply to postreply to post
小苦工 --> 不是很厲害
大苦工 --> 有點厲害
超級苦工 --> 算厲害

苦工再厲害還是苦工
http://spaces.msn.com/members/markcool66/
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
andyshu





發文: 1
積分: 0
於 2005-09-25 12:06 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
它要我先安裝Analysis services 2000 才可裝
可是那裡可找到Analysis service 2000
麻煩請告之謝了


reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
礼物





發文: 7
積分: 0
於 2005-11-26 14:30 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
谢谢 markcool66和版主

reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:andyshu]
undeadbird





發文: 9
積分: 0
於 2006-01-10 01:09 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
andyshu wrote:
它要我先安裝Analysis services 2000 才可裝
可是那裡可找到Analysis service 2000
麻煩請告之謝了


裝sql server 2000 的disk~


reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
shctony





發文: 6
積分: 0
於 2006-07-23 16:26 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
補充:因為想試看看,所以重頭流程跑一下,所以有下面的1.2.3

1.首先到微軟的網站下載

http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

在上個網頁,可以下載 mssqlserver.tar 及 setup.exe 其中一項。 .tar有二層的壓縮,所以要解壓二次。

2.解壓縮及安裝完成之後,可以在 msjdbc\lib 之中找到 msbase.jar,mssqlserver.jar,msutil.jar的檔案。

3.將這三個檔案,放到$Tomcat_Home\common\lib 之中,提供Tomcat使用。

 或許是檔案放到 $Tomcat_Home\webapps\XXXX(自己的WEBlack Eye\WEB-INF\lib之中,這樣就可以從JSP的程式去使用。

照作了还不行,如下:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to load class for JSP
  org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: Unable to load class for JSP
  org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:598)
  org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:315)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.ClassNotFoundException: org.apache.jsp.shcoa.test_jsp
  java.net.URLClassLoader$1.run(Unknown Source)
  java.security.AccessController.doPrivileged(Native Method)
  java.net.URLClassLoader.findClass(Unknown Source)
  org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:133)
  org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
  org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:596)
  org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:315)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.

系统:win2000 pro
jdk1.5.0_07
Tomcat 5.5


reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
shctony





發文: 6
積分: 0
於 2006-07-23 16:29 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
补充在classpath也增加了,在JDK的lib和JRE/lib/ext中也拷贝了还不行,请各位指点

reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:jini]
hzymnbvcx





發文: 176
積分: 0
於 2006-11-30 14:36 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
請教啊
我都快搞暈了
在java中可以
在jsp中老是報No suitable driver

我已把那三個文件復制到
jdk\jre\lib下
C:\Tomcat 5.0\common\lib
E:\jspdata\WEB-INF\lib
其中jspdata為我自己的web目錄


reply to postreply to post
作者 Re:SQL Server 2000 Driver for JDBC Service Pack 3 [Re:shctony]
keylose





發文: 5
積分: 0
於 2006-12-25 09:57 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
shctony wrote:
補充:因為想試看看,所以重頭流程跑一下,所以有下面的1.2.3

1.首先到微軟的網站下載

http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

在上個網頁,可以下載 mssqlserver.tar 及 setup.exe 其中一項。 .tar有二層的壓縮,所以要解壓二次。

2.解壓縮及安裝完成之後,可以在 msjdbc\lib 之中找到 msbase.jar,mssqlserver.jar,msutil.jar的檔案。

3.將這三個檔案,放到$Tomcat_Home\common\lib 之中,提供Tomcat使用。

 或許是檔案放到 $Tomcat_Home\webapps\XXXX(自己的WEBlack Eye\WEB-INF\lib之中,這樣就可以從JSP的程式去使用。

照作了还不行,如下:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to load class for JSP
  org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: Unable to load class for JSP
  org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:598)
  org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:315)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.ClassNotFoundException: org.apache.jsp.shcoa.test_jsp
  java.net.URLClassLoader$1.run(Unknown Source)
  java.security.AccessController.doPrivileged(Native Method)
  java.net.URLClassLoader.findClass(Unknown Source)
  org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:133)
  org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
  org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:596)
  org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:147)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:315)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.

系统:win2000 pro
jdk1.5.0_07
Tomcat 5.5


對...我也是出現這個錯誤訊息,請各位大大告知,如何解決


reply to postreply to post
» JWorld@TW »  JDBC/SQL討論區 » Microsoft SQL Server

reply to topicthreaded modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8