Indeed, you're right! After deploying the original Seam 1.0.1 GA Booking Example I haven't encountered this problem again. So I tried to figure out what my problem is. The only thing I changed in the booking example was the booking-ds.xml which I defined to use a MySQL Database as datasource:
<?xml version="1.0" encoding="UTF-8"?> | <datasources> | <local-tx-datasource> | <jndi-name>bookingDatasource</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/seam-booking</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>syscom</user-name> | <password>ysy758</password> | </local-tx-datasource> | </datasources> I am using MySQL 5.0.11 and the MySQL Connector 3.1.13. To sum it up: The misbehaviour does exist but only when using MySQL as datasource with the configuration above. And it must have to do something with transactions. Because after commenting out @TransactionAttribute(REQUIRES_NEW) in BookingListAction everything worked out again. Then I checked if my database tables support transactions and they do by being InnoDB tables. I also checked my persistence.xml which defines the appropriate MySQLInnoDB dialect. <persistence> | <persistence-unit name="bookingDatabase"> | <provider>org.hibernate.ejb.HibernatePersistence</provider> | <jta-data-source>java:/bookingDatasource</jta-data-source> | <properties> | <property name="hibernate.hbm2ddl.auto" value="create"/> | <property name="hibernate.show_sql" value="true"/> | <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/> | <!-- These are the default for JBoss EJB3, but not for HEM: --> | <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/> | <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/> | </properties> | </persistence-unit> | </persistence> Is there maybe something missing related to transactions in my datasource definition or anywhere else? Widura View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3974810#3974810 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3974810 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
