java.sql.SQLException: No suitable driver 错误

[lntasa]

java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at org.springframework.orm.hibernate3.HibernateTemplate$38.doInHibernate(HibernateTemplate.java:1012)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:1001)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:994)
at dao.UserDAO.findByExample(UserDAO.java:67)
at service.Service.isValid(Service.java:16)
at web.action.LoginAction.execute(LoginAction.java:54)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
at java.lang.Thread.run(Thread.java:595)

用myeclipse做的SSH，报的这个错误
UserDAO.java代码是直接生成的
applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>


	<bean id="dataSource"
		class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>
				jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK
			</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>eetrust</value>
		</property>
	</bean>
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.MySQLDialect
				</prop>
			</props>
		</property>
		<property name="mappingResources">
			<list>
				<value>vo/User.hbm.xml</value></list>
		</property></bean>
	<bean name="/login" class="web.action.LoginAction" singleton="false">
		<property name="service">
			<ref bean="service" />
		</property>
	</bean>
	<bean id="service" class="service.Service" singleton="false">
        <property name="userDao">
              <ref bean="userDao" />
        </property>
    </bean>
	<bean id="userDao" class="dao.UserDAO">
		<property name="sessionFactory">
			<ref bean="sessionFactory" />
		</property>
	</bean>
	</beans>

刚学spring不知道那里错了，大家帮忙看看

[sailyyang]

没有可适用的驱动。。

你的数据源配置中 。。采用了apache的包。。。既然是用spring 为什么不用spring 集成的

org.springframework.jdbc.datasource.DriverManagerDataSource

0~0。

[lntasa]

那个是自己生成的,但是改成
org.springframework.jdbc.datasource.DriverManagerDataSource
还是一样的错误

[linpyi]

貌似没有驱动包,是否加栽进去了

[linpyi]

你有没把mysql的驱动包拷贝到相应的目录下

[lntasa]

mysql-connector-java-3.1.7-bin.jar
放在WEB-INF\lib下了

[linpyi]

你是用什么IDE
是否有加栽到项目中去

[lntasa]

加载了 ,但是我不知道是什么IDE

[lntasa]

应该是官方的,myeclipse自带的

[linpyi]

IDE就是开发环境,开发工具myeclipse还是jbuilder还是什么
spring不太熟,不过我觉的你这应该不是代码问题

[lntasa]

我用的是myeclipse,我感觉也不代码问题,我照网上的例子做的

[bt_lose]

将 datasource bean 的培植改成

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK"/>        <property name="username">
            <value>root</value>
        </property>
        <property name="password">
            <value>eetrust</value>
        </property>
</bean>

[bt_lose]

就好了，这是spring配置文件的一个小小疏忽,或者在spring配置文件中不要让连接字符串换行,把他和value标签写在一行也行

[lntasa]

[Quote=引用 11 楼 bt_lose 的回复:]
将 datasource bean 的培植改成

XML code
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK"/> <property name="username">
<value>…
[/Quote]
改了以后现在又出新错误了
java.sql.SQLException: Table 'test.test__test' doesn't exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at org.springframework.orm.hibernate3.HibernateTemplate$38.doInHibernate(HibernateTemplate.java:1012)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:1001)
at org.springframework.orm.hibernate3.HibernateTemplate.findByExample(HibernateTemplate.java:994)
at dao.UserDAO.findByExample(UserDAO.java:67)
at service.Service.isValid(Service.java:16)
at web.action.LoginAction.execute(LoginAction.java:54)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
at java.lang.Thread.run(Thread.java:595

[lntasa]

java.sql.SQLException: Table 'test.test__user' doesn't exist

[lntasa]

问题解决了
<hibernate-mapping>
<class name="vo.User" table="user" catalog="test">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="native" />
</id>
<property name="username" type="java.lang.String">
<column name="username" length="30" not-null="true" />
</property>
<property name="password" type="java.lang.String">
<column name="password" length="30" />
</property>
</class>
</hibernate-mapping>
去掉catalog="test"就好了

[lntasa]

问题是解决了,但不知道为什么去掉catalog="test"就好了
之前做的struts+hibernate的xml也是这样的,但却能用

[linpyi]

多了这个~！“catalog="" ”这个地方是把库名放在上面了，当生成Hibernate生成SQL语句时把表名前又加上了库名，所以报错了~！
貌似这样

[lntasa]

不知道,我之前做的struts+hibernate的xml也是这样的配置了catalog,但是运行正常,没有报错

[老实的老陈]

不是这样的~ 我的没有catalog这个，现在也出这个问题了，说找不到驱动，NND~ 麻烦高手解答下

[wingerliwei]

楼主的第一个问题，我也遇到了，确实不能换行写，一定要写到一行上