ORBEAON MYSQL Integration

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

ORBEAON MYSQL Integration

thajegan76
Hi

I have downloaded Orbeon PE version. Installed it on my PC and everything is working fine.

Now I want Orbeon Form Data to be stored in mysql database. I already followed the instruction mention in the following URL

https://doc.orbeon.com/form-runner/persistence/relational-db.html#mysql-database-setup

Setting up users and schema is already done.

DDL already executed. The script is downloaded from the following URL.
https://github.com/orbeon/orbeon-forms/blob/master/form-runner/jvm/src/main/resources/apps/fr/persistence/relational/ddl/mysql-2016_3.sql

Tomcat datasource is already configured in sever.xml as follows

        <Context path="/orbeon"
            docBase="orbeon"
            reloadable="false"
            override="true"
            allowLinking="true">
           
            <Resource name="jdbc/mysql"
                driverClassName="com.mysql.jdbc.Driver"
                auth="Container"
                type="javax.sql.DataSource"

                initialSize="3"
                maxActive="10"
                maxIdle="10"
                maxWait="30000"

                poolPreparedStatements="true"

                testOnBorrow="true"
                validationQuery="select 1"

                username="orbeon"
                password="orbeon"
                url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>
        </Context>

mysql-connector-java-5.1.39-bin.jar already downloaded and placed in
E:\Tomcat9\webapps\orbeon\WEB-INF\lib


In E:\Tomcat9\webapps\orbeon\WEB-INF\resources\config folder the properties-local.xml file is as follows

<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"
            xmlns:oxf="http://www.orbeon.com/oxf/processors">
       
        <property as="xs:string" name="oxf.fr.persistence.provider.mysql.*.*" value="mysql"/>

</properties>

But still the forms are not being stored in MYSQL database.

What step am I missing ? Need HELP.

Thank in Advance

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Reply | Threaded
Open this post in threaded view
|

Re: ORBEAON MYSQL Integration

Alessandro  Vernet
Administrator
Hi Thayanithy,

I just noticed one thing reading through the description of your setup: the MySQL JDBC driver (`mysql-connector-java-5.1.39-bin.jar`, in your case), goes in the Tomcat’s lib directory, not the Orbeon Forms WEB-INF/lib. You’ll let us know of moving that jar file helps.

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