I need some help in setting up Hibernate to work with my DB. I have installed eclipse and mysql and written a simple program to store a table in the db. But the database connection is failing when I run my program it gives the below error message.

Caused by: java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user 'anandi'@'localhost' (using password: YES)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1786)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)

I am using the below configuration file.
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/contact</property>
<property name="hibernate.connection.username">anandi</property>
<property name="hibernate.connection.password">anandi</property>
<property name="hibernate.connection.pool_size">10</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- Mapping files -->
<mapping resource="contact.hbm.xml"/>

I have installed mysql where there is a database called contact and also it has a table called contact. Also the username and password I have provided in the above file is correct and the database is running. Still I am getting the above error. Can anyone guide me as to what might be the problem ? Any help would be highly appreciated.

Check your firewall is turned on. If so kindly allow an exception to mysql. First test your connection from third party tool like SQLyog.

This is not a firewall problem. The error message is typical for MySQL when you can connect to the server but the account doesn't exist or if the account is not allowed to connect to the specified database from the a given host. You need to connect to the MySQL server as an admin and issue something like:



You may want to have less permissions than ALL, but that is what I usually have on my development box.

As an alternative you may try different host names in the connection URL. Sometimes it helps to use the real host name or ip address. It all depends on which permissions you have granted to the account.

Hello,

Thank you very much for your help. That did the trick and the exception is gone.
However, I am facing a different issue now. The program that I have written is to insert a row in the contact database which has a table called contact. When I execute the program, it runs without any errors and gives the following output --

Hibernate: insert into CONTACT (FIRSTNAME, LASTNAME, EMAIL, ID) values (?, ?, ?, ?)

However, when I actually do a select * from contact; in mysql, I am not able to see the entries I entered through Hibernate. This is a bit surprising because there are no exceptions when I run my program. Any ideas on what I am missing. I really appreciate your help in getting this resolved.

Below is the code:
public static void main(String[] args) {
Session session = null;

try{
// This step will read hibernate.cfg.xml and prepare hibernate for use
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();
Contact contact = new Contact();
contact.setId(1);
contact.setFirstName("asdad");
contact.setLastName("Kumar");
contact.setEmail("deepak");
session.save(contact);
}catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}finally{
session.flush();
session.close();

}

}

That is probably because your code is lacking transaction management. Start by reading http://docs.jboss.org/hibernate/core/3. ... emarcation for a few code examples.