Orbeon and Mysql persistence layer problems

> Hi all,
>
> We configured orbeon (version: 3.9.0.201105152053-PE) to use Mysql and it
> worked, but I'm facing some problems with Orbeon and Mysql persistence
> layer:
>
> 1) The first problem is that every day, we need to restart the tomcat,
> because the Form Builder summary page doesn't show the forms and shows the
> following exception in orbeon.log file:
>
> 2011-09-06 09:55:40,163 ERROR XFormsServer  - xforms-submit-error - setting
> throwable {throwable:
> "org.orbeon.oxf.xforms.submission.XFormsSubmissionException:  (processing
> submission response): xforms:submission for submission id:
> search-submission, error code received when submitting instance: 500
> null, line -1, column -1: xforms:submission for submission id:
> search-submission, error code received when submitting instance: 500
>        at
> org.orbeon.oxf.xforms.submission.XFormsModelSubmission.getReplacer(XFormsModelSubmission.java:672)
>
> *Steps to reproduce*
>  - Configure the Orbeon Form Builder to use mysql persistence and create one
> form.
>  - Let it over night and the other day, try to access Form Builder summary
> page. It will not show the form and the orbeon.log will show the exception.
> After restart tomcat, it works again.
>
> *
> My database configurations:*
>    - tomcat/conf/server.xml:
>                <Context path="/orbeon" privileged="true"
> antiResourceLocking="false" antiJARLocking="false" useNaming="true"
> unpackWAR="false">
>                        <Resource name="jdbc/mysql" auth="Container"
> type="javax.sql.DataSource" initialSize="3" maxActive="10" maxIdle="20"
> maxWait="30000" driverClassName="com.mysql.jdbc.Driver" poolPrepa$
>                                username="orbeon" password="orbeon"
> url="jdbc:mysql://10.81.0.145:3306/ys-eservice?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false"/>
>                </Context>
>
>   -orbeon/WEB-INF/resources/config/properties-local.xml :
>        <property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*"
> value="/fr/service/mysql"/>
>        <property as="xs:anyURI"
> name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>
>
> 2)The second problem I've posted a long time ago. The link to the topic is:
> http://orbeon-forms-ops-users.24843.n4.nabble.com/Form-Builder-When-using-xxforms-iterate-the-summary-page-doesn-t-show-form-name-td3554586.html
>
>
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Orbeon-and-Mysql-persistence-layer-problems-tp3798044p3798044.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>