[jboss-user] [JBoss Seam] - Re: Problem in Booking Ex. from Seam 1.0.1 GA causes misbeha

[widura]

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