6 Replies Latest reply on Jul 18, 2006 3:50 PM by Marcelo Farinelli

    SEAM CRUD application has no impact to the DB

    Chongyan Ren Newbie

      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')

        • 1. Re: SEAM CRUD application has no impact to the DB
          Chongyan Ren Newbie

          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

          • 2. Re: SEAM CRUD application has no impact to the DB
            Chongyan Ren Newbie

            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

            • 3. Re: SEAM CRUD application has no impact to the DB
              Max Rydahl Andersen Master

              yes - the persistence.xml generation is not perfect.

              • 4. Re: SEAM CRUD application has no impact to the DB
                Chongyan Ren Newbie

                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

                • 5. Re: SEAM CRUD application has no impact to the DB
                  saravana kumar Newbie

                  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.

                  • 6. Re: SEAM CRUD application has no impact to the DB
                    Marcelo Farinelli Newbie

                    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.