problem with hibernate integration

[sachin yadav]

Hi all,

i am trying to connect my sample test application with hibernate. Everthing is working fine except values are not getting into the database. I am putting up my XML file(both hbm and servlet configuration) and controller here.

 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
 
<beans>
 
<bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost/emp"/>
<property name="username" value="root"/>
<property name="password" value="admin2005"/>
</bean>
<bean id="SessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="myDataSource"/>
<property name="mappingResources">
<list>
<value>TestForm.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.MySQLDialect
</value>
</property>
</bean>
<!--
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="SessionFactory" />
</bean>
-->
   <bean id="testFormValidator" class="com.sachin.first.TestFormValidator"/>
 
   <bean id="testFormController" class="com.sachin.first.TestFormController">
        <property name="sessionForm"><value>true</value></property>
        <property name="validateOnBinding"><value>true</value></property>
        <property name="bindOnNewForm"><value>false</value></property>
        <property name="commandName"><value>testForm</value></property>
        <property name="commandClass"><value>com.sachin.first.TestForm</value></property>
        <property name="validator"><ref bean="testFormValidator"/></property>
<property name="formView"><value>form</value></property>
<property name="successView"><value>success</value></property>
<property name="sessionFactory" ref="SessionFactory"/>
   </bean>
 
    <bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
        <property name="basename"><value>messages</value></property>
    </bean>
 
    <bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
        <property name="mappings">
            <props>
    <prop key="/form.htm">testFormController</prop>
            </props>
        </property>
    </bean>
 
    <bean id="viewResolver" class="org.springframework.web.servlet.view.ResourceBundleViewResolver">
        <property name="basename"><value>views</value></property>
    </bean>
</beans>
 

Controller

package com.sachin.first;
import java.util.*;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.SimpleFormController;
import org.hibernate.SessionFactory;
 

public class TestFormController extends SimpleFormController{
 
protected ModelAndView onBindRequest()
{
TestForm form = new TestForm();
   try
{
this.sessionFactory.getCurrentSession().merge(form);
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Excepion in controller "+e);
}
 
Map items = new HashMap();
        items.put("testForm", form);
return new ModelAndView("success",items);
}
 
SessionFactory sessionFactory;
 
    public SessionFactory getSessionFactory()
    {
        return sessionFactory;
    }
 
    public void setSessionFactory(SessionFactory sessionFactory)
    {
        this.sessionFactory = sessionFactory;
    }
 
}
 

TestForm.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 package="com.sachin.first">
<class name="TestForm" table="employee">
<id name="name" column="eid" unsaved-value="null">
<generator class="assigned"></generator>
</id>
<property name="comments" type="string">
<column name="ename"></column>
</property>
</class>
</hibernate-mapping>

Any help would be appreciated.

[Manuel Jordan]

Hello Sachin

can you show how you insert and load the info into the database???

i dont see something like this

hibernateTemplate.load(TestForm.class,"idvalue");

regards

[sachin yadav]

Originally posted by Manuel Jordan:
Hello Sachin

can you show how you insert and load the info into the database???

i dont see something like this

hibernateTemplate.load(TestForm.class,"idvalue");

regards

i did this in the controller itself using "this.sessionFactory.getCurrentSession().merge(form);".

I think that the above like should have data inserted in database.

Please correct me if i am wrong as i am new to hibernate and spring.

[Manuel Jordan]

Hello Sachin

if you see the api hibernate documentation, for method
merge

maybe i am worng, but the first that you can read in the link is this

  Copy the state of the given object onto the persistent object with the same identifier  

nothing about to copy to the database

you should work with

  import org.springframework.orm.hibernate3.HibernateTemplate;  

and this is a standard and is used and shown in the Spring documentation

please see this example case

maybe the merge method should work (really i dont know, i never used), but using the standard way of the documentation should avoid any problem

best wishes

Manuel
[ November 14, 2006: Message edited by: Manuel Jordan ]

[sachin yadav]

dear Manuel,

thank you for your reply. I have now changed my controller to hibernate template, though my previous style was also from a working example but i think if we are stuck we should take alternatives. But the amazing fact i found here is that -
1). Application is still not working.
2). It's not even giving me any error or exception anywhere when i put wrong or noname/password in my configuation file.

So i think my program is not even boathering to connect to the database. Did you see any problem in the code above?

[Manuel Jordan]

Dear sachin

everyone of us was a rookie about this configuration integration, a hell,
but then is easy

please copy your new java class using the HibernateTemplate

in your Context.xml

you must have this, i saw that you have commented one.

<bean id="transactionManager"   class="org.springframework.orm.hibernate3.HibernateTransactionManager">
   <property name="sessionFactory">
<ref bean="sessionFactory"/>
   </property>
</bean>
<!-- you no have this -->
<bean id="hibernateInterceptor"  
      class="org.springframework.orm.hibernate3.HibernateInterceptor">
    <property name="sessionFactory">
         <ref bean="sessionFactory"/>
    </property>
</bean>

both are very important


what version of Spring you are using??

i saw this

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

if is version 2.0 stable, you should have this, instead of the mentionated

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"
"http://www.springframework.org/dtd/spring-beans-2.0.dtd">

and i dont see nothing about this (the hibernates properties), this the mime for example

<property name="hibernateProperties">
 <props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop>
<!-- JDBC connection pool (use the built-in) -->
<prop key="hibernate.connection.pool_size" >1</prop>
<!-- Enable Hibernate's automatic session context management -->
<prop key="hibernate.current_session_context_class" >thread</prop>
<!-- Disable the second-level cache  -->
<prop key="hibernate.cache.provider_class" >org.hibernate.cache.NoCacheProvider</prop>
<!-- Echo all executed SQL to stdout -->
<prop key="hibernate.show_sql" >true</prop>

<!-- Drop and re-create the database schema on startup WARNING WITH THIS-->
<prop key="hibernate.hbm2ddl.auto" >create-drop</prop> 

<prop key="hibernate.c3p0.min_size" >1</prop>
<prop key="hibernate.c3p0.max_size">5<prop>
<prop key="hibernate.c3p0.timeout" >300</prop>
<prop key="hibernate.c3p0.max_statements" >50</prop>
<prop key="hibernate.c3p0.idle_test_preriod" >3000</prop>
 </props>
</property>

you must add now some new jars like the c3p0.jar and maybe others

with this you now have no problem, please see the spring documentation, you will see
"templates about configuration"

regards