[JDBCExceptionReporter] Table not found in statement ???

[abchilla]

Dear group,

i am facing a big problem. i am new to using jboss at all and what i am trying to do is using jboss seam with hibernate and a postgres database.

i am refering to the tutorial "Seam Database Reverse Engineering Flash Demo" i followed the steps and was about deploying the application to the jboss server. everything works fine.

as i want to add a city from the web it says that the transaction failed. i get following code. i am looking since hours for a explanation for this error, but i can not understand it at all.

Please help me.

Before i forget i am using jboss-4.0.5.GA with ejb3, just as said in the getting started tasks, hibernate 3.2 , Seam 1.1.0.BETA and Postgresql 8.1, eclipse 3.2

Of course the tables do exist in postgres. i also cann add the tables i want to use with hibernate.

I need to use a postgres database, due to an application i wanted to work on after i get this test application running.

12:43:20,871 INFO [ExceptionInterceptor] no exceptions.xml file found
12:43:31,557 INFO [RendererUtils] Unable to find component 'id' (calling findComponent on component '_idJsp2:_idJsp14'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
12:43:31,567 INFO [RendererUtils] Unable to find component 'name' (calling findComponent on component '_idJsp2:_idJsp16'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
12:43:31,567 INFO [RendererUtils] Unable to find component 'zipcode' (calling findComponent on component '_idJsp2:_idJsp18'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
12:43:31,577 INFO [RendererUtils] Unable to find component 'country' (calling findComponent on component '_idJsp2:_idJsp20'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
12:43:47,882 INFO [STDOUT] Hibernate: select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from public.city city0_ where city0_.id=?
12:43:47,882 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
12:43:47,882 ERROR [JDBCExceptionReporter] Table not found in statement [select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from public.city city0_ where city0_.id=?]
12:43:47,882 INFO [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity: [src.example.planner.City#0]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.Loader.loadEntity(Loader.java:1798)
 at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
 at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
 at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2977)
 at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:393)
 at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374)
 at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
 at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:193)
 at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101)
 at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
 at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
 at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
 at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:174)
 at src.example.planner.CityEditorBean.create(CityEditorBean.java:70)
 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.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
 at org.jboss.seam.interceptors.ValidationInterceptor.validateTargetComponent(ValidationInterceptor.java:46)
 at sun.reflect.GeneratedMethodAccessor92.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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.BijectionInterceptor.bijectTargetComponent(BijectionInterceptor.java:51)
 at sun.reflect.GeneratedMethodAccessor90.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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.ManagedEntityIdentityInterceptor.aroundInvoke(ManagedEntityIdentityInterceptor.java:77)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.OutcomeInterceptor.interceptOutcome(OutcomeInterceptor.java:23)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.RollbackInterceptor.rollbackIfNecessary(RollbackInterceptor.java:32)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.ConversationInterceptor.endOrBeginLongRunningConversation(ConversationInterceptor.java:60)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.BusinessProcessInterceptor.manageBusinessProcessContext(BusinessProcessInterceptor.java:50)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.ConversationalInterceptor.checkConversationForConversationalBean(ConversationalInterceptor.java:81)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.EventInterceptor.aroundInvoke(EventInterceptor.java:51)
 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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.RemoveInterceptor.removeIfNecessary(RemoveInterceptor.java:40)
 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.seam.util.Reflections.invoke(Reflections.java:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.intercept.RootInterceptor.invokeInContexts(RootInterceptor.java:168)
 at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:141)
 at org.jboss.seam.intercept.RootInterceptor.aroundInvoke(RootInterceptor.java:128)
 at sun.reflect.GeneratedMethodAccessor81.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)
 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:83)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
 at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
 at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:131)
 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:203)
 at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:98)
 at $Proxy96.create(Unknown Source)
 at src.example.planner.CityEditor$$FastClassByCGLIB$$26f425c2.invoke(<generated>)
 at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
 at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:47)
 at org.jboss.seam.intercept.ClientSideInterceptor$1.proceed(ClientSideInterceptor.java:67)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:57)
 at org.jboss.seam.interceptors.ExceptionInterceptor.handleExceptions(ExceptionInterceptor.java:28)
 at sun.reflect.GeneratedMethodAccessor80.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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.interceptors.AsynchronousInterceptor.invokeAsynchronouslyIfNecessary(AsynchronousInterceptor.java:29)
 at sun.reflect.GeneratedMethodAccessor79.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:17)
 at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:172)
 at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:66)
 at org.jboss.seam.intercept.RootInterceptor.invokeInContexts(RootInterceptor.java:168)
 at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:141)
 at org.jboss.seam.intercept.RootInterceptor.aroundInvoke(RootInterceptor.java:128)
 at org.jboss.seam.intercept.ClientSideInterceptor.interceptInvocation(ClientSideInterceptor.java:60)
 at org.jboss.seam.intercept.ClientSideInterceptor.intercept(ClientSideInterceptor.java:47)
 at org.jboss.seam.intercept.Proxy$$EnhancerByCGLIB$$dc2ed86b.create(<generated>)
 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)
 at org.jboss.seam.actionparam.ActionParamBindingHelper.invokeTheExpression(ActionParamBindingHelper.java:58)
 at org.jboss.seam.actionparam.ActionParamMethodBinding.invoke(ActionParamMethodBinding.java:71)
 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
 at javax.faces.component.UICommand.broadcast(UICommand.java:106)
 at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:94)
 at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:168)
 at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343)
 at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137)
 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.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
 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: java.sql.SQLException: Table not found in statement [select city0_.id as id0_0_, city0_.name as name0_0_, city0_.country as country0_0_, city0_.zipcode as zipcode0_0_ from public.city city0_ where city0_.id=?]
 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:344)
 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:1560)
 at org.hibernate.loader.Loader.doQuery(Loader.java:661)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
 at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
 ... 183 more

[pmuir]

Post your persistence.xml

[abchilla]

Hi,

sorry, where do i find the persistence.xml ?

[pmuir]

I'm assuming you are using EJB3 + seam rather than Hibernate + Seam?

In the created ear it should be in the ejb3 jar's META-INF. It's up to you where you put it in your project source!

[abchilla]

Hi,

sorry this was a misunderstanding.

I am using Hibernate + Seam, but i needed to copy jboss-seam.jar, jboss-ejb3x.jar, ejb3-persistence.jar, myfaces-api.jar, jboss-annotations-ejb3.jar, hibernate-annotations.jar to the lib/ and build the application, as shown in the tutorial.

sorry for this wrong information.

[abchilla]

The Appserver is installed with ejb3 profile

[abchilla]

Hi,

i have found the persistence.xml generated by doing the code generation and selecting the seam skelet.

<entity-manager>
<persistence-unit name="entityManager">
org.hibernate.ejb.HibernatePersistence
<jta-data-source>java:/DefaultDS</jta-data-source>








</persistence-unit>
</entity-manager>

do i need to do change something in here?

[abchilla]

hi group,

maybe this can be also of help for you guys.

after starting my crud application i get following information, that some xml files can not be found.

14:26:35,904 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)] Started in 21s:102ms
14:28:56,876 INFO [Events] no events.xml file found
14:28:56,936 INFO [Pages] no pages.xml file found
14:29:00,291 INFO [MyfacesConfig] No context init parameter 'org.apache.myfaces.PRETTY_HTML' found, using default value true
14:29:00,291 INFO [MyfacesConfig] No context init parameter 'org.apache.myfaces.ALLOW_JAVASCRIPT' found, using default value true
14:29:00,291 INFO [MyfacesConfig] Tomahawk jar not available. Autoscrolling, DetectJavascript, AddResourceClass and CheckExtensionsFilter are disabled now.
14:29:00,311 INFO [RendererUtils] Unable to find component 'id' (calling findComponent on component '_idJsp2:_idJsp14'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
14:29:00,331 INFO [RendererUtils] Unable to find component 'name' (calling findComponent on component '_idJsp2:_idJsp16'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
14:29:00,341 INFO [RendererUtils] Unable to find component 'zipcode' (calling findComponent on component '_idJsp2:_idJsp18'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
14:29:00,341 INFO [RendererUtils] Unable to find component 'country' (calling findComponent on component '_idJsp2:_idJsp20'). We'll try to return a guessed client-id anyways - this will be a problem if you put the referenced component into a different naming-container. If this is the case, you can always use the full client-id.
14:29:00,452 INFO [ExceptionInterceptor] no exceptions.xml file found

so when i now try to insert a city or something else it goes wrong and i get the error, showed above.

thanks in advance

asad

[pmuir]

Please use the [ code ] tags when posting persistence.xml.

[abchilla]

sorry.... so here we go.

<entity-manager>
 <persistence-unit name="entityManager">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/DefaultDS</jta-data-source>
 <properties>
 <property name="hibernate.dialect" value=" org.hibernate.dialect.HSQLDialect" />
 <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
 <property name="hibernate.transaction.flush_before_completion" value="true" />
 <property name="hibernate.hbm2ddl.auto" value="create-drop" />
 <property name="hibernate.show_sql" value="true" />
 <property name="jboss.entity.manager.factory.jndi.name" value="java:/seamappEntityManagerFactory" />
 </properties>
 </persistence-unit>
</entity-manager>

[pmuir]

Ah. You are using the HSQL dialect - this isn't right for postgres. Hibernate docs should tell you the wrote one to use somewhere.

[abchilla]

i have also tried to use the PostgreSQLDialect, but the error remains.

[gavin.king]

The Hibernate Tools templates are not uptodate with Seam 1.1.

Seam 1.1.BETA.2 (later this week) will package a set of templates in the distribution, so I advise waiting for that.

[abchilla]

oh i see,

i was really frustrated all the day over because of this was happening. Thank you for your reply. So i guess i will need to wait a little bit. I already was trying to figure out working with Spring. Can someone point me to a place where i can really figure out about those frameworks and which framework to choose.

thanx in advance.

asad

[gavin.king]

Please wait a couple of days and try again with BETA2, James and I really have put a lot of work into seam-gen and I promise that the experience will be MUCH smoother.