autocommit is not the best approach. I suggest you to have a glance at the article for inspiration
http://www.onjava.com/pub/a/onjava/2005/05/18/swingxactions.html?page=1

Mark wrote:
I added "hibernate.connection.autocommit=true" to my hibernate.properties and that fixed it...

So I assume Spring by default does no Session/TX handling, unless I use the HibernateTransactionManager or do programmatic transaction handling... One last question, to get back to Tapestry - is Spring's OpenSessionInViewFilter <OpenSessionInViewFilter.html> going to work with Tapestry without limitations? I see all these posts about Tapernate and others, but I'm not sure whether OpenSessionInViewFilter will work...

Thanks,

MARK



Mark wrote:
Lutz Hühnken wrote:
I asked for applicationContext.xml, and I get a mysql log... well,
near enough :)
Sorry, I thought what I had found in the mysql log (the "set autocommit=0, no "commit" call and explicit "Rollback" call issued by Hibernate at shutdown) changed things a lot, but maybe not.
From your last mail I understand you have the same problem if you use
the mysql command line client.
No, the command line INSERT does make it, the records just don't get picked up by Hibernate...
So generally, your sql statements never get committed... which is
weird, because by default, mysql starts new connections with
autocommit enabled.
No, only the ones coming from my webapp do not get committed.

If you connect to mysql from the command line and do
select @@autocommit;
what do you get?
I get "1"
Oh, and although the classname you use for the jdbc driver still
works, since the mysql connector/j provides backwards compatibility in
this respect, nowadays people tend to use "com.mysql.jdbc.Driver"
because of a name change four years ago.
Ok, thanks, I changed that.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]


--
Thanks,

Konstantin Ignatyev

http://www.kgionline.com





PS: If this is a typical day on planet earth, humans will add fifteen million 
tons of carbon to the atmosphere, destroy 115 square miles of tropical 
rainforest, create seventy-two miles of desert, eliminate between forty to one 
hundred species, erode seventy-one million tons of topsoil, add 2.700 tons of 
CFCs to the stratosphere, and increase their population by 263.000

Bowers, C.A. The Culture of Denial: Why the Environmental Movement Needs a Strategy for Reforming Universities and Public Schools. New York: State University of New York Press, 1997: (4) (5) (p.206)


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to