请问在jive里用哪个jdbc driver for sql server好啊?

03-09-04 mang
要免费的...不知道哪里有得下载.jive里推荐的

com.merant.datadirect.jdbc.sqlserver.SQLServerDriver 哪里有?3x

winxp + jivejdon + sql server

btw:最好给出国内的下载地址,国外的连不上

mang
2003-09-04 09:53
今天下载了m$的sql server 2000 jdbc driver sp1,把mssqlserver.jar放到tomcat/common/lib/下了,进入数据库设置

driver com.microsoft.jdbc.sqlserver.SQLServerDriver

serverurl jdbc:microsoft:sqlserver://localhost/MANG/jive

出错信息如下:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

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

exception

javax.servlet.ServletException: com/microsoft/jdbc/base/BaseDriver

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:680)

at org.apache.jsp.admin.setup.setup3_jsp._jspService(setup3_jsp.java:704)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:288)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:196)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2748)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:186)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:512)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:199)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:637)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:463)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:568)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:631)

at java.lang.Thread.run(Thread.java:534)

root cause

java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver

at java.lang.ClassLoader.defineClass0(Native Method)

at java.lang.ClassLoader.defineClass(ClassLoader.java:537)

at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)

at java.net.URLClassLoader.defineClass(URLClassLoader.java:251)

at java.net.URLClassLoader.access$100(URLClassLoader.java:55)

at java.net.URLClassLoader$1.run(URLClassLoader.java:194)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:187)

at org.apache.catalina.loader.StandardClassLoader.findClass(StandardClassLoader.java:520)

at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:857)

at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:756)

at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:840)

at org.apache.catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java:756)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1314)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1174)

at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:188)

at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:114)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:141)

at org.apache.jsp.admin.setup.setup3_jsp._jspService(setup3_jsp.java:313)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:320)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:293)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:288)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:263)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:196)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2748)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:186)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:512)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:562)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1018)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:199)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:637)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:463)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:568)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:631)

at java.lang.Thread.run(Thread.java:534)

--------------------------------------------------------------------------------

Java Web Services Developer Pack/1.2

j4v4
2003-09-05 09:07
root cause

java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver

ajoke
2003-09-09 08:37
M$的jdbc有三个jar:msbase.jar,masqlserver.jar,msutil.jar都要copy到相应地方

另外url你写错了,jdbc:microsoft:sqlserver://server1:1433;databaseName=Northwind

猜你喜欢