Booking Example on MySQL?
supakiffa Mar 30, 2006 8:15 AMI'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.