[jboss-user] [JBoss Seam] - SQL Error

[x-avila]

Hi: 

I'm trying to make work the reverse eng. CRUD app. that apperas in JBOSS -SEAM tutorials. 

I'm using a postgres database. When I deploy the app, all semms to be fine, I can create records in the data base, but when I try to find records, I get the error: 

09:01:43,049 INFO  [STDOUT] Hibernate: select top ? ciudad0_.idciudad as idciudad20_, ciudad0_.nombre as nombre20_ from public.ciudad ciudad0_ where ciudad0_.idciudad=? and (ciudad0_.nombre like ?)
  | 09:01:43,056 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 42601
  | 09:01:43,061 ERROR [JDBCExceptionReporter] ERROR: error de sintaxis en o cerca de «$1»
  | 09:01:43,063 ERROR [SeamExceptionFilter] uncaught exception handled by Seam
  | javax.servlet.ServletException: Error calling action method of component with id _id2:_id15
  |         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)
  | 

What should I do?

Thanks in advance

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958812#3958812

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958812