Hi,

I am having application with struts2 + mysql + hibernate simple DAO patter with Tomcat 5.x.

i want to use hibernate transaction,can anybody suggest which one is the best suitable strategy for my application.

My
hibernate.cfg.xml(using c3p0 connection pooling/plain jdbc connection)




My SessionFactory class.


public class HibernateSessionFactory {

private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";

private static Configuration configuration = new Configuration();


private static org.hibernate.SessionFactory sessionFactory;


private static String configFile = CONFIG_FILE_LOCATION;

private HibernateSessionFactory() {
}

public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();

if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}

return session;
}

public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}

public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);

if (session != null) {
session.close();
}
}

public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}

public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}

public static Configuration getConfiguration() {
return configuration;
}
}


My DataAccess class

public void saveOrUpdate(Customers transientInstance) throws Exception, Throwable {
getSession().saveOrUpdate(transientInstance);
getSession().flush();
}


Now problem is where can i place transaction code and by which strategy (JTA,plain jdbc,EJB/Cmt) ?

thanks in advanced
regards,
jignesh

As I understand your application, local transactions are good enough, and you may use org.hibernate.transaction.JDBCTransactionFactory.


Farzad-

Hi,
I am using the simple local transaction strategy but it fails to make rollback on exception.

Here is my test case.

Ttp ttp = new Ttp();
ttp.setCity("private1");
ttp.setContact("contact1");
ttp.setCountry("country1");
ttp.setEmail("email1");
ttp.setName("name1");
org.hibernate.Transaction trx = null;

try {
trx = isp.services.IspDao.getTtpDao().getSession().beginTransaction();
isp.services.IspDao.getTtpDao().getSession().save(ttp);
int l =9/0;
trx.commit();
}
catch (Exception e) {
System.out.println("~~~~~~~~~~~~ROLLED BACK 2~~~~~~~~");
trx.rollback();
// TODO Auto-generated catch block
e.printStackTrace();
}

I have generated divide by zero exception and goes to catch block but it still saves the object into db.

Can u help me where can i miss the configuration.

Thanks,
jignesh

One more thing perhaps is it ok or not.
Hibernate can not be able to rollback if you are using "identity " as generator class in mysql.

while with the same configuration but different generator class transaction,rollback works what they should be.

I can't think of anything with the information I have now. Can you show me what you see on the logs. Can you show me the hibernate config file you have now? and please use the code tags so that the post is formatted nicely. Im half blind :)

Farzad-

Sorry for the inconvenience,

hibernate.cfg.xml(using c3p0 connection pooling/plain jdbc connection)

[/code]

My SessionFactory class.



MyDataAccess class



br,
jignesh

Sorry you basically repeated the first post. Show me the parts in hibernate configuration that sets up transaction stuff. However, I still have no explanation why identity setting is causing the problem.


Farzad-

Here is my test main class and i have generated the divide By Zero exception exactly after the saveOrUpdate method.
It should make rollback but it still saves the row using those data i have provided.