Hibernate version:
3.1.2

Mapping documents:
hibernate.cfg.xml
<?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 name="SessionFactory">
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="hibernate.connection.password">30b12a87</property>
<property name="hibernate.connection.url">jdbc:mysql:///kdc</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.current_session_context_class">jta</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.jta.UserTransaction">UserTransaction</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
<mapping resource="com/kdccn/general/entity/User.hbm.xml" />
</session-factory>
</hibernate-configuration>

Code between sessionFactory.openSession() and session.close():
org.hibernate.Session s;
Configuration cfg = new Configuration().configure();
org.hibernate.SessionFactory sf=cfg.buildSessionFactory();
s = sf.openSession();
UserTransaction tx=(UserTransaction)new InitialContext().lookup("UserTransaction");
tx.begin();
org.hibernate.Session s1=sf.getCurrentSession();
User user = new User();
user.setUsername("Someone");
user.setPassword("guessme");
s1.save(user);
tx.commit();
s.close();

The problem is that it seems that the commit() failed. I try to check the rows in the MySQL Administrator. It showed that the rows is 1. But after I select the results, it returns none. I thought it is the problem with jta.

Can someone give me some sucessful example with JTA

please help me, this problem disturb me very much

Hi,

I do not think that you can use JDBC directly with JTA (but I may be wrong here).

So instead of the following lines:


you should give your connection datasource, e.g.:

Of course you also will have to configure your datasource in your appserver.

maybe this helps...

best regards
Stefan

whether you run in a managed (ejb) env or not (ie webserver), hibernate makes transactions transparent to the user... in other words, you should just call

tx=sess.beginTransaction();
sess.save(...);
tx.commit();

If it is in a managed env, then the JTA will be used, else a simple jdbc transaction is used.

Unfortunately, this is not true, because the getCurrentSession() functions expects a running JTA Transaction when it is called. According to the Hibernate reference, chapter 11.2.2 "Using JTA", you have to use the JTA API directly...

http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf

OK - so did you read 11.2.2? It states exactly what I said. Where does it say that you need to use the JTA API directly... I could not find it...

I quote two sources from the reference.pdf, that support my statements:

3.8.3. Current Session context management with JTA


From 11.2.2. Using JTA


Again..."So, the transaction management code is identical to the nonmanaged environment."

In 11.2.2 it says:



So in my opinion, what you say is only true for as long as you do not use getCurrentSession()... Anyway, I agree with you that even with getCurrentSession(), it should be possible to use the Hibernate Transaction API. But the problem is that the Transaction must be started before you call getCurrentSession(), so I do not see how it would be possible as you neet the session to start a transaction using the Hibernate Transaction API.

I am looking at the reference.pdf for hibernate 3.1, as referenced in the URL that I gave, and I don't see your quote at all? Perhaps this has changed from previous versions.?? What doc are you looking at?

I looked at the reference pdf for Hibernate 3.1.2, but it is also in the link you sent: page 127, approximately in the middle.

interesting - the 3.1 docs that are online are different than the 3.1 docs that were distributed with 3.1.1 zip file... OK so now that we are on the same page, I interpret that to mean that if you want your entire "Session" under the control of the transaction, vs transactions within a session.

eg.
JTA managed transaction
session
work
session.close()
JTA ending trx.

vs.

session.beginTransaction()
work....
tx.commit()

which should still work with JTA in the managed env.

Does that sound right to you too?

I had the same problem. Looks like save(insert to table) doesn't works with JTA transactions : Hibernate + JOTM + Tomcat.

But then I configured Datasource in Tomcat and it works !!!!
remove this:

<property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="hibernate.connection.password">30b12a87</property>
<property name="hibernate.connection.url">jdbc:mysql:///kdc</property>
<property name="hibernate.connection.username">root</property>

put this:

<property name="connection.datasource">java:comp/env/jdbc/rzbrss_oratgr_xa</property>