我在web-inf\lib下面加了mysql-connector-java-3.1.7-bin.jar这个驱动,在TOMCAT的COMMON/LIB下面也加了,在CLASSPATH里也写了C:\Tomcat\common\lib\mysql-connector-java-3.1.7-bin.jar,可还是报 org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' 这个错,这是什么原因呢.是不是还有什么配置不完整的地方
<!--测试数据源-->
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%> <%
DataSource ds = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
//从Context中lookup数据源。
ds = (DataSource)envCtx.lookup("RedstoneSql");
if(ds!=null)
{
out.println("已经获得DataSource!");
out.println("<br>");
Connection conn = ds.getConnection();
Statement stmt=conn.createStatement();
ResultSet rst=stmt.executeQuery("select * from login");
out.println("以下是从数据库中读取出来的数据");
while(rst.next())
{
out.println("bookName:"+rst.getString("Name"));
out.println("<br>");
}
}
else
out.println("连接失败!");
}
catch(Exception ne)
{
out.println(ne);
}
%>打印结果是已经获得DataSource!
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' 我已经在TOMCAT的LIB中加入了mysql-connector-java-3.0.11-stable-bin.jar怎么办啊?我很着急
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
这个错,这是什么原因呢.是不是还有什么配置不完整的地方
当前版本具体支持怎样的配置,可以到$Hibernate$\etc\hibernate.properties文件中查找。
如果你用hibernate3.0 dialect就不能用
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
而要用
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
import java.sql.*;
public class mysql {
public static void main(String args[])
{
String driver="com.mysql.jdbc.Driver";
Statement s=null;
try
{
//加载driver
Class.forName(driver).newInstance();
}
catch(Exception e)
{
e.printStackTrace();
return;
}
Connection con=null;
String url="jdbc:mysql://localhost/query?user=red&password=red";
try
{
//创建连接
con=DriverManager.getConnection(url);
//构造语句
s=con.createStatement();
//得到结果集
ResultSet rs=s.executeQuery("select * from operator");
while(rs.next())
{
String val;
val=rs.getString(2);
if(rs.wasNull())
{
val=null;
}
System.out.println(val);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
if(con!=null)
try
{
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}}打印结果完全正常
admin
ad222
这是不是意味着驱动是对的啊
仅仅是配置不对
兄弟们一定要帮帮忙啊!好象有点眉目了
我将我的配置文件全部贴出来,请兄弟们帮忙
hibernate.connection.driver_class com.mysql.jdbc.Driverhibernate.connection.url jdbc:mysql://192.168.0.10/popedom
hibernate.connection.username red
hibernate.connection.password redhibernate.cfg.xml中<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration><session-factory>
<property name="connection.datasource">java:comp/env/RedstoneSql</property>
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://192.168.0.10/popedom</property>
<property name="hibernate.connection.username">red</property>
<property name="hibernate.connection.password">red</property><mapping resource="com/redstoneinfo/popemon/hibernate/login.hbm.xml"/>
<mapping resource="com/redstoneinfo/popemon/hibernate/authority.hbm.xml"/>
<mapping resource="com/redstoneinfo/popemon/hibernate/part.hbm.xml"/></session-factory>
</hibernate-configuration>web.xml中<?xml version="1.0" encoding="ISO-8859-1"?>
<!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>
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>
/WEB-INF/struts/struts-config.xml,
</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet><servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>30</session-timeout>
</session-config>
<!-- Struts Tag Library Descriptors -->
<taglib>
<taglib-uri>/WEB-INF/struts-bean.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-html.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-logic.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
</taglib>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>RedstoneSql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app> server.xml中
<Context path="/PopeDom" reloadable="true" docBase="D:\workspace\PopeDom" workDir="D:\workspace\PopeDom\work\org\apache\jsp" >
<Resource name="RedstoneSql" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="RedstoneSql"> <parameter>
<name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name> <value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>red</value>
</parameter>
<parameter>
<name>password</name>
<value>red</value>
</parameter>
<parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter>
<parameter>
<name>url</name> <value>jdbc:mysql://192.168.0.10/popedom</value>
</parameter>
</ResourceParams>
</Context>
hibernate.connection.driver_class com.mysql.jdbc.Driverhibernate.connection.url jdbc:mysql://192.168.0.10/popedom
hibernate.connection.username red
hibernate.connection.password redhibernate.cfg.xml中
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory><property name="connection.datasource">java:comp/env/RedstoneSql</property>
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://192.168.0.10/popedom</property>
<property name="hibernate.connection.username">red</property>
<property name="hibernate.connection.password">red</property><mapping resource="com/redstoneinfo/popemon/hibernate/login.hbm.xml"/>
<mapping resource="com/redstoneinfo/popemon/hibernate/authority.hbm.xml"/>
<mapping resource="com/redstoneinfo/popemon/hibernate/part.hbm.xml"/></session-factory>
</hibernate-configuration>
如果方便,你把东西给我吧,我给你调试好,然后给你吧
呵呵我的[email protected]
我的[email protected]