没找到jdbc的驱动要把jdbc的三个jar文件copy到
tomcat 的common/lib/目录下就可以了
tomcat 的common/lib/目录下就可以了
解决方案 »
- 求高手解释,myEclipse中运行tomcat出现下面信息,当还能测试web应用,如www.localhost:1212/xx.jsp,为什么?
- 谁有webQQ实现思路与方法或类似资源下载?
- 大家好,我有一个正则表达式的问题,我主要想匹配html标签中的属性,但是不能全部匹配,望大家帮忙
- HTTP Status 404 - Servlet action is not available ?调了3天了
- ajax下拉菜单
- 用ssh上传图片问题
- 用了htc,jsp在服务器上打不开的奇怪问题(紧急求助)
- JSP发邮件!SMTP哪个可以用?
- 请大家看看,linux下TOMCAT中servlet运行不成功!原因何在?
- jspsmart upload的一个问题!
- 50分求中译英翻译软件的下载地址
- 请教Jbuilder8连接Sybase数据库的问题
应该有的啊d:\tomcat4.0\common\lib
没有这个目录么?
java.lang.NullPointerException
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.setupTempFiles(Unknown Source)
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.chainInServiceImplResultSets(Unknown Source)
at com.microsoft
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://200.168.1.58:1433;DatabaseName=pubs";
String user="sa";
String password="12345678";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from authors";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
第一个字段内容为:<%=rs.getString(1)%>
第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
----------------------------------------------------
上面是我调试的cnn.jsp程序代码,请帮助看看,有没有问题?
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";String user="sa";
String password="1";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from Employees";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
第一个字段为:<%=rs.getString(1)%>
第二个字段为:<%=rs.getString(2)%><br>
<%}%>
<%out.print("恭喜你,数据库连接成功!");%>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
先用mssqlserver的客户端连接数据库,如果能连接,再检查tomcat的配置。
记着把jdbc的三个jar文件copy到tomcat 的common/lib/目录下
Tools--->Configure Libraries 添加要把jdbc的三个jar文件
Project----->Project Properties---->Required libraries中,添加上一步骤中建立libraries
关闭JB重新打开,就OK了。
???怎么加啊?????
c:\jakarta-tomcat-4.0.3\common\lib\msbase.jar
c:\jakarta-tomcat-4.0.3\common\lib\mssqlserver.jar
......
java.lang.NullPointerException
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.setupTempFiles(Unknown Source)
at com.microsoft.jdbc.base.BaseImplStaticCursorResultSet.(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.chainInServiceImplResultSets(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getNextResultSet(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonGetNextResultSet(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at org.apache.jsp.cnn$jsp._jspService(cnn$jsp.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:479)
??
1、我用ODBC没有任何问题
2、我看了系统的ODBC没有JDBC在上面怎么测试??
3、程序是书上的例子,我想应该没有问题,问题是我怎么配置也不行
我把东西都安装在C:\
设置也按照上面说的,还有什么问题,错误提示变化了一次,后来就老是像上面的那样错误提示了,我正的没有办法了,看书中......
那位兄弟知道,伸手帮助以下,不胜感激!!!!