Session onject throwing exception when trying to save a object or begin a transaction

[venkatPrasad Regula]

I have written a simple hibernate code to save an object. When I type session.save(0 or session.beginTransaction(), it is throwing an exception. My code is given below

package de.laliluna.example;

import java.util.Iterator;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import de.laliluna.hibernate.SessionFactoryUtil;

public class TestExample {

  final static Logger logger = LoggerFactory.getLogger(TestExample.class);

  /**
   * @param args
   */
  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();
				//Create new instance of Contact and set values in it by reading them from form object
			 	System.out.println("Inserting Record");
			 	Honey forestHoney = new Honey();
			 	System.out.println("Inserting Record2");
			 	forestHoney.setId(6);
			 	System.out.println("Inserting Record3");
			    forestHoney.setName("forest honey");
			    System.out.println("Inserting Record4");
			    forestHoney.setTaste("very sweet");
			    System.out.println("Inserting Record5");
				session.save(forestHoney);
				System.out.println("Inserting Record6");
				System.out.println("Done");
				System.out.println("Inserting Record7");
		}catch(Exception e){
			System.out.println(e.getMessage());
		}finally{
			session.flush();
			session.close();
		}

The output is

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Inserting Record
Inserting Record2
Inserting Record3
Inserting Record4
Inserting Record5
Cannot open connectio

[venkatPrasad Regula]

Same thing is happening if I try to start a Transaction too.

Transaction tx = session.beginTransaction();

[Samrat Gadamsetty]

Can you show us the mapping and hibernate configuration file?

[venkatPrasad Regula]

Hibernate Mapping File

<?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="de.laliluna.example.Honey" table="honey">
 <id name="id" column="id" >
 <generator class="increment"/>
 </id>
 <property name="name" column="fooname" />
 <property name="taste" column="bartaste" />
 </class>
</hibernate-mapping>

Hibernate Cfg file

<?xml version='1.0' encoding='UTF-8'?>
<!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.driver_class">com.mysql.jdbc.Driver</property>
      <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mysql</property>
      <property name="hibernate.connection.username">root</property>
      <property name="hibernate.connection.password">helloworld</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>
      <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property> 
	<!-- mapping files -->
	<mapping resource="de/laliluna/example/Honey.hbm.xml" />

</session-factory>
</hibernate-configuration>

[venkatPrasad Regula]

If I try the example given on RoseIndia website it is working. I am really not able to identify what the fault is.

[Samrat Gadamsetty]

print the exception full stack trace and see you can find anything useful...

[venkatPrasad Regula]

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Inserting Record
Inserting Record2
Inserting Record3
Inserting Record4
Inserting Record5
org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:145)
	at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107)
	at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:68)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:122)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
	at de.laliluna.example.TestExample.main(TestExample.java:40)
Caused by: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
	at com.mysql.jdbc.MysqlIO.init(Unknown Source)
	at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
	at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
	at com.mysql.jdbc.Driver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:620)
	at java.sql.DriverManager.getConnection(DriverManager.java:169)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	... 14 more

I started the server too
Server info displayed is

root
localhost
/var/run/mysqld/mysqld.sock

MySQL 5.1.41-3ubuntu12.6
localhost
127.0.0.1

[Samrat Gadamsetty]

Change the code in ( probably it may work..I'm not sure..)

SessionFactory sessionFactory=new Configuration().configure("hibernate.cfg.xml").buildSessionFactory();
and run with exception full stack trace...
we hope the best..

[venkatPrasad Regula]

The issue got resolved as I placed an higher version of mysql jar file

mysql-connector-java-5.1.14-bin.jar