Orbeon 2016.2 and MySQL

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

Orbeon 2016.2 and MySQL

bruno.buzzi
Hi,

I'm doing my first experimient (before migration to 2016.2.x) and there is a problem when connecting to Mysql.

I'm still researching on this, if i found the solution i will post it here.
In the meanwhile this is error in the orbeon.log:

2016-12-14 09:26:29,511 INFO  ProcessorService  - /fr/service/resource/form/orbeon/builder - Timing: 77
2016-12-14 09:26:29,511 INFO  lifecycle  - event: {"request": "9", "session": "95BD131F832A027570D3ADDAC6936475", "source": "service", "message": "end: handle", "time": "77 ms"}
2016-12-14 09:26:29,515 INFO  ProcessorService  - /fr/service/persistence/form/orbeon/builder - Timing: 90
2016-12-14 09:26:29,516 INFO  lifecycle  - event: {"request": "8", "session": "95BD131F832A027570D3ADDAC6936475", "source": "service", "message": "end: handle", "time": "91 ms"}
2016-12-14 09:26:29,554 ERROR PageFlowControllerProcessor  - error caught {controller: "oxf:/apps/fr/page-flow.xml", method: "POST", path: "/fr/service/mysql/search/orbeon/builder"}
2016-12-14 09:26:29,727 ERROR PageFlowControllerProcessor  -
+----------------------------------------------------------------------------------------------------------------------+
|An Error has Occurred                                                                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory                                                                    |
|----------------------------------------------------------------------------------------------------------------------|
|Application Call Stack                                                                                                |
|----------------------------------------------------------------------------------------------------------------------|
|oxf:/apps/fr/page-flow.xml                                                        |reading page view data output |  46|
|······················································································································|
|element=<service path="/fr/service/(oracle|mysql|postgresql|db2|sqlserver)/search/([^/^.]+)/([^/^.]+)" view="persisten|
|view   =persistence/relational/search.xpl                                                                             |
|----------------------------------------------------------------------------------------------------------------------|
|oxf:/apps/fr/persistence/relational/search.xpl                                    |reading processor output      |  22|
|······················································································································|
|element=<p:output name="data" ref="data"/>                                                                            |
|name   =data                                                                                                          |
|ref    =data                                                                                                          |
|----------------------------------------------------------------------------------------------------------------------|
|----------------------------------------------------------------------------------------------------------------------|
|Exception: java.lang.ClassNotFoundException                                                                           |
|----------------------------------------------------------------------------------------------------------------------|
|java.net.URLClassLoader                            |findClass                     |URLClassLoader.java           | 381|
|java.lang.ClassLoader                              |loadClass                     |ClassLoader.java              | 424|
|java.lang.ClassLoader                              |loadClass                     |ClassLoader.java              | 357|
|java.lang.Class                                    |forName0                      |Class.java                    |    |
|java.lang.Class                                    |forName                       |Class.java                    | 264|
|org.apache.naming.factory.ResourceFactory          |getObjectInstance             |ResourceFactory.java          | 115|
|----------------------------------------------------------------------------------------------------------------------|
|Exception: javax.naming.NamingException                                                                               |
|----------------------------------------------------------------------------------------------------------------------|
|org.apache.naming.factory.ResourceFactory          |getObjectInstance             |ResourceFactory.java          | 119|
|javax.naming.spi.NamingManager                     |getObjectInstance             |NamingManager.java            | 321|
|org.apache.naming.NamingContext                    |lookup                        |NamingContext.java            | 842|
|org.apache.naming.NamingContext                    |lookup                        |NamingContext.java            | 167|
|relational.RelationalUtils$$anonfun$getDataSource$3|apply                         |RelationalUtils.scala         |  72|
|relational.RelationalUtils$$anonfun$getDataSource$3|apply                         |RelationalUtils.scala         |  70|
|org.orbeon.oxf.util.Logging$class                  |withDebug                     |Logging.scala                 |  50|
|beon.oxf.fr.persistence.relational.RelationalUtils$|withDebug                     |RelationalUtils.scala         |  31|
|beon.oxf.fr.persistence.relational.RelationalUtils$|getDataSource                 |RelationalUtils.scala         |  70|
|beon.oxf.fr.persistence.relational.RelationalUtils$|withConnection                |RelationalUtils.scala         |  39|
|beon.oxf.fr.persistence.relational.RelationalUtils$|withConnection                |RelationalUtils.scala         |  36|
|.fr.persistence.relational.search.SearchLogic$class|doSearch                      |SearchLogic.scala             |  55|
|xf.fr.persistence.relational.search.SearchProcessor|doSearch                      |SearchProcessor.scala         |  23|
|rsistence.relational.search.SearchProcessor$$anon$1|readImpl                      |SearchProcessor.scala         |  48|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|----------------------------------------------------------------------------------------------------------------------|
|Exception: org.orbeon.oxf.common.ValidationException                                                                  |
|----------------------------------------------------------------------------------------------------------------------|
|org.orbeon.oxf.common.OrbeonLocationException$     |wrapException                 |OrbeonLocationException.scala |  60|
|org.orbeon.oxf.common.OrbeonLocationException      |wrapException                 |OrbeonLocationException.scala |    |
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 397|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
|orbeon.oxf.processor.pipeline.PipelineProcessor$1$1|run                           |PipelineProcessor.java        |  93|
|org.orbeon.oxf.processor.pipeline.PipelineProcessor|executeChildren               |PipelineProcessor.java        | 679|
|org.orbeon.oxf.processor.pipeline.PipelineProcessor|access$000                    |PipelineProcessor.java        |  60|
|g.orbeon.oxf.processor.pipeline.PipelineProcessor$1|readImpl                      |PipelineProcessor.java        |  91|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 266|
|org.orbeon.oxf.processor.IdentityProcessor$1       |readImpl                      |IdentityProcessor.java        |  33|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
|orbeon.oxf.processor.pipeline.PipelineProcessor$1$1|run                           |PipelineProcessor.java        |  93|
|org.orbeon.oxf.processor.pipeline.PipelineProcessor|executeChildren               |PipelineProcessor.java        | 679|
|org.orbeon.oxf.processor.pipeline.PipelineProcessor|access$000                    |PipelineProcessor.java        |  60|
|g.orbeon.oxf.processor.pipeline.PipelineProcessor$1|readImpl                      |PipelineProcessor.java        |  91|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|processor.pipeline.choose.ConcreteChooseProcessor$1|readImpl                      |ConcreteChooseProcessor.java  | 126|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 266|
|org.orbeon.oxf.processor.IdentityProcessor$1       |readImpl                      |IdentityProcessor.java        |  33|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
|orbeon.oxf.processor.pipeline.PipelineProcessor$1$1|run                           |PipelineProcessor.java        |  93|
|org.orbeon.oxf.processor.pipeline.PipelineProcessor|executeChildren               |PipelineProcessor.java        | 679|
|org.orbeon.oxf.processor.pipeline.PipelineProcessor|access$000                    |PipelineProcessor.java        |  60|
|g.orbeon.oxf.processor.pipeline.PipelineProcessor$1|readImpl                      |PipelineProcessor.java        |  91|
|essor.impl.ProcessorOutputImpl$TopLevelOutputFilter|read                          |ProcessorOutputImpl.java      | 257|
|org.orbeon.oxf.processor.impl.ProcessorOutputImpl  |read                          |ProcessorOutputImpl.java      | 394|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 262|
|org.orbeon.oxf.processor.ProcessorImpl             |readInputAsSAX                |ProcessorImpl.java            | 266|
|org.orbeon.oxf.processor.IdentityProcessor$1       |readImpl                      |IdentityProcessor.java        |  33|
|---8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<---|
|org.orbeon.oxf.webapp.ProcessorService$            |withProcessorService          |ProcessorService.scala        | 132|
|org.orbeon.oxf.servlet.OrbeonServlet               |service                       |OrbeonServlet.scala           |  69|
|javax.servlet.http.HttpServlet                     |service                       |HttpServlet.java              | 727|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 303|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|org.apache.tomcat.websocket.server.WsFilter        |doFilter                      |WsFilter.java                 |  52|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 241|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|org.orbeon.oxf.servlet.FormRunnerAuthFilter        |doFilter                      |FormRunnerAuthFilter.scala    |  26|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 241|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|doFilter$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1|apply$mcV$sp                  |LimiterFilter.scala           |  85|
|doFilter$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1|apply                         |LimiterFilter.scala           |  85|
|doFilter$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1|apply                         |LimiterFilter.scala           |  85|
|org.orbeon.oxf.logging.LifecycleLogger$            |withEvent                     |LifecycleLogger.scala         | 124|
|.LimiterFilter$$anonfun$doFilter$1$$anonfun$apply$1|apply$mcV$sp                  |LimiterFilter.scala           |  84|
|.LimiterFilter$$anonfun$doFilter$1$$anonfun$apply$1|apply                         |LimiterFilter.scala           |  78|
|.LimiterFilter$$anonfun$doFilter$1$$anonfun$apply$1|apply                         |LimiterFilter.scala           |  78|
|org.orbeon.oxf.logging.LifecycleLogger$            |withEvent                     |LifecycleLogger.scala         | 124|
|rbeon.oxf.servlet.LimiterFilter$$anonfun$doFilter$1|apply                         |LimiterFilter.scala           |  78|
|rbeon.oxf.servlet.LimiterFilter$$anonfun$doFilter$1|apply                         |LimiterFilter.scala           |  72|
|scala.Option                                       |foreach                       |Option.scala                  | 257|
|org.orbeon.oxf.servlet.LimiterFilter               |doFilter                      |LimiterFilter.scala           |  72|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 241|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|org.apache.catalina.core.StandardWrapperValve      |invoke                        |StandardWrapperValve.java     | 220|
|org.apache.catalina.core.StandardContextValve      |invoke                        |StandardContextValve.java     | 122|
|org.apache.catalina.authenticator.AuthenticatorBase|invoke                        |AuthenticatorBase.java        | 501|
|org.apache.catalina.core.StandardHostValve         |invoke                        |StandardHostValve.java        | 171|
|org.apache.catalina.valves.ErrorReportValve        |invoke                        |ErrorReportValve.java         | 102|
|org.apache.catalina.valves.AccessLogValve          |invoke                        |AccessLogValve.java           | 950|
|org.apache.catalina.core.StandardEngineValve       |invoke                        |StandardEngineValve.java      | 116|
|org.apache.catalina.connector.CoyoteAdapter        |service                       |CoyoteAdapter.java            | 408|
|org.apache.coyote.http11.AbstractHttp11Processor   |process                       |AbstractHttp11Processor.java  |1040|
|e.coyote.AbstractProtocol$AbstractConnectionHandler|process                       |AbstractProtocol.java         | 607|
|.apache.tomcat.util.net.JIoEndpoint$SocketProcessor|run                           |JIoEndpoint.java              | 314|
|java.util.concurrent.ThreadPoolExecutor            |runWorker                     |ThreadPoolExecutor.java       |1142|
|java.util.concurrent.ThreadPoolExecutor$Worker     |run                           |ThreadPoolExecutor.java       | 617|
|che.tomcat.util.threads.TaskThread$WrappingRunnable|run                           |TaskThread.java               |  61|
|java.lang.Thread                                   |run                           |Thread.java                   | 745|
+----------------------------------------------------------------------------------------------------------------------+
2016-12-14 09:26:29,728 INFO  ProcessorService  - /fr/service/mysql/search/orbeon/builder - Timing: 387
2016-12-14 09:26:29,728 INFO  lifecycle  - event: {"request": "7", "session": "95BD131F832A027570D3ADDAC6936475", "source": "service", "message": "end: handle", "time": "387 ms"}
2016-12-14 09:26:29,730 INFO  ProcessorService  - /fr/service/persistence/search/orbeon/builder - Timing: 445
2016-12-14 09:26:29,730 INFO  lifecycle  - event: {"request": "6", "session": "95BD131F832A027570D3ADDAC6936475", "source": "service", "message": "end: handle", "time": "445 ms"}
2016-12-14 09:26:29,730 DEBUG XFormsServer  -                   opening URL connection {method: "POST", URL: "http://localhost:8080/orbeon/fr/service/persistence/search/orbeon/builder", Cookie: "JSESSIONID=95BD131F832A027570D3ADDAC6936475", Content-Type: "application/xml", Orbeon-Token: "9fba8889605adff6dfcf20189339834d60732b4d"}
2016-12-14 09:26:29,731 DEBUG XFormsServer  -                   response {status code: "500"}
2016-12-14 09:26:29,732 DEBUG XFormsServer  -                   response has no content
2016-12-14 09:26:29,732 DEBUG XFormsServer  -                   saved HTTP state {scope: "session"}
2016-12-14 09:26:29,732 DEBUG XFormsServer  -                 end opening connection {time (ms): "449"}
2016-12-14 09:26:29,733 DEBUG XFormsServer  -               end connecting {time (ms): "451"}
2016-12-14 09:26:29,733 DEBUG XFormsServer  -               start handling result
2016-12-14 09:26:29,735 DEBUG XFormsServer  -                 evaluated model variables {count: "21"}
2016-12-14 09:26:29,736 DEBUG XFormsServer  -               end handling result {time (ms): "3"}
2016-12-14 09:26:29,736 DEBUG XFormsServer  -             end submission {time (ms): "549"}
2016-12-14 09:26:29,738 DEBUG XFormsServer  -             evaluated model variables {count: "21"}
2016-12-14 09:26:29,760 ERROR XFormsServer  -             xforms-submit-error - setting throwable {throwable: "
+----------------------------------------------------------------------------------------------------------------------+
|An Error has Occurred                                                                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|xf:submission for submission id: search-submission, error code received when submitting instance: 500                 |
|----------------------------------------------------------------------------------------------------------------------|
|Application Call Stack                                                                                                |
|----------------------------------------------------------------------------------------------------------------------|
|----------------------------------------------------------------------------------------------------------------------|
|Exception: org.orbeon.oxf.xforms.submission.XFormsSubmissionException                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|.orbeon.oxf.xforms.submission.XFormsModelSubmission|getReplacer                   |XFormsModelSubmission.java    | 722|
|rg.orbeon.oxf.xforms.submission.RegularSubmission$1|call                          |RegularSubmission.java        | 108|
|rg.orbeon.oxf.xforms.submission.RegularSubmission$1|call                          |RegularSubmission.java        |  78|
|org.orbeon.oxf.xforms.submission.BaseSubmission    |submitCallable                |BaseSubmission.scala          |  89|
|org.orbeon.oxf.xforms.submission.RegularSubmission |connect                       |RegularSubmission.java        | 131|
|.orbeon.oxf.xforms.submission.XFormsModelSubmission|doSubmit                      |XFormsModelSubmission.java    | 453|
|.orbeon.oxf.xforms.submission.XFormsModelSubmission|performDefaultAction          |XFormsModelSubmission.java    | 283|
|ch$$anonfun$dispatchEvent$1$$anonfun$apply$mcV$sp$1|apply$mcV$sp                  |Dispatch.scala                | 130|
|ch$$anonfun$dispatchEvent$1$$anonfun$apply$mcV$sp$1|apply                         |Dispatch.scala                |  79|
|ch$$anonfun$dispatchEvent$1$$anonfun$apply$mcV$sp$1|apply                         |Dispatch.scala                |  79|
|org.orbeon.oxf.util.Logging$class                  |withDebug                     |Logging.scala                 |  50|
|org.orbeon.oxf.xforms.event.Dispatch$              |withDebug                     |Dispatch.scala                |  28|
|.oxf.xforms.event.Dispatch$$anonfun$dispatchEvent$1|apply$mcV$sp                  |Dispatch.scala                |  79|
|.oxf.xforms.event.Dispatch$$anonfun$dispatchEvent$1|apply                         |Dispatch.scala                |  78|
|.oxf.xforms.event.Dispatch$$anonfun$dispatchEvent$1|apply                         |Dispatch.scala                |  78|
|org.orbeon.oxf.xforms.event.Dispatch$              |withEvent$1                   |Dispatch.scala                |  43|
|org.orbeon.oxf.xforms.event.Dispatch$              |dispatchEvent                 |Dispatch.scala                |  77|
|g.orbeon.oxf.xforms.action.actions.XFormsSendAction|execute                       |XFormsSendAction.scala        |  51|
|org.orbeon.oxf.xforms.action.XFormsAction          |execute                       |XFormsAction.scala            |  34|
|rg.orbeon.oxf.xforms.action.XFormsActionInterpreter|runSingleIteration            |XFormsActionInterpreter.java  | 221|
|rg.orbeon.oxf.xforms.action.XFormsActionInterpreter|runAction                     |XFormsActionInterpreter.java  | 157|
|ction.actions.XFormsActionAction$$anonfun$execute$2|apply                         |XFormsActionAction.scala      |  79|
|ction.actions.XFormsActionAction$$anonfun$execute$2|apply                         |XFormsActionAction.scala      |  67|
|scala.collection.Iterator$class                    |foreach                       |Iterator.scala                | 893|
|scala.collection.AbstractIterator                  |foreach                       |Iterator.scala                |1336|
|scala.collection.IterableLike$class                |foreach                       |IterableLike.scala            |  72|
|scala.collection.AbstractIterable                  |foreach                       |Iterable.scala                |  54|
|orbeon.oxf.xforms.action.actions.XFormsActionAction|execute                       |XFormsActionAction.scala      |  67|
|rg.orbeon.oxf.xforms.action.XFormsActionInterpreter|runSingleIteration            |XFormsActionInterpreter.java  | 221|
|rg.orbeon.oxf.xforms.action.XFormsActionInterpreter|runAction                     |XFormsActionInterpreter.java  | 157|
|forms.event.EventHandlerImpl$$anonfun$handleEvent$1|apply$mcV$sp                  |EventHandlerImpl.scala        | 256|
|forms.event.EventHandlerImpl$$anonfun$handleEvent$1|apply                         |EventHandlerImpl.scala        | 256|
|forms.event.EventHandlerImpl$$anonfun$handleEvent$1|apply                         |EventHandlerImpl.scala        | 256|
|org.orbeon.oxf.util.DynamicVariable                |withValue                     |DynamicVariable.scala         |  42|
|org.orbeon.oxf.xforms.action.XFormsAPI$            |withScalaAction               |XFormsAPI.scala               |  47|
|org.orbeon.oxf.xforms.event.EventHandlerImpl       |handleEvent                   |EventHandlerImpl.scala        | 255|
|$$anonfun$apply$2$$anonfun$apply$4$$anonfun$apply$1|apply$mcV$sp                  |Dispatch.scala                |  98|
|$$anonfun$apply$2$$anonfun$apply$4$$anonfun$apply$1|apply                         |Dispatch.scala                |  97|
|$$anonfun$apply$2$$anonfun$apply$4$$anonfun$apply$1|apply                         |Dispatch.scala                |  97|
|org.orbeon.oxf.util.Logging$class                  |withDebug                     |Logging.scala                 |  50|
|---8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<---|
|org.orbeon.oxf.webapp.ProcessorService$            |withProcessorService          |ProcessorService.scala        | 132|
|org.orbeon.oxf.servlet.OrbeonServlet               |service                       |OrbeonServlet.scala           |  69|
|javax.servlet.http.HttpServlet                     |service                       |HttpServlet.java              | 727|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 303|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|org.apache.tomcat.websocket.server.WsFilter        |doFilter                      |WsFilter.java                 |  52|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 241|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|org.orbeon.oxf.servlet.FormRunnerAuthFilter        |doFilter                      |FormRunnerAuthFilter.scala    |  26|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 241|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|doFilter$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1|apply$mcV$sp                  |LimiterFilter.scala           |  85|
|doFilter$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1|apply                         |LimiterFilter.scala           |  85|
|doFilter$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1|apply                         |LimiterFilter.scala           |  85|
|org.orbeon.oxf.logging.LifecycleLogger$            |withEvent                     |LifecycleLogger.scala         | 124|
|.LimiterFilter$$anonfun$doFilter$1$$anonfun$apply$1|apply$mcV$sp                  |LimiterFilter.scala           |  84|
|.LimiterFilter$$anonfun$doFilter$1$$anonfun$apply$1|apply                         |LimiterFilter.scala           |  78|
|.LimiterFilter$$anonfun$doFilter$1$$anonfun$apply$1|apply                         |LimiterFilter.scala           |  78|
|org.orbeon.oxf.logging.LifecycleLogger$            |withEvent                     |LifecycleLogger.scala         | 124|
|rbeon.oxf.servlet.LimiterFilter$$anonfun$doFilter$1|apply                         |LimiterFilter.scala           |  78|
|rbeon.oxf.servlet.LimiterFilter$$anonfun$doFilter$1|apply                         |LimiterFilter.scala           |  72|
|scala.Option                                       |foreach                       |Option.scala                  | 257|
|org.orbeon.oxf.servlet.LimiterFilter               |doFilter                      |LimiterFilter.scala           |  72|
|org.apache.catalina.core.ApplicationFilterChain    |internalDoFilter              |ApplicationFilterChain.java   | 241|
|org.apache.catalina.core.ApplicationFilterChain    |doFilter                      |ApplicationFilterChain.java   | 208|
|org.apache.catalina.core.StandardWrapperValve      |invoke                        |StandardWrapperValve.java     | 220|
|org.apache.catalina.core.StandardContextValve      |invoke                        |StandardContextValve.java     | 122|
|org.apache.catalina.authenticator.AuthenticatorBase|invoke                        |AuthenticatorBase.java        | 501|
|org.apache.catalina.core.StandardHostValve         |invoke                        |StandardHostValve.java        | 171|
|org.apache.catalina.valves.ErrorReportValve        |invoke                        |ErrorReportValve.java         | 102|
|org.apache.catalina.valves.AccessLogValve          |invoke                        |AccessLogValve.java           | 950|
|org.apache.catalina.core.StandardEngineValve       |invoke                        |StandardEngineValve.java      | 116|
|org.apache.catalina.connector.CoyoteAdapter        |service                       |CoyoteAdapter.java            | 408|
|org.apache.coyote.http11.AbstractHttp11Processor   |process                       |AbstractHttp11Processor.java  |1040|
|e.coyote.AbstractProtocol$AbstractConnectionHandler|process                       |AbstractProtocol.java         | 607|
|.apache.tomcat.util.net.JIoEndpoint$SocketProcessor|run                           |JIoEndpoint.java              | 314|
|java.util.concurrent.ThreadPoolExecutor            |runWorker                     |ThreadPoolExecutor.java       |1142|
|java.util.concurrent.ThreadPoolExecutor$Worker     |run                           |ThreadPoolExecutor.java       | 617|
|che.tomcat.util.threads.TaskThread$WrappingRunnable|run                           |TaskThread.java               |  61|
|java.lang.Thread                                   |run                           |Thread.java                   | 745|
+----------------------------------------------------------------------------------------------------------------------+"}
2016-12-14 09:26:29,761 DEBUG XFormsServer  -             start dispatching {name: "xforms-submit-error", target: "search-submission"}
2016-12-14 09:26:29,761 DEBUG XFormsServer  -               start handler {name: "xforms-submit-error", phase: "target", observer:
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon 2016.2 and MySQL

bruno.buzzi
Hi,

Fixed :)

Add the following property to context.xml (Tomcat file) in the resource node:
factory="org.apache.commons.dbcp.BasicDataSourceFactory"

 <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
    initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
    driverClassName="com.mysql.jdbc.Driver"
    poolPreparedStatements="true"
    username="xxx"
    password="xxx"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory"
    url="jdbc:mysql://localhost:3306/orbeon"/> 
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon 2016.2 and MySQL

Alessandro  Vernet
Administrator
Hi Bruno,

Good to know this fixes the problem. I'm not sure why you need to specify the a factory on the <Resource>. Here, I never had to do this, but thanks for sharing this tip.

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet