Stefano, thanks for your response. Yes, it is working now.
But I have a major doubt on session.flush(). It was working without session.flush() when I begin the transaction with session.beginTransaction() and not setting external connection. When JTA UserTransaction is handled by application and external connection is set to the session, why session.flush() is required before committing? Cant session itself flush when JTA transaction is committed. Please clarify this difference. I would like to not use session.flush() in my code. Thanks for your suggessions. dosapati ----- Original Message ----- From: "Travelli Stefano" <[EMAIL PROTECTED]> To: "dosapati" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 3:06 PM Subject: R: [Hibernate] problem in using JTA datasources > Change the order of the last statements: > > // first flush the session > session.flush(); > // then close the session > session.close(); > // close the connection > cn.close(); > // and finally commit > ut.commit(); > > However you need better exception handling. Hibernate works great with JTA. > > I suggest you to read best practices in the web site. > > Hope this helps. > > stefano > > -----Messaggio originale----- > Da: dosapati [mailto:[EMAIL PROTECTED] > Inviato: giovedì 25 settembre 2003 9.46 > A: [EMAIL PROTECTED] > Oggetto: [Hibernate] problem in using JTA datasources > > > I am facing problems in using UserTransaction & JTA datasource with Hibernate. > > I am using JOTM as TransactionManager and XAPool ass JTA datasource. To use them, > first I resitered them from Tomcat's server.xml as Resources. > > My java code is like this: > > try { > Context ctx = new InitialContext(); > ut = (UserTransaction)ctx.lookup("java:comp/UserTransaction"); > ut.begin(); > javax.sql.DataSource myDataSource = (javax.sql.DataSource) ctx.lookup("java:comp/env/MyDataSource"); > myConn = myDataSource.getConnection(); > session = sessionFactory.openSession(myConn); > > Cat princess = new Cat(); > princess.setName("Princess"); > princess.setSex('F'); > princess.setWeight(7.4f); > session.save(princess); > session.save(princess); > > System.out.println("committing Transaction..."); > ut.commit(); > myConn.close(); > session.close(); > }catch(Exception ex) { > System.out.println("rollingback Transaction..."); > ut.rollback(); > } > > > The first print statement 'committing Transaction.....' is getting printed when I execute > the above code. But the changes are not getting updated in database. > > This is working when I start Transaction from session.beginTransaction() and not setting the > external connection to the Session object. > > What was the wrong with my code?. I could not find any example code or any post on using JTA > Transaction Manager and JTA datasource with Hibernate. Any suggessions are appreciated. > > Thanks in advance! > Dosapati ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
