Hello
I'm using Spring and Hibernate v.3.2 with MySql. when I'm doing update or insert it looked ok and the data is saved but not in the database it saved just in cash.
Do I need to change sothing in mySql configuration fil?

-------- hibernate-configuration ------------

<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>

<session-factory>
<property name="connection.username">root</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/games
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="myeclipse.connection.profile">
MySql Connector 5.1.7
</property>
<property name="connection.password">1234</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="pool_size">12</property>
<property name="hibernate.hbm2ddl.auto">update</property>
</session-factory>

</hibernate-configuration>


----- BusinessLogic Code ---------

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

import org.hibernate.Transaction;
import org.springframework.beans.BeansException;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;

public class BusinessLogic {
public static void main(String[] args) {

/* 2. Load the Spring bean configuration and create a bean factory */
BeanFactory beanFactory = new XmlBeanFactory(new ClassPathResource(
"applicationContext.xml"));

System.out.println(beanFactory);
/* 3. Create instance of PersistenceLayer */

/* 5. Confirm that our user was saved */
Test2 userLoadedFromDB;
try {
PersistenceLayer persistenceLayer = (PersistenceLayer) beanFactory
.getBean("PersistenceLayer");

Test2 test2 = new Test2();
test2.setId(new Integer(33));
test2.setName("Adidas");
/* 4. Save the new user to the database */

persistenceLayer.addTest2DAO(test2);


userLoadedFromDB = persistenceLayer.findTest2DAO(new Integer(11));
System.out.println("User Loaded from DB Name="+ userLoadedFromDB.getName());
/* 6. Update the user */
userLoadedFromDB.setName("Gillgoolina");
userLoadedFromDB.setId(new Integer(14));
persistenceLayer.updateTest2DAO(userLoadedFromDB);

/* 7. Confirm that the update worked */
List all = persistenceLayer.getAll();
for(Iterator i=all.iterator(); i.hasNext();){
Test2 t2 = (Test2)i.next();
System.out.println(t2.getId()+ " name: " + t2.getName());
}

/* 8. Delete the user */
// persistenceLayer.deleteUser(user);
} catch (BeansException e) {
System.out.println("BeansException: "+e.getMessage());
//e.printStackTrace();
}

}
}

What does the code within PersistenceLayer look like?

It's difficult to tell what's going on when we can't see how you're interacting with Hibernate.

--
Stephen Souness

The PersistenceLayer code

package snir.test.hibernatespring;

import java.util.List;

public class PersistenceLayer {
private Test2DAO test2DAO;

public Test2DAO getTest2DAO() {
return test2DAO;
}

public void setTest2DAO(Test2DAO test2DAO) {
this.test2DAO = test2DAO;
}

public void addTest2DAO(Test2 test2) {
test2DAO.save(test2);
}

public Test2 findTest2DAO(Integer id) {
return test2DAO.findById(id);
}

public void updateTest2DAO(Test2 test2) {
test2DAO.merge(test2);
}

public void deleteTest2DAO(Test2 test2) {
test2DAO.delete(test2);
}

public List getAll(){
return test2DAO.findAll();
}
}

Okay, still no sign of any Hibernate code, what's happening in the Test2DAO.save and Test2DAO.merge methods?

I suspect that the changes are not being flushed to the database.

The code of class Test2DAO

package snir.test.hibernatespring;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.hibernate.Transaction;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

/**
* A data access object (DAO) providing persistence and search support for Test2
* entities. Transaction control of the save(), update() and delete() operations
* can directly support Spring container-managed transactions or they can be
* augmented to handle user-managed Spring transactions. Each of these methods
* provides additional information for how to configure it for the desired type
* of transaction control.
*
* @see snir.test.hibernatespring.Test2
* @author MyEclipse Persistence Tools
*/

public class Test2DAO extends HibernateDaoSupport {
private static final Log log = LogFactory.getLog(Test2DAO.class);
// property constants
public static final String NAME = "name";

protected void initDao() {
// do nothing

}

public void save(Test2 transientInstance) {
log.debug("saving Test2 instance");
try {
getHibernateTemplate().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}

public void delete(Test2 persistentInstance) {
log.debug("deleting Test2 instance");
try {
getHibernateTemplate().delete(persistentInstance);
log.debug("delete successful");
} catch (RuntimeException re) {
log.error("delete failed", re);
throw re;
}
}

public Test2 findById(java.lang.Integer id) {
log.debug("getting Test2 instance with id: " + id);
try {
Test2 instance = (Test2) getHibernateTemplate().get(
"snir.test.hibernatespring.Test2", id);
return instance;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
}

public List<Test2> findByExample(Test2 instance) {
log.debug("finding Test2 instance by example");
try {
List<Test2> results = (List<Test2>) getHibernateTemplate()
.findByExample(instance);
log.debug("find by example successful, result size: "
+ results.size());
return results;
} catch (RuntimeException re) {
log.error("find by example failed", re);
throw re;
}
}

public List findByProperty(String propertyName, Object value) {
log.debug("finding Test2 instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from Test2 as model where model."
+ propertyName + "= ?";
return getHibernateTemplate().find(queryString, value);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}

public List<Test2> findByName(Object name) {
return findByProperty(NAME, name);
}

public List findAll() {
log.debug("finding all Test2 instances");
try {
String queryString = "from Test2";
return getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}

public Test2 merge(Test2 detachedInstance) {
log.debug("merging Test2 instance");
try {
Test2 result = (Test2) getHibernateTemplate().merge(
detachedInstance);
log.debug("merge successful");
return result;
} catch (RuntimeException re) {
log.error("merge failed", re);
throw re;
}
}

public void attachDirty(Test2 instance) {
log.debug("attaching dirty Test2 instance");
try {
getHibernateTemplate().saveOrUpdate(instance);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}

public void attachClean(Test2 instance) {
log.debug("attaching clean Test2 instance");
try {
getHibernateTemplate().lock(instance, LockMode.NONE);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}

public static Test2DAO getFromApplicationContext(ApplicationContext ctx) {
return (Test2DAO) ctx.getBean("Test2DAO");
}
}

I just saw Marten's response on the Spring forum - he's right.

Ok Tanks I will try to do this in PersistenceLayer.addTest2DAO()

addTest2DAO(){
Session session = HibernateSessionFactory .getSession();
Transaction tx = session.beginTransaction();
tx.begin();
session.persist(test2);

test2DAO.save(test2);
session.flush();
tx.commit();
}

I have don this:


But I got that:

Hi,



Here you are updating the identifier of an instance. As far as I know, this is not an allowed operation.

- Litty

Tanks I fixed it its all working now

Hw did u fix it?

Yes thenk you