I read the FAQ before I posted, and yes I've tried flushing the session and commiting the transaction but my object is not being saved to the database.

I'm using Hibernate3, the jTDS JDBC driver for SQL Server and M$ SQL Server.

Here's my code snippet:

// user is an object mapped via hibernate, search for said user
// works before we get to this code and we've updated the password
Session ds = GlobalData.sessionFactory.openSession();
Transaction t = ds.beginTransaction();
ds.update(user);
ds.flush();
t.commit();

Resulting object is not saved. Logs show this:

Apr 21 12:09:30 org.hibernate.SQL[DEBUG]: update kc2.dbo.users set role=?, password=?, email=?, firstName=?, lastName=?, giraffe=?, createDate=?, modifyDate=? where uuid=?
Apr 21 12:09:30 org.hibernate.jdbc.AbstractBatcher[DEBUG]: preparing statement
Apr 21 12:09:30 org.hibernate.jdbc.AbstractBatcher[DEBUG]: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
Apr 21 12:09:30 org.hibernate.jdbc.AbstractBatcher[DEBUG]: closing statement
Apr 21 12:09:30 org.hibernate.event.def.AbstractFlushingEventListener[DEBUG]: post flush
Apr 21 12:09:30 org.hibernate.transaction.CacheSynchronization[DEBUG]: transaction before completion callback
Apr 21 12:09:30 org.hibernate.jdbc.JDBCContext[DEBUG]: before transaction completion
Apr 21 12:09:30 org.hibernate.impl.SessionImpl[DEBUG]: before transaction completion
Apr 21 12:09:30 org.hibernate.transaction.CacheSynchronization[DEBUG]: transaction after completion callback, status: 3
Apr 21 12:09:30 org.hibernate.jdbc.JDBCContext[DEBUG]: after transaction completion
Apr 21 12:09:30 org.hibernate.impl.SessionImpl[DEBUG]: after transaction completion
Apr 21 12:09:30 org.hibernate.transaction.JTATransaction[DEBUG]: Committed JTA UserTransaction
Apr 21 12:09:30 org.hibernate.impl.SessionImpl[DEBUG]: closing session
Apr 21 12:09:30 org.hibernate.jdbc.AbstractBatcher[DEBUG]: closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)

Sorry, I should have said: update not updating

TIA,

J --

Actually... I've just added some more logging to make certain, but it appears the transaction is being automatically rolled back.

Any thoughts on why this might happen? There is not accompanying SQL error that would force my exception catch and corresponding rollback.

Instead, this rollback occurs right after the commit. Here's the code snippet:
{... from before}
tx.commit();
if (tx.wasCommitted())
log.debug("WOOOOOOOOOOOO!");
else
log.debug("WAAAAAAAAAANk!");

So, as you might guess, I'm getting a Wank in the log. Thoughts?

TIA,

J --

Have now also tried v3.0.1 of hibernate and have the same problem. Unless I set hibernate.connection.autocommit to true, any save/update is automatically rolled back.

Since no one else replied to this, I'll post my own fix for those of you who might run into this same problem.

The solution was to use the Resin pooling and tie the DB connectivity to JNDI rather than instantiating some other cache programatically in the web app.

It's all set now...