<%@ page language="java" import="java.util.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %><%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
out.println(basePath);
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
This is my JSP page. <br> <%
Context ctx=null;
Connection cnn=null;
java.sql.Statement stmt=null;
ResultSet rs=null;
try
{
ctx=new InitialContext();
if(ctx==null)
throw new Exception("initialize the Context failed");
out.println("abc1"+"<br>");
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/ghyghost");
out.println("abc2"+"<br>");
out.println(ds);
out.println("abc3"+"<br>");
if(ds==null)
{ throw new Exception("datasource is null");
}
out.println("abc4"+"<br>");
try{
out.println("abc5"+"<br>");
cnn=ds.getConnection();
out.println("abc6"+"<br>");
stmt = cnn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("select * from jobs");while (rs.next())
{
out.println(rs.getObject("job_id").toString());
}
out.println("<br> connection:"+cnn);
}catch(Exception e){
e.printStackTrace();
} }
finally
{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(cnn!=null)
cnn.close();
if(ctx!=null)
ctx.close();
}
%>
</body>
</html>
现在问题是:
out.println("abc6"+"<br>");这句不输出了,说明上一句有错误啊,帮忙,是什么错误,
我连接的是MSSQL2000的PUBS数据库,帮忙。TOMCAT的服务器
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %><%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
out.println(basePath);
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
This is my JSP page. <br> <%
Context ctx=null;
Connection cnn=null;
java.sql.Statement stmt=null;
ResultSet rs=null;
try
{
ctx=new InitialContext();
if(ctx==null)
throw new Exception("initialize the Context failed");
out.println("abc1"+"<br>");
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/ghyghost");
out.println("abc2"+"<br>");
out.println(ds);
out.println("abc3"+"<br>");
if(ds==null)
{ throw new Exception("datasource is null");
}
out.println("abc4"+"<br>");
try{
out.println("abc5"+"<br>");
cnn=ds.getConnection();
out.println("abc6"+"<br>");
stmt = cnn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("select * from jobs");while (rs.next())
{
out.println(rs.getObject("job_id").toString());
}
out.println("<br> connection:"+cnn);
}catch(Exception e){
e.printStackTrace();
} }
finally
{
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(cnn!=null)
cnn.close();
if(ctx!=null)
ctx.close();
}
%>
</body>
</html>
现在问题是:
out.println("abc6"+"<br>");这句不输出了,说明上一句有错误啊,帮忙,是什么错误,
我连接的是MSSQL2000的PUBS数据库,帮忙。TOMCAT的服务器
解决方案 »
- 求大神帮助C语言的函数用java实现主要是object那个不是太明白!~
- 用java实现
- 一个小问题~~~~
- 急,关于查询内容导出到txt的问题
- 怎么在名字后面的括号里写字呢? :)
- 再次求教double的精度问题!!!!!!!!!!!!!!!!!
- 请教一个判断a值为正负的程序(很基础的,别笑我)~
- SWT 实现TREEVIEW 树的遍历
- java开发是要比vb,delphi,bcb慢?
- 怎样不执行SELECT SQL语句即可获得ResultSetMetaData实例????
- 怎样设置classpath的路径,使得java所包含的类库中有javax.servlet.http.*包?
- applet中socket连接失败
你从控制台应该可以看到异常的信息啊
还有,
你得把配置JNDI的XML发出来看看
<web-app version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <resource-ref>
<res-ref-name>jdbc/ghyghost</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
web.xml里面的全部内容使用ECLIPSE布属
信息: Initializing Coyote HTTP/1.1 on http-8080
2005-12-18 22:15:16 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2031 ms
2005-12-18 22:15:16 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2005-12-18 22:15:16 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/5.0.28
2005-12-18 22:15:16 org.apache.catalina.core.StandardHost start
信息: XML validation disabled
2005-12-18 22:15:16 org.apache.catalina.core.StandardHost getDeployer
信息: Create Host deployer for direct deployment ( non-jmx )
2005-12-18 22:15:16 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\balancer.xml
2005-12-18 22:15:18 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\admin.xml
2005-12-18 22:15:18 org.apache.struts.util.PropertyMessageResources <init>
信息: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
2005-12-18 22:15:18 org.apache.struts.util.PropertyMessageResources <init>
信息: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
2005-12-18 22:15:19 org.apache.struts.util.PropertyMessageResources <init>
信息: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
2005-12-18 22:15:22 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\manager.xml
2005-12-18 22:15:23 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\webdav.xml
2005-12-18 22:15:23 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\servlets-examples.xml
2005-12-18 22:15:23 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\jsp-examples.xml
2005-12-18 22:15:24 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\tomcat-docs.xml
2005-12-18 22:15:24 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\ROOT.xml
2005-12-18 22:15:24 org.apache.catalina.core.StandardHostDeployer install
信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\ghyjsp.xml
2005-12-18 22:15:25 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2005-12-18 22:15:25 org.apache.jk.common.ChannelSocket init
信息: JK2: ajp13 listening on /0.0.0.0:8009
2005-12-18 22:15:25 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/78 config=G:\Tomcat\conf\jk2.properties
2005-12-18 22:15:25 org.apache.catalina.startup.Catalina start
信息: Server startup in 9813 ms
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.apache.jsp.ghy_jsp._jspService(ghy_jsp.java:105)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
... 32 more
错误信息是没有找到JDBC但我JDBC有啊,,放到相当目录中了。。怎么回事帮忙
我连接的是MSSQL 2000中的PUBS数据库,
1 你忽略了另外一个配置文件 ,Tomcat中在conf/Server.xml中配置
2 你没有使用SQLServer的JDBC驱动;或者是你工程里有,但是lib文件没有伴随你的部署自动copy到web-inf的lib下