Form Builder doesn't show in Summary View forms saved in MySQL db

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Form Builder doesn't show in Summary View forms saved in MySQL db

abiketov
Hi,

I configured orbeon 4.6 CE to use MySQL database with JBoss EAP 6.1. The only problem I have that when I save form I don't see saved form when I click Summary button in Form Builder. When I do save and publish Form Runner shows a new published form but I still can't see it in Form Builder. I'm getting the following exception:

20:05:43,131 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,131 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |Application Call Stack                                                                                                |
20:05:43,132 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,132 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |oxf:/apps/fr/page-flow.xml                                                        |reading page view data output |  46|
20:05:43,132 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |ииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииии|
20:05:43,133 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |element=<service path="/fr/service/(oracle|mysql|db2|sqlserver)/search/([^/^.]+)/([^/^.]+)" view="persistence/relation|
20:05:43,133 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |view   =persistence/relational/search.xpl                                                                             |
20:05:43,134 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,134 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |oxf:/apps/fr/persistence/relational/search.xpl                                    |reading processor output      | 445|
20:05:43,135 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |ииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииииии|
20:05:43,135 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |element=<p:output name="data" ref="data"/>                                                                            |
20:05:43,136 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |name   =data                                                                                                          |
20:05:43,136 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |ref    =data                                                                                                          |
20:05:43,136 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,137 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |oxf:/apps/fr/persistence/relational/search.xpl                                    |executing XSLT transformation |    |
20:05:43,137 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,138 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |Exception: java.lang.NumberFormatException                                                                            |
20:05:43,138 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,138 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |com.mysql.jdbc.StringUtils                         |getInt                        |StringUtils.java              | 759|
20:05:43,139 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |com.mysql.jdbc.ResultSetRow                        |getTimestampFast              |ResultSetRow.java             |1117|
20:05:43,139 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |com.mysql.jdbc.BufferRow                           |getTimestampFast              |BufferRow.java                | 578|
20:05:43,140 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |com.mysql.jdbc.ResultSetImpl                       |getTimestampInternal          |ResultSetImpl.java            |6754|
20:05:43,140 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |com.mysql.jdbc.ResultSetImpl                       |getTimestamp                  |ResultSetImpl.java            |6073|
20:05:43,140 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.jboss.jca.adapters.jdbc.WrappedResultSet       |getTimestamp                  |WrappedResultSet.java         |1486|
20:05:43,141 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |on.oxf.processor.sql.interpreters.GetterInterpreter|getColumnStringValue          |GetterInterpreter.java        | 462|
20:05:43,141 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |on.oxf.processor.sql.interpreters.GetterInterpreter|getColumnValue                |GetterInterpreter.java        | 442|
20:05:43,142 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |on.oxf.processor.sql.interpreters.GetterInterpreter|start                         |GetterInterpreter.java        | 140|
20:05:43,142 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|startElement                  |SQLProcessor.java             | 503|
20:05:43,143 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |f.processor.sql.interpreters.RowIteratorInterpreter|startElement                  |RowIteratorInterpreter.java   | 166|
20:05:43,143 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.xml.SAXStore                        |replay                        |SAXStore.java                 | 309|
20:05:43,143 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.xml.SAXStore                        |replay                        |SAXStore.java                 | 235|
20:05:43,144 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|repeatBody                    |SQLProcessor.java             | 549|
20:05:43,144 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |f.processor.sql.interpreters.RowIteratorInterpreter|start                         |RowIteratorInterpreter.java   |  95|
20:05:43,145 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|endElement                    |SQLProcessor.java             | 529|
20:05:43,145 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.xml.SAXStore                        |replay                        |SAXStore.java                 | 321|
20:05:43,146 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.xml.SAXStore                        |replay                        |SAXStore.java                 | 235|
20:05:43,146 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|repeatBody                    |SQLProcessor.java             | 549|
20:05:43,147 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |oxf.processor.sql.interpreters.ResultSetInterpreter|start                         |ResultSetInterpreter.java     |  75|
20:05:43,147 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|endElement                    |SQLProcessor.java             | 529|
20:05:43,147 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |processor.sql.SQLProcessor$ForwardingContentHandler|endElement                    |SQLProcessor.java             | 635|
20:05:43,148 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|endElement                    |SQLProcessor.java             | 542|
20:05:43,148 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |processor.sql.SQLProcessor$ForwardingContentHandler|endElement                    |SQLProcessor.java             | 635|
20:05:43,148 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|endElement                    |SQLProcessor.java             | 542|
20:05:43,149 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |processor.sql.SQLProcessor$ForwardingContentHandler|endElement                    |SQLProcessor.java             | 635|
20:05:43,149 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |rocessor.sql.SQLProcessor$InterpreterContentHandler|endElement                    |SQLProcessor.java             | 542|
20:05:43,150 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |beon.oxf.processor.sql.SQLProcessor$RootInterpreter|endElement                    |SQLProcessor.java             | 290|
20:05:43,151 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.xml.SAXStore                        |replay                        |SAXStore.java                 | 321|
20:05:43,151 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.xml.SAXStore                        |replay                        |SAXStore.java                 | 235|
20:05:43,152 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.sql.SQLProcessor          |execute                       |SQLProcessor.java             | 251|
20:05:43,152 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.sql.SQLProcessor$1        |readImpl                      |SQLProcessor.java             |  89|
20:05:43,153 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 258|
20:05:43,153 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 404|
20:05:43,153 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
20:05:43,154 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 266|
20:05:43,154 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |on.oxf.processor.transformer.xslt.XSLTTransformer$1|runTransformer                |XSLTTransformer.java          | 467|
20:05:43,155 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,155 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |Exception: org.orbeon.oxf.common.ValidationException                                                                  |
20:05:43,155 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |----------------------------------------------------------------------------------------------------------------------|
20:05:43,156 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.common.OrbeonLocationException$     |wrapException                 |OrbeonLocationException.scala |  60|
20:05:43,156 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.common.OrbeonLocationException      |wrapException                 |OrbeonLocationException.scala |    |
20:05:43,156 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |on.oxf.processor.transformer.xslt.XSLTTransformer$1|runTransformer                |XSLTTransformer.java          | 526|
20:05:43,157 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |on.oxf.processor.transformer.xslt.XSLTTransformer$1|readImpl                      |XSLTTransformer.java          | 188|
20:05:43,157 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 258|
20:05:43,158 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 404|
20:05:43,158 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
20:05:43,158 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |orbeon.oxf.processor.pipeline.PipelineProcessor$1$1|run                           |PipelineProcessor.java        |  93|
20:05:43,159 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.pipeline.PipelineProcessor|executeChildren               |PipelineProcessor.java        | 680|
20:05:43,159 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.pipeline.PipelineProcessor|access$000                    |PipelineProcessor.java        |  60|
20:05:43,159 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |g.orbeon.oxf.processor.pipeline.PipelineProcessor$1|readImpl                      |PipelineProcessor.java        |  91|
20:05:43,160 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 258|
20:05:43,160 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 404|
20:05:43,160 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
20:05:43,161 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 266|
20:05:43,161 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.IdentityProcessor$1       |readImpl                      |IdentityProcessor.java        |  33|
20:05:43,161 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 258|
20:05:43,161 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 404|
20:05:43,162 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
20:05:43,162 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |orbeon.oxf.processor.pipeline.PipelineProcessor$1$1|run                           |PipelineProcessor.java        |  93|
20:05:43,162 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |---8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<---|
20:05:43,163 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.webapp.ProcessorService             |service                       |ProcessorService.scala        |  41|
20:05:43,163 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |orbeon.oxf.servlet.OrbeonServlet$$anonfun$service$1|apply$mcV$sp                  |OrbeonServlet.scala           |  74|
20:05:43,163 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |orbeon.oxf.servlet.OrbeonServlet$$anonfun$service$1|apply                         |OrbeonServlet.scala           |  67|
20:05:43,164 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |orbeon.oxf.servlet.OrbeonServlet$$anonfun$service$1|apply                         |OrbeonServlet.scala           |  67|
20:05:43,164 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.util.ScalaUtils$                    |withRootException             |ScalaUtils.scala              | 118|
20:05:43,164 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.orbeon.oxf.servlet.OrbeonServlet               |service                       |OrbeonServlet.scala           |  67|
20:05:43,165 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |javax.servlet.http.HttpServlet                     |service                       |HttpServlet.java              | 847|
20:05:43,165 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 295|
20:05:43,165 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 214|
20:05:43,166 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.core.StandardWrapperValve      |invoke                        |StandardWrapperValve.java     | 230|
20:05:43,166 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.core.StandardContextValve      |invoke                        |StandardContextValve.java     | 149|
20:05:43,166 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |oss.as.web.security.SecurityContextAssociationValve|invoke                        |SecurityContextAssociationValv| 169|
20:05:43,167 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.core.StandardHostValve         |invoke                        |StandardHostValve.java        | 145|
20:05:43,167 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.valves.ErrorReportValve        |invoke                        |ErrorReportValve.java         |  97|
20:05:43,167 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.core.StandardEngineValve       |invoke                        |StandardEngineValve.java      | 102|
20:05:43,168 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.catalina.connector.CoyoteAdapter        |service                       |CoyoteAdapter.java            | 336|
20:05:43,168 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.coyote.http11.Http11Processor           |process                       |Http11Processor.java          | 856|
20:05:43,168 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |oyote.http11.Http11Protocol$Http11ConnectionHandler|process                       |Http11Protocol.java           | 653|
20:05:43,169 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |org.apache.tomcat.util.net.JIoEndpoint$Worker      |run                           |JIoEndpoint.java              | 920|
20:05:43,169 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     |java.lang.Thread                                   |run                           |Thread.java                   | 745|
20:05:43,169 ERROR [org.orbeon.oxf.controller.PageFlowControllerProcessor] (http-/127.0.0.1:8080-3)     +----------------------------------------------------------------------------------------------------------------------+ {}
20:05:43,170 INFO  [org.orbeon.oxf.webapp.ProcessorService] (http-/127.0.0.1:8080-3) /fr/service/mysql/search/orbeon/builder - Timing: 181
Reply | Threaded
Open this post in threaded view
|

Re: Form Builder doesn't show in Summary View forms saved in MySQL db

Alessandro  Vernet
Administrator
Hi,

The exception that matters here seems to be java.lang.NumberFormatException when the Orbeon code is calling getTimestamp() on a result set. The first thing that comes to mind is that the tables might not have the expected columns. Could you check that your tables in MySQL are defined exactly as per:

https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/relational/ddl/mysql-4_6.sql

Note that if you upgraded from a previous version of Orbeon Forms, you might need to update your tables in the MySQL. For more on this, and the scripts to upgrade, see:

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/oracle-and-mysql-persistence-layers#TOC-MySQL

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Form Builder doesn't show in Summary View forms saved in MySQL db

abiketov
Hi Alex,

I used latest 4.6 CE installation and created tables based on provided MySQL script. In the database I have date columns defined exactly as is in the script.

Andrei