Posted by aminul on Apr 08, 2011; 9:28am
URL: https://discuss.orbeon.com/Orbeon-3-9-0-PE-RC1-with-remote-mysql-server-tp3435716.html

 I'm using Orbeon 3.9.0 PE RC1 with liferay-portal-6.0.5. When using Localhost Mysql persistence layer, it works nice.

 but when try to use remote Mysql database , then Form builder can't publish any form and no data shown by form runner. But connection is establish because Orbeon builder send form data to orbeon_form_data and though can publish a form with an error message, after hit the close button of builder, summery page show the form.
in properties-local.xml file

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource"
                             value="mysql"/>
        <property as="xs:anyURI"  name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>
        <property as="xs:anyURI"  name="oxf.url-rewriting.service.base-uri"
              value="http://localhost:8080/orbeon"/>

in server.xml file to point the mysql server

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
        initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
        name="jdbc/mysql"
        password="p"
        poolPreparedStatements="true" type="javax.sql.DataSource"
        url="jdbc:mysql://localhost:3306/orbeon"
        username="root"/>

Please see the attach file for detail error log.orbeon.log