Orbeon 3.9.0 PE RC1 with remote mysql server

 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

Aminul,

Could this be a MySQL version issue? I see in your log:

"FUNCTION orbeon.extractValue does not exist"

A quick search seems to indicate this XML function was introduced in
MySQL 5.1.5:

http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html

-Erik

On Fri, Apr 8, 2011 at 2:28 AM, aminul <[hidden email]> wrote:

--
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

Hi Erik,

Thank you for your response. And yes, this was a Mysql version issue. I change the Mysql server to 5.1.34 and it works nicely.

Good to hear! -Erik

On Mon, Apr 11, 2011 at 1:35 AM, aminul <[hidden email]> wrote:

--
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