SEAM CRUD application has no impact to the DB

[jason_rency]

all,

i followed the movie and created a very simple crud application using hibernate tools in jboss IDE. the following is what i got when start the server and run the application. I can use the update/creat/delet functions. all the data seems has been sucfully created or updated---- but when I check the database use DB managment tool, there is nothing change at all in the database. in another word, I can even run the application without running the DB.

any ideas??



21:16:51,329 INFO [Server] Starting JBoss (MX MicroKernel)...
21:16:51,329 INFO [Server] Release ID: JBoss [Zion] 4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)
21:16:51,339 INFO [Server] Home Dir: C:\jboss-4.0.4
21:16:51,339 INFO [Server] Home URL: file:/C:/jboss-4.0.4/
21:16:51,339 INFO [Server] Patch URL: null
21:16:51,339 INFO [Server] Server Name: default
21:16:51,339 INFO [Server] Server Home Dir: C:\jboss-4.0.4\server\default
21:16:51,339 INFO [Server] Server Home URL: file:/C:/jboss-4.0.4/server/default/
21:16:51,359 INFO [Server] Server Log Dir: C:\jboss-4.0.4\server\default\log
21:16:51,359 INFO [Server] Server Temp Dir: C:\jboss-4.0.4\server\default\tmp
21:16:51,359 INFO [Server] Root Deployment Filename: jboss-service.xml
21:16:52,992 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems Inc.
21:16:52,992 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_06-b05,Sun Microsystems Inc.
21:16:52,992 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
21:16:53,883 INFO [Server] Core system initialized
21:16:55,445 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
21:16:57,158 INFO [SocketServerInvoker] Invoker started for locator: InvokerLocator [socket://127.0.0.1:3873/]
21:16:57,839 INFO [AspectDeployer] Deployed AOP: file:/C:/jboss-4.0.4/server/default/deploy/ejb3-interceptors-aop.xml
21:16:59,841 INFO [WebService] Using RMI server codebase: http://localhost:8083/
21:17:03,677 INFO [MailService] Mail Service bound to java:/Mail
21:17:03,917 INFO [NamingService] JNDI bootstrap JNP=localhost/127.0.0.1:1099, RMI=localhost/127.0.0.1:1098, backlog=50, no client SocketFactory, Server SocketFactory=class org.jboss.net.sockets.DefaultSocketFactory
21:17:03,967 INFO [SubscriptionManager] Bound event dispatcher to java:/EventDispatcher
21:17:04,879 INFO [Embedded] Catalina naming disabled
21:17:05,079 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
21:17:05,079 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
21:17:05,550 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-localhost%2F127.0.0.1-8080
21:17:05,560 INFO [Catalina] Initialization processed in 481 ms
21:17:05,560 INFO [StandardService] Starting service jboss.web
21:17:05,570 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.17
21:17:05,640 INFO [StandardHost] XML validation disabled
21:17:05,670 INFO [Catalina] Server startup in 110 ms
21:17:05,900 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
21:17:06,531 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
21:17:07,292 INFO [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../tmp/deploy/tmp22561jbossws-exp.war/
21:17:08,153 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
21:17:08,344 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
21:17:08,424 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/quartz-ra.rar
21:17:08,434 INFO [QuartzResourceAdapter] start quartz!!!
21:17:08,524 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
21:17:08,554 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
21:17:08,564 INFO [RAMJobStore] RAMJobStore initialized.
21:17:09,505 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
21:17:09,505 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
21:17:09,505 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
21:17:10,437 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' 21:17:10,757 INFO [A] Bound to JNDI name: queue/A
21:17:10,767 INFO [B] Bound to JNDI name: queue/B
21:17:10,767 INFO [C] Bound to JNDI name: queue/C
21:17:10,767 INFO [D] Bound to JNDI name: queue/D
21:17:10,767 INFO [ex] Bound to JNDI name: queue/ex
21:17:10,797 INFO [testTopic] Bound to JNDI name: topic/testTopic
21:17:10,797 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
21:17:10,797 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
21:17:10,797 INFO [testQueue] Bound to JNDI name: queue/testQueue
21:17:10,827 INFO [UILServerILService] JBossMQ UIL service available at : localhost/127.0.0.1:8093
21:17:10,917 INFO [DLQ] Bound to JNDI name: queue/DLQ
21:17:11,078 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
21:17:11,118 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
21:17:11,368 INFO [EARDeployer] Init J2EE application: file:/C:/jboss-4.0.4/server/default/deploy/seamapp.ear
21:17:12,960 INFO [Ejb3Deployment] EJB3 deployment time took: 891
21:17:12,990 INFO [JmxKernelAbstraction] installing MBean: persistence.units:ear=seamapp.ear,jar=seamapp.ejb3.jar,unitName=entityManager with dependencies:
21:17:12,990 INFO [JmxKernelAbstraction] jboss.jca:name=DefaultDS,service=ManagedConnectionFactory
21:17:13,060 INFO [Version] Hibernate EntityManager 3.2.0.CR1
21:17:13,131 INFO [Version] Hibernate Annotations 3.2.0.CR1
21:17:13,141 INFO [Environment] Hibernate 3.2 cr2
21:17:13,151 INFO [Environment] hibernate.properties not found

(why need hibernate.properties here? I have the hibernate.cfg.xml)

21:17:13,181 INFO [Environment] Bytecode provider name : javassist
21:17:13,191 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
21:17:13,511 INFO [Ejb3Configuration] found EJB3 Entity bean: src.AuthUser
21:17:13,521 WARN [Ejb3Configuration] Persistence provider caller does not implements the EJB3 spec correctly.
PersistenceUnitInfo.getNewTempClassLoader() is null.
21:17:13,531 WARN [Ejb3Configuration] Defining hibernate.transaction.flush_before_completion=true ignored in HEM

(any problem here??)


21:17:13,661 INFO [Configuration] Reading mappings from resource: META-INF/orm.xml
21:17:13,681 INFO [Ejb3Configuration] [PersistenceUnit: entityManager] no META-INF/orm.xml found

21:17:13,822 INFO [AnnotationBinder] Binding entity from annotated class: src.AuthUser
21:17:13,952 INFO [EntityBinder] Bind entity src.AuthUser on table AUTH_USER
21:17:14,232 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider


21:17:14,232 INFO [InjectedDataSourceConnectionProvider] Using provided datasource
21:17:14,252 INFO [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0
21:17:14,252 INFO [SettingsFactory] JDBC driver: HSQL Database Engine Driver, version: 1.8.0
21:17:14,292 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect
21:17:14,292 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
21:17:14,302 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
21:17:14,312 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
21:17:14,312 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled 21:17:14,312 INFO [SettingsFactory] Automatic session close at end of transaction: disabled


21:17:14,312 INFO [SettingsFactory] JDBC batch size: 15
21:17:14,312 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
21:17:14,312 INFO [SettingsFactory] Scrollable result sets: enabled
21:17:14,312 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
21:17:14,312 INFO [SettingsFactory] Connection release mode: auto
21:17:14,312 INFO [SettingsFactory] Default batch fetch size: 1
21:17:14,312 INFO [SettingsFactory] Generate SQL with comments: disabled
21:17:14,312 INFO [SettingsFactory] Order SQL updates by primary key: disabled
21:17:14,312 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
21:17:14,342 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
21:17:14,342 INFO [SettingsFactory] Query language substitutions: {}
21:17:14,342 INFO [SettingsFactory] Second-level cache: enabled
21:17:14,342 INFO [SettingsFactory] Query cache: disabled
21:17:14,342 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
21:17:14,342 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
21:17:14,342 INFO [SettingsFactory] Structured second-level cache entries: disabled
21:17:14,342 INFO [SettingsFactory] Echoing all SQL to stdout
21:17:14,342 INFO [SettingsFactory] Statistics: disabled
21:17:14,342 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
21:17:14,342 INFO [SettingsFactory] Default entity-mode: pojo
21:17:14,402 INFO [SessionFactoryImpl] building session factory
21:17:15,394 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
21:17:15,404 INFO [SchemaExport] Running hbm2ddl schema export
21:17:15,404 INFO [SchemaExport] exporting generated schema to database
21:17:15,484 INFO [SchemaExport] schema export complete
21:17:15,484 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
21:17:16,445 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=seamapp.ear,jar=seamapp.ejb3,name=AuthUserEditorBean,service=EJB3 with dependencies:
21:17:16,766 INFO [EJBContainer] STARTED EJB: src.AuthUserEditorBean ejbName: AuthUserEditorBean
21:17:16,806 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=seamapp.ear,jar=seamapp.ejb3,name=AuthUserFinderBean,service=EJB3 with dependencies:
21:17:16,846 INFO [EJBContainer] STARTED EJB: src.AuthUserFinderBean ejbName: AuthUserFinderBean
21:17:16,926 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=seamapp.ear,jar=seamapp.ejb3,name=DefaultAuthUserSelector,service=EJB3 with dependencies:
21:17:17,006 INFO [EJBContainer] STARTED EJB: src.AuthUserSelector$DefaultAuthUserSelector ejbName: DefaultAuthUserSelector
21:17:17,026 INFO [EJB3Deployer] Deployed: file:/C:/jboss-4.0.4/server/default/tmp/deploy/tmp22587seamapp.ear-contents/seamapp.ejb3
21:17:17,036 INFO [TomcatDeployer] deploy, ctxPath=/seamapp, warUrl=.../tmp/deploy/tmp22587seamapp.ear-contents/seamapp-exp.war/
21:17:17,206 INFO [ServletContextListener] Welcome to Seam 1.0.1.GA
21:17:17,226 INFO [Initialization] reading components.xml
21:17:17,256 INFO [Initialization] reading properties from: /seam.properties
21:17:17,256 INFO [Initialization] reading properties from: /jndi.properties
21:17:17,276 INFO [Initialization] initializing Seam
21:17:17,347 INFO [Component] Component: org.jboss.seam.core.init, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.Init
21:17:17,617 INFO [Component] Component: org.jboss.seam.core.pages, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.Pages
21:17:17,627 INFO [Component] Component: events, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.Events
21:17:17,637 INFO [Component] Component: org.jboss.seam.core.manager, scope: EVENT, type: JAVA_BEAN, class: org.jboss.seam.core.Manager
21:17:17,697 INFO [Component] Component: switcher, scope: PAGE, type: JAVA_BEAN, class: org.jboss.seam.core.Switcher
21:17:17,707 INFO [Component] Component: redirect, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.Redirect
21:17:17,707 INFO [Component] Component: httpError, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.HttpError
21:17:17,767 INFO [Component] Component: userPrincipal, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.UserPrincipal
21:17:17,777 INFO [Component] Component: isUserInRole, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.IsUserInRole
21:17:17,787 INFO [Component] Component: conversation, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.Conversation
21:17:17,797 INFO [Component] Component: conversationList, scope: PAGE, type: JAVA_BEAN, class: org.jboss.seam.core.ConversationList
21:17:17,827 INFO [Component] Component: conversationStack, scope: PAGE, type: JAVA_BEAN, class: org.jboss.seam.core.ConversationStack
21:17:17,837 INFO [Component] Component: facesContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.FacesContext
21:17:17,847 INFO [Component] Component: pageContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.PageContext
21:17:17,887 INFO [Component] Component: eventContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.EventContext
21:17:17,897 INFO [Component] Component: sessionContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.SessionContext
21:17:17,977 INFO [Component] Component: statelessContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.StatelessContext
21:17:17,987 INFO [Component] Component: applicationContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.ApplicationContext
21:17:17,998 INFO [Component] Component: conversationContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.ConversationContext
21:17:17,998 INFO [Component] Component: businessProcessContext, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.BusinessProcessContext
21:17:18,038 INFO [Component] Component: locale, scope: STATELESS, type: JAVA_BEAN, class: org.jboss.seam.core.Locale
21:17:18,048 INFO [Component] Component: messages, scope: SESSION, type: JAVA_BEAN, class: org.jboss.seam.core.Messages
21:17:18,048 INFO [Component] Component: interpolator, scope: STATELESS, type: JAVA_BEAN, class: org.jboss.seam.core.Interpolator
21:17:18,058 INFO [Component] Component: facesMessages, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.FacesMessages
21:17:18,078 INFO [Component] Component: resourceBundle, scope: SESSION, type: JAVA_BEAN, class: org.jboss.seam.core.ResourceBundle
21:17:18,168 INFO [Component] Component: localeSelector, scope: SESSION, type: JAVA_BEAN, class: org.jboss.seam.core.LocaleSelector
21:17:18,178 INFO [Component] Component: uiComponent, scope: STATELESS, type: JAVA_BEAN, class: org.jboss.seam.core.UiComponent
21:17:18,178 INFO [Component] Component: org.jboss.seam.remoting.messaging.subscriptionRegistry, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.remoting.messaging.SubscriptionRegistry
21:17:18,188 INFO [Component] Component: pojoCache, scope: APPLICATION, type: JAVA_BEAN, class: org.jboss.seam.core.PojoCache
21:17:18,188 INFO [Component] Component: entityManager, scope: CONVERSATION, type: JAVA_BEAN, class: org.jboss.seam.core.ManagedPersistenceContext
21:17:18,208 INFO [Scanner] scanning: /C:/jboss-4.0.4/server/default/tmp/deploy/tmp22587seamapp.ear-contents/seamapp.ejb3
21:17:18,218 INFO [Component] Component: authuserSelector, scope: STATELESS, type: STATELESS_SESSION_BEAN, class: src.AuthUserSelector$DefaultAuthUserSelector, JNDI: seamapp/DefaultAuthUserSelector/local
21:17:18,258 INFO [Component] Component: authuserFinder, scope: SESSION, type: STATEFUL_SESSION_BEAN, class: src.AuthUserFinderBean, JNDI: seamapp/AuthUserFinderBean/local
21:17:18,268 INFO [Component] Component: authuserEditor, scope: CONVERSATION, type: STATEFUL_SESSION_BEAN, class: src.AuthUserEditorBean, JNDI: seamapp/AuthUserEditorBean/local
21:17:18,278 INFO [Initialization] done initializing Seam
21:17:18,468 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
21:17:18,568 INFO [FacesConfigurator] Reading config jar:file:/C:/jboss-4.0.4/server/default/tmp/deploy/tmp22587seamapp.ear-contents/seamapp.ejb3-contents/jboss-seam.jar!/META-INF/faces-config.xml
21:17:18,578 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml

21:17:18,719 ERROR [LocaleUtils] Locale name null or empty, ignoring


21:17:19,580 INFO [StartupServletContextListener] ServletContext 'C:\jboss-4.0.4\server\default\.\tmp\deploy\tmp22587seamapp.ear-contents\seamapp-exp.war\' initialized.
21:17:19,620 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-4.0.4/server/default/deploy/seamapp.ear
21:17:19,670 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-localhost%2F127.0.0.1-8080
21:17:20,531 INFO [ChannelSocket] JK: ajp13 listening on localhost/127.0.0.1:8009
21:17:20,551 INFO [JkMain] Jk running ID=0 time=0/40 config=null
21:17:20,561 INFO [Server] JBoss (MX MicroKernel) [4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)] Started in 29s:192ms


23:10:27,560 INFO [Pages] no pages.xml file found
23:10:31,136 INFO [MyfacesConfig] No context init parameter 'org.apache.myfaces.PRETTY_HTML' found, using default value true
23:10:31,136 INFO [MyfacesConfig] No context init parameter 'org.apache.myfaces.ALLOW_JAVASCRIPT' found, using default value true
23:10:31,136 INFO [MyfacesConfig] No context init parameter 'org.apache.myfaces.DETECT_JAVASCRIPT' found, using default value false
23:10:31,136 INFO [MyfacesConfig] No context init parameter 'org.apache.myfaces.AUTO_SCROLL' found, using default value false
23:10:31,156 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id12')
23:10:31,176 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id14')
23:10:47,729 INFO [STDOUT] Hibernate: select authuser0_.USER_ID as USER1_0_0_, authuser0_.PASS_WORD as PASS2_0_0_ from PUBLIC.AUTH_USER authuser0_ where authuser0_.USER_ID=?
23:10:47,820 INFO [STDOUT] Hibernate: insert into PUBLIC.AUTH_USER (PASS_WORD, USER_ID) values (?, ?)
23:10:47,850 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id12')
23:10:47,860 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id14')
23:13:42,491 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id9')
23:13:42,501 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id10')
23:13:42,511 WARN [HtmlLabelRenderer] Unable to find component 'pageSize' (calling findComponent on component '_id2:_id11')
23:13:47,909 INFO [STDOUT] Hibernate: select top ? authuser0_.USER_ID as USER1_0_, authuser0_.PASS_WORD as PASS2_0_ from PUBLIC.AUTH_USER authuser0_
23:14:06,435 INFO [STDOUT] Hibernate: select authuser0_.USER_ID as USER1_0_0_, authuser0_.PASS_WORD as PASS2_0_0_ from PUBLIC.AUTH_USER authuser0_ where authuser0_.USER_ID=?
23:14:06,485 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id12')
23:14:06,495 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id14')
23:14:15,438 INFO [STDOUT] Hibernate: update PUBLIC.AUTH_USER set PASS_WORD=? where USER_ID=?
23:14:15,448 INFO [STDOUT] Hibernate: select top ? authuser0_.USER_ID as USER1_0_, authuser0_.PASS_WORD as PASS2_0_ from PUBLIC.AUTH_USER authuser0_
23:14:20,756 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id9')
23:14:20,756 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id10')
23:14:20,756 WARN [HtmlLabelRenderer] Unable to find component 'pageSize' (calling findComponent on component '_id2:_id11')
23:14:22,979 INFO [STDOUT] Hibernate: select top ? authuser0_.USER_ID as USER1_0_, authuser0_.PASS_WORD as PASS2_0_ from PUBLIC.AUTH_USER authuser0_
23:14:25,493 INFO [STDOUT] Hibernate: select top ? authuser0_.USER_ID as USER1_0_, authuser0_.PASS_WORD as PASS2_0_ from PUBLIC.AUTH_USER authuser0_
23:14:27,535 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id12')
23:14:27,546 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id14')
23:14:36,108 INFO [STDOUT] Hibernate: select authuser0_.USER_ID as USER1_0_0_, authuser0_.PASS_WORD as PASS2_0_0_ from PUBLIC.AUTH_USER authuser0_ where authuser0_.USER_ID=?
23:14:36,108 INFO [STDOUT] Hibernate: insert into PUBLIC.AUTH_USER (PASS_WORD, USER_ID) values (?, ?)
23:14:36,108 INFO [STDOUT] Hibernate: select top ? authuser0_.USER_ID as USER1_0_, authuser0_.PASS_WORD as PASS2_0_ from PUBLIC.AUTH_USER authuser0_
23:14:36,138 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id12')
23:14:36,138 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id14')
23:14:47,334 INFO [STDOUT] Hibernate: select top ? authuser0_.USER_ID as USER1_0_, authuser0_.PASS_WORD as PASS2_0_ from PUBLIC.AUTH_USER authuser0_
23:14:50,869 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id12')
23:14:50,879 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id14')
23:14:56,457 WARN [HtmlLabelRenderer] Unable to find component 'userId' (calling findComponent on component '_id2:_id9')
23:14:56,467 WARN [HtmlLabelRenderer] Unable to find component 'passWord' (calling findComponent on component '_id2:_id10')
23:14:56,467 WARN [HtmlLabelRenderer] Unable to find component 'pageSize' (calling findComponent on component '_id2:_id11')

[jason_rency]

any ideas?

by the way, in the persistence.xml

jta-data-source>java:/DefaultDS</jta-data-source>

but I am not using the bundled HSQL db with jboss, I am using the server mode of a seperate hsql installation. so I am just wondering if the configuration here in the persistence.xml is correct.

regards
Jason

[jason_rency]

just found the problem.

the seam app uses the stand along mode of the bundled hsql db rather than the one I configured in hibernate.cfg.xml.

it seems seam app read the peristence.xml for the url of the hibernate.cfg.xml.

I am just curious:

why the persistence.xml automatically configure the data source to its bundled hsqlDB while I am using another hsqldb installation?
(is this a bug of the JBOSS IDE)

what's the difference of functions between hibernate.cfg.xml and persistence.xml in the seam application?

how and where can I define the JNDI name of the data source which required by the persistence.xml?

I do appreciate any suggestion and hint.

regards

Jason

[maxandersen]

yes - the persistence.xml generation is not perfect.

[jason_rency]

problem solved!

I edited the hsqldb-ds.xml in $JBOSS-SERVER\server\default\deploy, defined the JDNI name of my DB and point it to the right url and then the application could work properly.

thanks very much!

Jason

[saravanakumar]

Hai rency,
I got the same error what you have posted but i don't use ejb-jar.xml and persistance.xml and also i use mysql database.
My seam.properties file is empty.
I have the following configuration in the hibernate.cfg.xml file.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
 <session-factory>
 <property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
 <property name="hibernate.connection.password">root</property>
 <property name="hibernate.connection.url">jdbc:mysql://192.168.1.85/lgms</property>
 <property name="hibernate.connection.username">root</property>
 <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
 </session-factory>
</hibernate-configuration>

I get the following error when i try to search a record, i get the following error

19:55:36,531 INFO [STDOUT] Hibernate: select top ? divisionde0_.division_id as division1_0_, divisionde0_.division_name as division2_0_ from lgms.division_details divisionde0_
19:55:36,609 WARN [JDBCExceptionReporter] SQL Error: -227, SQLState: 3F000
19:55:36,609 ERROR [JDBCExceptionReporter] invalid schema name: LGMS in statement [select top ? divisionde0_.division_id as division1_0_, divisionde0_.division_name as division2_0_
 from lgms.division_details divisionde0_]
19:55:36,703 ERROR [SeamExceptionFilter] uncaught exception handled by Seam
javax.servlet.ServletException: Error calling action method of component with id _id2:_id13
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:121)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)
19:55:36,781 INFO [SeamExceptionFilter] killing transaction
19:55:36,781 ERROR [[Faces Servlet]] Servlet.service() for servlet Faces Servlet threw exception
javax.faces.FacesException: Error calling action method of component with id _id2:_id13
 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74)
 at javax.faces.component.UICommand.broadcast(UICommand.java:106)
 at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
 at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
 at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
 at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)
Caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{divisiondetailsFinder.findFirstPage}
 at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153)
 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
 ... 27 more
Caused by: javax.ejb.EJBTransactionRolledbackException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
 at org.jboss.ejb3.tx.Ejb3TxPolicy.handleInCallerTx(Ejb3TxPolicy.java:93)
 at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:130)
 at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:201)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:81)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:188)
 at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:98)
 at $Proxy100.findFirstPage(Unknown Source)
 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.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
 ... 28 more
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
 at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:567)
 at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:56)
 at DivisionDetailsFinderBean.executeQuery(DivisionDetailsFinderBean.java:99)
 at DivisionDetailsFinderBean.findFirstPage(DivisionDetailsFinderBean.java:105)
 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.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
 at org.jboss.seam.interceptors.ValidationInterceptor.validateTargetComponent(ValidationInterceptor.java:64)
 at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.OutcomeInterceptor.interceptOutcome(OutcomeInterceptor.java:21)
 at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.RollbackInterceptor.rollbackIfNecessary(RollbackInterceptor.java:30)
 at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.BijectionInterceptor.bijectTargetComponent(BijectionInterceptor.java:33)
 at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.ConversationInterceptor.endOrBeginLongRunningConversation(ConversationInterceptor.java:82)
 at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.BusinessProcessInterceptor.manageBusinessProcessContext(BusinessProcessInterceptor.java:60)
 at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.RemoveInterceptor.removeIfNecessary(RemoveInterceptor.java:39)
 at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:90)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.ejb.SeamInterceptor.aroundInvokeInContexts(SeamInterceptor.java:73)
 at org.jboss.seam.ejb.SeamInterceptor.aroundInvoke(SeamInterceptor.java:45)
 at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
 at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:57)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
 ... 48 more
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
 at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.Loader.doList(Loader.java:2148)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
 at org.hibernate.loader.Loader.list(Loader.java:2024)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
 at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
 at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
 at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
 at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:53)
 ... 121 more
Caused by: java.sql.SQLException: invalid schema name: LGMS in statement [select top ? divisionde0_.division_id as division1_0_, divisionde0_.division_name as division2_0_ from lgm
s.division_details divisionde0_]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349)
 at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:337)
 at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
 at org.hibernate.loader.Loader.doQuery(Loader.java:661)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
 at org.hibernate.loader.Loader.doList(Loader.java:2145)
 ... 129 more

Please help me in solving this issue.

[markfoerstein]

savana, you should be using persistence.xml to reference your jta data source and tell what sql dialect to use, then have a myssql-ds.xml file for the datasource, into your deploy folder.

hibernate.cfg.xml is only used to generate de CRUD app, not to run it.

Im not sure but I think you're confused on how hibernate gets connected to the database when running the app.

Cheers.