Re: [Concern-users] new demo process

[Holger E. <he...@me...>]

Quoting Lisa Retief <lis...@sa...>:

> Hi Holger,
> 
> I am still having deployment problems. Do you have any idea what causes 
> this exception:
> 
> javax.ejb.FinderException: Find failed: java.sql.SQLException: ERROR:  
> parser: parse error at or near "." at character [some number]

You're using postgres, right? some beans are configured to use row locking.
jboss generates code like FOR UPDATE OF ... (list of columnnames). this is not
implemented in postgresql. remove the row-locking from the entity bean
descriptors and try again.

holger

> 
> My server.log is full of it.
> 
> I have one database. Against it I ran:
> 
> the Engagement_model.ddl in etc/db 
> the src/ddl/Engagement*-scripts that match your db 
> the src/ddl/Application*-scripts that match your db
> 
> I scrubbed my deploy dir of all the old stuff.
> 
> At the /engagement/engagement-index.html web page I get errors like this:
> 
> javax.servlet.ServletException: null; CausedByException is:
>     Find failed: java.sql.SQLException: ERROR:  parser: parse error at 
> or near "." at character 170
> 
>     at org.wings.session.WingServlet.newSession(WingServlet.java:245)
>     at
> org.wings.session.WingServlet.getSessionServlet(WingServlet.java:271)
>     at org.wings.session.WingServlet.doGet(WingServlet.java:385)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>     at 
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
>     at 
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
>     at 
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
>
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
>
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
>
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
>     at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
>
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
>     at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
>     at 
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
>     at 
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
>     at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
>     at java.lang.Thread.run(Thread.java:534)
> 
> root cause
> 
> javax.servlet.ServletException: null; CausedByException is:
>     Find failed: java.sql.SQLException: ERROR:  parser: parse error at 
> or near "." at character 170
> 
>     at org.wings.session.SessionServlet.init(SessionServlet.java:270)
>     at org.wings.session.WingServlet.newSession(WingServlet.java:224)
>     at
> org.wings.session.WingServlet.getSessionServlet(WingServlet.java:271)
>     at org.wings.session.WingServlet.doGet(WingServlet.java:385)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>     at 
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
>     at 
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
>     at 
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
>
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
>
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
>
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
>     at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
>
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
>     at 
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
>     at 
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>     at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>     at 
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
>     at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
>     at 
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
>     at 
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
>     at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
>     at java.lang.Thread.run(Thread.java:534)
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Concern-users mailing list
> Con...@li...
> https://lists.sourceforge.net/lists/listinfo/concern-users
> 
> 


Holger Engels
(Dipl Inf Med)

--
Consultant, Architect, Developer
Mobile: +49 176 20119752


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/