最近开始学习hibernate,我在myeclipse中写了一个hbm2ddl工具类,将实体类生成数据库表,在运行这个工具类的时候出现了错误:这是实体类:
package com.yangbing.hibernate;import java.util.Date;public class User {  

   private String id; 
   
   private String name;
   
   private String password;
   
   private Date createTime;
   
   private Date expireTime;public String getId() {
return id;
}public void setId(String id) {
this.id = id;
}public String getName() {
return name;
}public void setName(String name) {
this.name = name;
}public String getPassword() {
return password;
}public void setPassword(String password) {
this.password = password;
}public Date getCreateTime() {
return createTime;
}public void setCreateTime(Date createTime) {
this.createTime = createTime;
}public Date getExpireTime() {
return expireTime;
}public void setExpireTime(Date expireTime) {
this.expireTime = expireTime;
}
}这是User.hbm.html:?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping >
<class name="com.yangbing.hibernate.User">
<id name="id">
    <generator class="uuid" />
</id>
<property name="name" />
<property name="password" />
<property name="createTime" />
<property name="expireTime" /></class>


</hibernate-mapping>这是hibernate.cfg.xml:<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>
<session-factory >
    <property name="hibernate.connection.url">jdbc.mysql://localhost/hibernate_first</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">yang</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>


<mapping resource="com/yangbing/hibernate/User.hbm.xml" />
</session-factory>
</hibernate-configuration> 这是工具类ExportDB.java:package com.yangbing.hibernate;import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;public class ExportDB {
     public static void main(String[] args){
      //读取hibernate.cfg.xml文件
      Configuration cfg=new Configuration().configure();
      SchemaExport export=new SchemaExport(cfg);
      export.create(true,true);
     }
}运行时报错如下:12:30:04,728 ERROR SchemaExport:202 - schema export unsuccessful
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:28)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
at com.yangbing.hibernate.ExportDB.main(ExportDB.java:11)求高手帮忙解决。

解决方案 »

  1.   

    mysql驱动加了吗或者是不是版本不对
      

  2.   

    mysql驱动加了的,版本是对的,以前写的一些程序,像登录注册这些都是能连接到数据库的
      

  3.   

    问题已经解决,原因出在 
    <property name="hibernate.connection.url">jdbc.mysql://localhost/hibernate_first </property> 
     
    改为jdbc:mysql://localhost:3307/hibernate_first
    运行成功