You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tapestry.apache.org by Kejo Starosta <k...@zapfanlagen.biz> on 2009/02/26 08:34:28 UTC

Trouble with Transactions in tapestry-hibernate

Hi!

I've a problem with the rollback of transactions on tapestry-hibernate.
I use Typestry 5.0.18 with MySql on the backend. If make 80 Inserts and 
I try to rollback the transaction with HibernateSessionManager.abort() 
nothing happens, everything is committed and stored into the database.
Yesterday I tried to find the problem almost the whole day and I'm 
almost sure my source is ok :-)
I also turned off explicitly <property 
name="hibernate.connection.autocommit">false</property>

I'm also sure my app runs not over a @CommitAfter and I'm also sure I 
don't commit manually, but still everything is committed and stored into 
the database.

Anyone has the same problem? I'm getting a bit nervous about this 
failure :-(

nice greetz,

Kejo

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org

Re: Trouble with Transactions in tapestry-hibernate

Posted by "Thiago H. de Paula Figueiredo" <th...@gmail.com>.
Em Thu, 26 Feb 2009 04:34:28 -0300, Kejo Starosta <k...@zapfanlagen.biz>  
escreveu:

> I've a problem with the rollback of transactions on tapestry-hibernate.
> I use Typestry 5.0.18 with MySql on the backend.

Are your sure you're not using MyISAM tables? They don't have transaction  
support . . .

-- 
Thiago H. de Paula Figueiredo
Independent Java consultant, developer, and instructor
http://www.arsmachina.com.br/thiago

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org

Re: Trouble with Transactions in tapestry-hibernate

Posted by Ville Virtanen <vi...@cerion.fi>.
Check MySQL documentation, MyISAM tables DO NOT support TRANSACTIONS OR
FOREIGN KEYS...

(the correct one is innodb, use
configuration.setProperty(Environment.DIALECT,
MySQL5InnoDBDialect.class.getName()); to force Hibernate to use inno db
tables when creating database...)

 - Ville


Kejo Starosta wrote:
> 
> Hi!
> 
> I've a problem with the rollback of transactions on tapestry-hibernate.
> I use Typestry 5.0.18 with MySql on the backend. If make 80 Inserts and 
> I try to rollback the transaction with HibernateSessionManager.abort() 
> nothing happens, everything is committed and stored into the database.
> Yesterday I tried to find the problem almost the whole day and I'm 
> almost sure my source is ok :-)
> I also turned off explicitly <property 
> name="hibernate.connection.autocommit">false</property>
> 
> I'm also sure my app runs not over a @CommitAfter and I'm also sure I 
> don't commit manually, but still everything is committed and stored into 
> the database.
> 
> Anyone has the same problem? I'm getting a bit nervous about this 
> failure :-(
> 
> nice greetz,
> 
> Kejo
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
> For additional commands, e-mail: users-help@tapestry.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Trouble-with-Transactions-in-tapestry-hibernate-tp22226012p22227995.html
Sent from the Tapestry - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org

Re: Trouble with Transactions in tapestry-hibernate

Posted by Kejo Starosta <k...@zapfanlagen.biz>.
Wow this Mailing List is fast :-)

Thank you for your replies, i fixed the problem finally!

Kristian Marinkovic wrote:
> Tapestry 5 will open a new Transaction on every request.
> If you do not call commit explicitly Tapestry will rollback the
> Transaction after the request.
>
> i'd guess it has something to do with your mysql settings. have 
> you tried using hsqldb? does your problem still occur?
>
> g,
> kris
>
>
>
>
>
> Kejo Starosta <k...@zapfanlagen.biz> 
> 26.02.2009 08:34
> Bitte antworten an
> "Tapestry users" <us...@tapestry.apache.org>
>
>
> An
> users@tapestry.apache.org
> Kopie
>
> Thema
> Trouble with Transactions in tapestry-hibernate
>
>
>
>
>
>
>
> Hi!
>
> I've a problem with the rollback of transactions on tapestry-hibernate.
> I use Typestry 5.0.18 with MySql on the backend. If make 80 Inserts and 
> I try to rollback the transaction with HibernateSessionManager.abort() 
> nothing happens, everything is committed and stored into the database.
> Yesterday I tried to find the problem almost the whole day and I'm 
> almost sure my source is ok :-)
> I also turned off explicitly <property 
> name="hibernate.connection.autocommit">false</property>
>
> I'm also sure my app runs not over a @CommitAfter and I'm also sure I 
> don't commit manually, but still everything is committed and stored into 
> the database.
>
> Anyone has the same problem? I'm getting a bit nervous about this 
> failure :-(
>
> nice greetz,
>
> Kejo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
> For additional commands, e-mail: users-help@tapestry.apache.org
>
>
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org

Re: Trouble with Transactions in tapestry-hibernate

Posted by Kristian Marinkovic <kr...@porsche.co.at>.
Tapestry 5 will open a new Transaction on every request.
If you do not call commit explicitly Tapestry will rollback the
Transaction after the request.

i'd guess it has something to do with your mysql settings. have 
you tried using hsqldb? does your problem still occur?

g,
kris





Kejo Starosta <k...@zapfanlagen.biz> 
26.02.2009 08:34
Bitte antworten an
"Tapestry users" <us...@tapestry.apache.org>


An
users@tapestry.apache.org
Kopie

Thema
Trouble with Transactions in tapestry-hibernate







Hi!

I've a problem with the rollback of transactions on tapestry-hibernate.
I use Typestry 5.0.18 with MySql on the backend. If make 80 Inserts and 
I try to rollback the transaction with HibernateSessionManager.abort() 
nothing happens, everything is committed and stored into the database.
Yesterday I tried to find the problem almost the whole day and I'm 
almost sure my source is ok :-)
I also turned off explicitly <property 
name="hibernate.connection.autocommit">false</property>

I'm also sure my app runs not over a @CommitAfter and I'm also sure I 
don't commit manually, but still everything is committed and stored into 
the database.

Anyone has the same problem? I'm getting a bit nervous about this 
failure :-(

nice greetz,

Kejo

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org