求大神指导下用Hibernate连接MySQL出错

coura棘 2015-08-21 02:48:19

用纯JDBC连接mysql没有问题，用户名root 密码为空



   public class TestMysql {

        public static void main(String[] args) {

            try {

                Class.forName("com.mysql.jdbc.Driver");

                Connection ct=DriverManager.getConnection("jdbc:mysql://localhost:3306/elec", "root", "");

                PreparedStatement ps=ct.prepareStatement("select * from elec_text");

                ResultSet rs=ps.executeQuery();

                while(rs.next()){

                    System.out.println(rs.getString(1));

                    System.out.println(rs.getString(2));

                    System.out.println(rs.getString(3));

                }

            } catch (Exception e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

        }

    }

可连接输出



1

张三

2015-08-12

当我用Hibernate去连接mysql的时候出错
domain



import java.util.Date;

/**

 * PO持久层对象，对应数据库Elec_text表

 * @author xiaodundun

 *

 */

public class ElecText implements java.io.Serializable{

    private String textID;

    private String textName;

    private Date textDate;

    private String textRemark;

    //set get 方法

hbm.xml



<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC 

    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

	<class name="cn.itcast.elec.domain.ElecText" table="Elec_Text"

		catalog="Elec" schema="dbo">

		<id name="textID" type="java.lang.String">

			<column name="textID" sql-type="varchar(50)" not-null="true"></column>

			<generator class="uuid"></generator>

		</id>

		<property name="textName" type="java.lang.String">

			<column name="textName" sql-type="varchar(50)" />

		</property>



		<property name="textDate" type="date">

			<column name="textDate" length="50"></column>

		</property>

		<property name="textRemark" type="java.lang.String">

			<column name="textRemark" sql-type="varchar(500)" />

		</property>

	</class>

</hibernate-mapping>

cfg.xml



<hibernate-configuration>

	<session-factory>

		<property name="hibernate.connection.driver_class">

			com.mysql.jdbc.Driver

		</property>

       <property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/elec?useUnicode=true&characterEncoding=utf8</property>		

       <property name="hibernate.connection.username ">root</property>

		<property name="hibernate.connection.password "></property>

		<property name="hibernate.dialect">

			org.hibernate.dialect.MySQLDialect

		</property>

		<property name="hibernate.show_sql">true</property>

		<property name="hibernate.hbm2ddl.auto">update</property>

		<mapping resource="cn/itcast/elec/domain/ElecText.hbm.xml" />

	</session-factory>

</hibernate-configuration>

报错



Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect

	at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:122)

	at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:140)

	at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:58)

	at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:75)

	at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:106)

	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)

	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)

	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)

	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesImpl.java:260)

	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:94)

	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)

	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)

	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)

	at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)

	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)

	at com.testUtil.TestHi.main(TestHi.java:26)

Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

	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:3558)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)

	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)

	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)

	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)

	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)

	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

	at java.lang.reflect.Constructor.newInstance(Unknown Source)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)

	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)

	at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:55)

	... 13 more