我运行了如下简单的一个小程序,结果报错,我把几个文件贴出来,帮我看看,解决出来送分!呵呵~~~package com.sysu.hibernate;import java.util.Date;public class User {
private String id;
private String name;
private String password;
private Date startTime;
private Date endTime; public Date getEndTime() {
return endTime;
} public void setEndTime(Date endTime) {
this.endTime = endTime;
} 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 getStartTime() {
return startTime;
} public void setStartTime(Date startTime) {
this.startTime = startTime;
}
}
////////
User.hbm.xml<?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.sysu.hibernate.User">
<id name="id">
<generator class ="uuid"/>
</id>
<property name="name"/>
<property name="password"/>
<property name="startTime"/>
<property name="endTime"/>
</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">zhtao</property>
<property name="hibernate.connection.password">zhtao</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<mapping resource="com/sysu/hibernate/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>////////////////
ExportDB.javapublic 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);
}}
//////////////
properties中没有修改任何东西
/////////////////////////报错信息如下:02:51:35,906 INFO Environment:514 - Hibernate 3.2.6
02:51:35,906 INFO Environment:547 - hibernate.properties not found
02:51:35,921 INFO Environment:681 - Bytecode provider name : cglib
02:51:35,921 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
02:51:35,984 INFO Configuration:1432 - configuring from resource: /hibernate.cfg.xml
02:51:35,984 INFO Configuration:1409 - Configuration resource: /hibernate.cfg.xml
02:51:36,218 INFO Configuration:559 - Reading mappings from resource : com/sysu/hibernate/User.hbm.xml
02:51:36,312 INFO HbmBinder:300 - Mapping class: com.sysu.hibernate.User -> User
02:51:36,343 INFO Configuration:1547 - Configured SessionFactory: null
02:51:36,359 INFO Dialect:152 - Using dialect: org.hibernate.dialect.MySQLDialect
02:51:36,453 INFO SchemaExport:154 - Running hbm2ddl schema export
02:51:36,453 DEBUG SchemaExport:170 - import file not found: /import.sql
02:51:36,453 INFO SchemaExport:179 - exporting generated schema to database
02:51:36,453 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
02:51:36,453 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
02:51:36,453 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
02:51:36,453 INFO DriverManagerConnectionProvider:80 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/hibernate_first
02:51:36,453 INFO DriverManagerConnectionProvider:86 - connection properties: {user=zhtao, password=****}
02:51:36,703 ERROR SchemaExport:202 - schema export unsuccessful
java.sql.SQLException: Access denied for user 'zhtao'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
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.sysu.hibernate.ExportDB.main(ExportDB.java:16)
private String id;
private String name;
private String password;
private Date startTime;
private Date endTime; public Date getEndTime() {
return endTime;
} public void setEndTime(Date endTime) {
this.endTime = endTime;
} 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 getStartTime() {
return startTime;
} public void setStartTime(Date startTime) {
this.startTime = startTime;
}
}
////////
User.hbm.xml<?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.sysu.hibernate.User">
<id name="id">
<generator class ="uuid"/>
</id>
<property name="name"/>
<property name="password"/>
<property name="startTime"/>
<property name="endTime"/>
</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">zhtao</property>
<property name="hibernate.connection.password">zhtao</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<mapping resource="com/sysu/hibernate/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>////////////////
ExportDB.javapublic 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);
}}
//////////////
properties中没有修改任何东西
/////////////////////////报错信息如下:02:51:35,906 INFO Environment:514 - Hibernate 3.2.6
02:51:35,906 INFO Environment:547 - hibernate.properties not found
02:51:35,921 INFO Environment:681 - Bytecode provider name : cglib
02:51:35,921 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
02:51:35,984 INFO Configuration:1432 - configuring from resource: /hibernate.cfg.xml
02:51:35,984 INFO Configuration:1409 - Configuration resource: /hibernate.cfg.xml
02:51:36,218 INFO Configuration:559 - Reading mappings from resource : com/sysu/hibernate/User.hbm.xml
02:51:36,312 INFO HbmBinder:300 - Mapping class: com.sysu.hibernate.User -> User
02:51:36,343 INFO Configuration:1547 - Configured SessionFactory: null
02:51:36,359 INFO Dialect:152 - Using dialect: org.hibernate.dialect.MySQLDialect
02:51:36,453 INFO SchemaExport:154 - Running hbm2ddl schema export
02:51:36,453 DEBUG SchemaExport:170 - import file not found: /import.sql
02:51:36,453 INFO SchemaExport:179 - exporting generated schema to database
02:51:36,453 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
02:51:36,453 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
02:51:36,453 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
02:51:36,453 INFO DriverManagerConnectionProvider:80 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/hibernate_first
02:51:36,453 INFO DriverManagerConnectionProvider:86 - connection properties: {user=zhtao, password=****}
02:51:36,703 ERROR SchemaExport:202 - schema export unsuccessful
java.sql.SQLException: Access denied for user 'zhtao'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
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.sysu.hibernate.ExportDB.main(ExportDB.java:16)
解决方案 »
- 控制台打印值
- Tomcat启动出错,请在侠帮忙解决一下
- 初学EJB,求个EJB增删改查的例子源码学习,望有的扔一个,感谢大家
- java存储文件问题
- 如何将ResultSet作为blob字段的值写进数据库,请给详细的代码。
- javamail出了异常,请有经验的过来看一下,是什么问题,UP有分!
- JAVA在公司及企业中有实践应用吗?(给五十分)
- 关于写文件
- jb+weblogic开发中数据源配置的问题。
- 我在myeclipse中创建一个html文件,我想要连接我自己的数据库,怎样链接
- 高的求救**struts项目,发布出现404错误--在线等啊
- 从springframework的cvs上下载的源码居然有错??
的确是在用户名和密码处出了问题,
事实上我的用户名应该是root 结果写成了zhtao修改后程序顺利执行
哎~~~~~惭愧啊
分就给第一个回帖的吧 谢啦啊