页:
[1]
|
还是连接池问题
用jbuilder X子代的tomcat4.06
server8080.xml文件
[CODE]<?xml version="1.0" encoding="UTF-8"?>
<!--This comment marks this file as generated, so it may be deleted and regenerated at any time. To preserve manual changes to this file, delete this comment.-->
<Server debug="0" port="8081" shutdown="SHUTDOWN">
<Service name="Tomcat-Standalone">
<Connector acceptCount="10" className="org.apache.catalina.connector.http.HttpConnector" connectionTimeout="60000" debug="0" maxProcessors="75" minProcessors="5" port="8080"/>
<Engine debug="0" defaultHost="localhost" name="Standalone">
<Host appBase="D:\www\jsp\DBTest\Tomcat\webapps" debug="0" name="localhost" unpackWARs="true">
<Context debug="0" docBase="D:\www\jsp\DBTest\DBTest" path="/DBTest" reloadable="true" workDir="D:\www\jsp\DBTest\Tomcat\work\DBTest">
<ResourceParams name="jdbc/DBTest">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/jspdb</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Host>
</Engine>
</Service>
</Server>
[/CODE] |
|
web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<display-name>DBTest</display-name>
<description>MySQL Test App</description>
<servlet>
<servlet-name>debugjsp</servlet-name>
<description>Added to compile JSPs with debug info</description>
<servlet-class>org.apache.jasper.servlet.JspServlet</servlet-class>
<init-param>
<param-name>classdebuginfo</param-name>
<param-value>true</param-value>
</init-param>
<load-on-startup>3</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>debugjsp</servlet-name>
<url-pattern>*.jsp</url-pattern>
</servlet-mapping>
<resource-ref>
<description>OB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app> |
|
测试文件
[CODE]<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<%
try{
Context initCtx = new InitialContext();
Object obj = initCtx.lookup("java:comp/env/jdbc/TestDB");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String sql = "select * from messages";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}catch(Exception ex){
out.write("Error: " + ex.getMessage());
}
%>
<hr>
[/CODE] |
|
错误
Error: Exception creating DataSource: tyrex/jdbc/xa/EnabledDataSource
为什么？ |
|
还有
Object obj = initCtx.lookup("java:comp/env/jdbc/TestDB");
是什么意思，lookup()里面该添什么 |
|
最新错误
Error: Cannot create JDBC driver of class '' for connect URL 'null' |
|
测试代码
[CODE]<%@ page contentType="text/html;charset=GBK"%>
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<%
try{
Context initCtx = new InitialContext();
Object obj = initCtx.lookup("java:comp/env/jdbc/TestDB");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String sql = "select * from messages";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}catch(Exception ex){
out.write("Error: " + ex.getMessage());
}
%>
<hr> [/CODE] |
|
不用jbuider的时候
用自己搭建的环境，居然还出现
Error: Cannot create JDBC driver of class '' for connect URL 'null'
大虾们，这是什么意思？ |
Powered by Discuz! Archiver 6.1.0
© 2001-2006 Comsenz Inc.
Processed in 0.006694 second(s), 2 queries |