3 Replies Latest reply on Mar 30, 2006 9:27 AM by Da RINCE

    Booking Example on MySQL?

    Da RINCE Newbie

      I'm new to seam and EJB programming in general so i'm just playing around with the seam examples.

      Now i'm trying to run the booking example with MySQL as a persistence backend but I just can't get it to work, so any help would be greatly appreciated.

      So far i've changed the booking-ds.xml file to the following:

      <?xml version="1.0" encoding="UTF-8"?>
      
      <datasources>
       <local-tx-datasource>
       <!-- This connection pool will be bound into JNDI with the name
       "java:/MySQLDB" -->
      
       <jndi-name>bookingDatasource</jndi-name>
       <connection-url>jdbc:mysql://localhost:3306/jboss</connection-url>
       <driver-class>com.mysql.jdbc.Driver</driver-class>
       <user-name>user</user-name>
       <password>password</password>
      
       <min-pool-size>5</min-pool-size>
      
       <!-- Don't set this any higher than max_connections on your
       MySQL server, usually this should be a 10 or a few 10's
       of connections, not hundreds or thousands -->
      
       <max-pool-size>20</max-pool-size>
      
       <!-- Don't allow connections to hang out idle too long,
       never longer than what wait_timeout is set to on the
       server...A few minutes is usually okay here,
       it depends on your application
       and how much spikey load it will see -->
      
       <idle-timeout-minutes>5</idle-timeout-minutes>
      
       <!-- If you're using Connector/J 3.1.8 or newer, you can use
       our implementation of these to increase the robustness
       of the connection pool. -->
      
       <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
       <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
      
       </local-tx-datasource>
      </datasources>
      


      Then I changed the persistence.xml file to:
      <persistence xmlns="http://java.sun.com/xml/ns/persistence"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
       version="1.0">
       <persistence-unit name="bookingDatabase">
       <provider>org.hibernate.ejb.HibernatePersistence</provider>
       <jta-data-source>java:/bookingDatasource</jta-data-source>
       <properties>
       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
       <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
       </properties>
       </persistence-unit>
      </persistence>
      


      So far so good, if I deploy the app 3 tables (Booking, Hotel, User) get created in the MySQL DB. The import script throws an error though, because the state field in the Hotel table is set to varchar(2) and the import.sql file contains states with a longer name, but that can be fixed easily (either change the import.sql file or change the annotation in the Hotel class).

      14:29:21,464 INFO [Environment] Hibernate 3.1.2
      14:29:21,528 INFO [Environment] hibernate.properties not found
      14:29:21,585 INFO [Environment] using CGLIB reflection optimizer
      14:29:21,586 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
      14:29:22,013 INFO [Ejb3Configuration] found EJB3 Entity bean: org.jboss.seam.example.booking.Booking
      14:29:22,081 INFO [Ejb3Configuration] found EJB3 Entity bean: org.jboss.seam.example.booking.Hotel
      14:29:22,142 INFO [Ejb3Configuration] found EJB3 Entity bean: org.jboss.seam.example.booking.User
      14:29:22,330 INFO [AnnotationBinder] Binding entity from annotated class: org.jboss.seam.example.booking.Booking
      14:29:22,508 INFO [EntityBinder] Bind entity org.jboss.seam.example.booking.Booking on table Booking
      14:29:24,376 INFO [AnnotationBinder] Binding entity from annotated class: org.jboss.seam.example.booking.Hotel
      14:29:24,377 INFO [EntityBinder] Bind entity org.jboss.seam.example.booking.Hotel on table Hotel
      14:29:24,441 INFO [AnnotationBinder] Binding entity from annotated class: org.jboss.seam.example.booking.User
      14:29:24,441 INFO [EntityBinder] Bind entity org.jboss.seam.example.booking.User on table User
      14:29:24,887 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
      14:29:24,948 INFO [InjectedDataSourceConnectionProvider] Using provided datasource
      14:29:25,590 INFO [SettingsFactory] RDBMS: MySQL, version: 4.1.12-Debian_1ubuntu3.1-log
      14:29:25,591 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
      14:29:25,702 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
      14:29:25,769 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
      14:29:25,790 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      14:29:25,812 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      14:29:25,812 INFO [SettingsFactory] Automatic flush during beforeCompletion(): enabled
      14:29:25,813 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
      14:29:25,813 INFO [SettingsFactory] JDBC batch size: 15
      14:29:25,813 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      14:29:25,820 INFO [SettingsFactory] Scrollable result sets: enabled
      14:29:25,820 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
      14:29:25,821 INFO [SettingsFactory] Connection release mode: after_statement
      14:29:25,838 INFO [SettingsFactory] Maximum outer join fetch depth: 2
      14:29:25,838 INFO [SettingsFactory] Default batch fetch size: 1
      14:29:25,838 INFO [SettingsFactory] Generate SQL with comments: disabled
      14:29:25,838 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      14:29:25,839 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      14:29:25,863 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      14:29:25,863 INFO [SettingsFactory] Query language substitutions: {}
      14:29:25,863 INFO [SettingsFactory] Second-level cache: enabled
      14:29:25,864 INFO [SettingsFactory] Query cache: disabled
      14:29:25,864 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
      14:29:25,873 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      14:29:25,874 INFO [SettingsFactory] Structured second-level cache entries: disabled
      14:29:25,915 INFO [SettingsFactory] Statistics: disabled
      14:29:25,915 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
      14:29:25,918 INFO [SettingsFactory] Default entity-mode: pojo
      14:29:26,134 INFO [SessionFactoryImpl] building session factory
      14:29:27,723 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      14:29:27,766 INFO [SchemaExport] Running hbm2ddl schema export
      14:29:27,766 INFO [SchemaExport] exporting generated schema to database
      14:29:29,050 INFO [SchemaExport] Executing import script: /import.sql
      14:29:29,139 ERROR [SchemaExport] schema export unsuccessful
      org.hibernate.JDBCException: Error during import script execution
       at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:255)
       at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:198)
       at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:135)
       at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:294)
       at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
       at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:414)
       at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:575)
       at org.hibernate.ejb.Ejb3Configuration.createContainerEntityManagerFactory(Ejb3Configuration.java:245)
       at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:108)
       at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:260)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWrapper.java:97)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
       at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:974)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:417)
       at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
       at $Proxy38.start(Unknown Source)
       at org.jboss.ejb3.JmxKernelAbstraction.install(JmxKernelAbstraction.java:76)
       at org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:599)
       at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:452)
       at org.jboss.ejb3.Ejb3Module.startService(Ejb3Module.java:139)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
       at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:974)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:417)
       at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
       at $Proxy25.start(Unknown Source)
       at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:365)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:997)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
       at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
       at $Proxy6.deploy(Unknown Source)
       at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:334)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:522)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:207)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:280)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:974)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:417)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
       at $Proxy4.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:755)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
       at $Proxy5.deploy(Unknown Source)
       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:477)
       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:357)
       at org.jboss.Main.boot(Main.java:200)
       at org.jboss.Main$1.run(Main.java:464)
       at java.lang.Thread.run(Thread.java:595)
      Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'state' at row 1
       at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)
       at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3410)
       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1804)
       at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
       at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
       at com.mysql.jdbc.Statement.execute(Statement.java:529)
       at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:82)
       at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:251)
       ... 135 more
      14:29:29,224 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
      14:29:29,610 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=jboss-seam-booking.ear,jar=jboss-seam-booking.jar,name=BookingListAction with dependencies:
      14:29:29,610 INFO [JmxKernelAbstraction] persistence.units:ear=jboss-seam-booking.ear.ear,jar=jboss-seam-booking.jar.jar,unitName=bookingDatabase
      14:29:30,476 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=jboss-seam-booking.ear,jar=jboss-seam-booking.jar,name=ChangePasswordAction with dependencies:
      14:29:30,477 INFO [JmxKernelAbstraction] persistence.units:ear=jboss-seam-booking.ear.ear,jar=jboss-seam-booking.jar.jar,unitName=bookingDatabase
      14:29:31,318 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=jboss-seam-booking.ear,jar=jboss-seam-booking.jar,name=HotelBookingAction with dependencies:
      14:29:31,318 INFO [JmxKernelAbstraction] persistence.units:ear=jboss-seam-booking.ear.ear,jar=jboss-seam-booking.jar.jar,unitName=bookingDatabase
      14:29:32,431 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=jboss-seam-booking.ear,jar=jboss-seam-booking.jar,name=LoginAction with dependencies:
      14:29:32,431 INFO [JmxKernelAbstraction] persistence.units:ear=jboss-seam-booking.ear.ear,jar=jboss-seam-booking.jar.jar,unitName=bookingDatabase
      14:29:32,609 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=jboss-seam-booking.ear,jar=jboss-seam-booking.jar,name=LogoutAction with dependencies:
      14:29:32,815 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=jboss-seam-booking.ear,jar=jboss-seam-booking.jar,name=RegisterAction with dependencies:
      14:29:32,815 INFO [JmxKernelAbstraction] persistence.units:ear=jboss-seam-booking.ear.ear,jar=jboss-seam-booking.jar.jar,unitName=bookingDatabase
      14:29:32,979 INFO [EJB3Deployer] Deployed: file:/usr/local/jboss/server/default/tmp/deploy/tmp55496jboss-seam-booking.ear-contents/jboss-seam-booking.jar
      14:29:33,035 INFO [TomcatDeployer] deploy, ctxPath=/seam-booking, warUrl=.../tmp/deploy/tmp55496jboss-seam-booking.ear-contents/jboss-seam-booking-exp.war/
      14:29:33,249 INFO [ServletContextListener] Welcome to Seam 1.0 beta 2
      14:29:33,322 INFO [Initialization] reading properties from: /seam.properties
      14:29:33,387 INFO [Initialization] initializing Seam
      14:29:34,152 INFO [Component] Component: org.jboss.seam.core.init, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.Init
      14:29:34,227 INFO [Component] Component: org.jboss.seam.core.pages, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.Pages
      14:29:34,259 INFO [Component] Component: org.jboss.seam.core.manager, scope: EVENT, type: JAVA_BEAN, class: org.jboss.seam.core.Manager
      14:29:34,330 INFO [Component] Component: switcher, scope: PAGE, type: JAVA_BEAN, class: org.jboss.seam.core.Switcher
      14:29:34,519 INFO [Component] Component: redirect, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.Redirect
      14:29:34,537 INFO [Component] Component: conversation, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.Conversation
      14:29:34,558 INFO [Component] Component: conversationList, scope: PAGE, type: JAVA_BEAN, class: org.jboss.seam.core.ConversationList
      14:29:34,585 INFO [Component] Component: conversationStack, scope: PAGE, type: JAVA_BEAN, class: org.jboss.seam.core.ConversationStack
      14:29:34,609 INFO [Component] Component: facesContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.FacesContext
      14:29:34,622 INFO [Component] Component: pageContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.PageContext
      14:29:34,635 INFO [Component] Component: eventContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.EventContext
      14:29:34,680 INFO [Component] Component: sessionContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.SessionContext
      14:29:34,693 INFO [Component] Component: statelessContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.StatelessContext
      14:29:34,712 INFO [Component] Component: applicationContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.ApplicationContext
      14:29:34,725 INFO [Component] Component: conversationContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.ConversationContext
      14:29:34,739 INFO [Component] Component: businessProcessContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.BusinessProcessContext
      14:29:34,859 INFO [Component] Component: locale, scope: STATELESS, type: JAVA_BEAN, class: org.jboss.seam.core.Locale
      14:29:34,874 INFO [Component] Component: messages, scope: SESSION, type: JAVA_BEAN, class: org.jboss.seam.core.Messages
      14:29:34,915 INFO [Component] Component: facesMessages, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.FacesMessages
      14:29:34,939 INFO [Component] Component: resourceBundle, scope: SESSION, type: JAVA_BEAN, class: org.jboss.seam.core.ResourceBundle
      14:29:34,956 INFO [Component] Component: localeSelector, scope: SESSION, type: JAVA_BEAN, class: org.jboss.seam.core.LocaleSelector
      14:29:34,975 INFO [Component] Component: uiComponent, scope: STATELESS, type: JAVA_BEAN, class: org.jboss.seam.core.UiComponent
      14:29:34,990 INFO [Component] Component: org.jboss.seam.debug.introspector, scope: EVENT, type: JAVA_BEAN, class: org.jboss.seam.debug.Introspector
      14:29:35,044 INFO [Component] Component: org.jboss.seam.debug.contexts, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.debug.Contexts
      14:29:35,090 INFO [Component] Component: org.jboss.seam.remoting.messaging.subscriptionRegistry, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.remoting.messaging.SubscriptionRegistry
      14:29:35,116 INFO [Scanner] scanning: /usr/local/jboss/server/default/tmp/deploy/tmp55496jboss-seam-booking.ear-contents/jboss-seam-booking.jar
      14:29:35,215 INFO [Component] Component: register, scope: EVENT, type: STATEFUL_SESSION_BEAN, class: org.jboss.seam.example.booking.RegisterAction, JNDI: jboss-seam-booking/RegisterAction/local
      14:29:35,241 INFO [Component] Component: logout, scope: STATELESS, type: STATELESS_SESSION_BEAN, class: org.jboss.seam.example.booking.LogoutAction, JNDI: jboss-seam-booking/LogoutAction/local
      14:29:35,412 INFO [Component] Component: login, scope: STATELESS, type: STATELESS_SESSION_BEAN, class: org.jboss.seam.example.booking.LoginAction, JNDI: jboss-seam-booking/LoginAction/local
      14:29:35,427 INFO [Component] Component: booking, scope: CONVERSATION, type: ENTITY_BEAN, class: org.jboss.seam.example.booking.Booking
      14:29:35,432 INFO [Component] Component: hotel, scope: CONVERSATION, type: ENTITY_BEAN, class: org.jboss.seam.example.booking.Hotel
      14:29:35,438 INFO [Component] Component: hotelBooking, scope: CONVERSATION, type: STATEFUL_SESSION_BEAN, class: org.jboss.seam.example.booking.HotelBookingAction, JNDI: jboss-seam-booking/HotelBookingAction/local
      14:29:35,475 INFO [Component] Component: changePassword, scope: EVENT, type: STATEFUL_SESSION_BEAN, class: org.jboss.seam.example.booking.ChangePasswordAction, JNDI: jboss-seam-booking/ChangePasswordAction/local
      14:29:35,521 INFO [Component] Component: bookingList, scope: SESSION, type: STATEFUL_SESSION_BEAN, class: org.jboss.seam.example.booking.BookingListAction, JNDI: jboss-seam-booking/BookingListAction/local
      14:29:35,544 INFO [Component] Component: user, scope: SESSION, type: ENTITY_BEAN, class: org.jboss.seam.example.booking.User
      14:29:35,597 INFO [Initialization] done initializing Seam
      14:29:35,853 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
      14:29:37,962 INFO [FacesConfigurator] Reading config jar:file:/usr/local/jboss/server/default/tmp/deploy/tmp55496jboss-seam-booking.ear-contents/jboss-seam.jar!/META-INF/faces-config.xml
      14:29:37,969 INFO [FacesConfigurator] Reading config jar:file:/usr/local/jboss/server/default/tmp/deploy/tmp55496jboss-seam-booking.ear-contents/jboss-seam-booking-exp.war/WEB-INF/lib/jsf-facelets.jar!/META-INF/faces-config.xml
      14:29:38,009 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
      14:29:38,286 ERROR [LocaleUtils] Locale name null or empty, ignoring
      14:29:39,258 INFO [StartupServletContextListener] ServletContext '/usr/local/jboss/server/default/./tmp/deploy/tmp55496jboss-seam-booking.ear-contents/jboss-seam-booking-exp.war/' initialized.
      14:29:39,895 INFO [EARDeployer] Started J2EE application: file:/usr/local/jboss/server/default/deploy/jboss-seam-booking.ear
      


      Now I can browse the booking example webpage without any errors but I can't login or create a new user even though the queries hibernate runs seem to be correct (they work if i subsitute the ? with real data).
      If I register a new user it writes an empty row into the User table, if I try to login with an existing user (demo:demo) it always says invalid login.

      I have tried everything I can think of but can't get it to work :(

      I'm using JBoss 4.0.4RC1, Seam CVS (also tried 1.0 beta2) and MySQL 4.1.12 on Linux.

        • 1. Re: Booking Example on MySQL?
          Gavin King Master

          Er, this error is because my test data has names of countries in it.

          EG:

          insert into Hotel (id, name, address, city, state, zip) values (14, 'InterContinental Tokyo Bay', 'Hamamatsucho', 'Tokyo', 'Japan', '')

          Just delete all those rows from import.sql.

          • 2. Re: Booking Example on MySQL?
            Da RINCE Newbie

            Thanks for your reply, but thats not my real problem, I know how to fix that error and it isn't really a problem (even with the error the application runs, it just doesn't import all the hotel entries).

            My problem as stated is that somehow the DB queries hibernates runs do not work (except those for table creation).
            I can't login because the query which checks the User table never returns any rows.
            If I try to register a new user via the seam-booking web app it just inserts an empty row in the User table, so something goes wrong there but I can't figure out what as hibernates seems to be running the correct queries (is there some way to make hibernate show complete queries with questionmarks replaced by actual data?).

            • 3. Re: Booking Example on MySQL?
              Da RINCE Newbie

              Nevermind I think I just found the solution, this is a bug in the Debian package of MySQL which makes it impossible to run server side prepared statements ...

              See also: http://forums.mysql.com/read.php?39,59076,59076