原因:java.sql.SQLException:找不到适用于jdbc:mysql://localhost:3306/domain的驱动程序 [英] Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/domain

问题描述

您好，我正在使用以下

hibernate-core-4.1.2.Final.jar

hibernate-core-4.1.2.Final.jar

mysql-connector-5.1.6.jar

mysql-connector-5.1.6.jar

两者都可以在我的项目lib目录中找到.

Both can be found in my project lib directory.

我具有以下 hibernate.cg.xml 配置.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- Defines the SQL dialect used in Hiberante's application -->
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

        <!--Local Database Connection-->
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/domain</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">test</property> 

        <property name="hbm2ddl.auto">validate</property>  

        <property name="show_sql">false</property>
        <property name="format_sql">false</property>
        <property name="use_sql_comments">false</property>

        <property name="hibernate.search.default.directory_provider">ram</property> 
    </session-factory>
</hibernate-configuration>

我收到以下异常.

 Caused by: java.sql.SQLException: No suitable driver found for
 jdbc:mysql://localhost:3306/domain     at
 java.sql.DriverManager.getConnection(DriverManager.java:604)   at
 java.sql.DriverManager.getConnection(DriverManager.java:190)   at
 org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:192)
    at
 org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:278)
    at
 org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
    ... 145 more

我不想使用JNDI来做事实，管理层希望保持该应用程序的可移植性，因此我想让它与jdbc一起使用又会缺少什么呢?我需要对tomcat进行任何类型的配置吗?

I do not want to use JNDI do to the fact management wants to keep the app as portable as possible, so what am I missing to get this to work with jdbc? Am I required to do any kind of configurations to tomcat?

Tomcat Lib

Tomcat Lib

推荐答案

尝试将

Try putting mysql-connector-5.1.6.jar directly into the lib folder of tomcat and restarting it.

这篇关于原因:java.sql.SQLException:找不到适用于jdbc:mysql://localhost:3306/domain的驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！