how should I turn off this way, and which are stored in the database?

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

how should I turn off this way, and which are stored in the database?

Mucw
This post was updated on .
I come from China, I am a new user of orbeon forms, I hope you can help me

I want to build a form orbeon forms stored in my local mysql database, but it is always stored in \webapps\orbeon\WEB-INF\exist-data, how should I turn off this way, and which are stored in the database?
First, I have configured /META-INF/context.xml
<Context>
     <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 = "root"
         password = "root"
         url = "jdbc: mysql: // localhost: 3333 / orbeon useUnicode = true & amp; characterEncoding = UTF8?" />
</ Context>
Then configure the properties-local.xml
<properties xmlns: xs = "http://www.w3.org/2001/XMLSchema"
             xmlns: oxf = "http://www.orbeon.com/oxf/processors">
    <property as = "xs: boolean" name = "oxf.fr.persistence.exist.active" value = "false" />
    <property as = "xs: string" name = "oxf.fr.persistence.provider.acme * *.." value = "mysql" />
    <property as = "xs: string" name = "oxf.fr.persistence.mysql.datasource" value = "mysql" />
</ properties>
Lifting web.xml comment
    <resource-ref>
        <description>DataSource</description>
        <res-ref-name>jdbc/mysql</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
Reply | Threaded
Open this post in threaded view
|

Re: how should I turn off this way, and which are stored in the database?

Alessandro  Vernet
Administrator
Hi,

Welcome to this discussion group! Your configuration for MySQL looks correct. You were saying that despite you setting up MySQL, data "is always stored in XML". Even if you're using MySQL, data will be saved as XML inside SQL (e.g. in the xml column of the orbeon_form_data table). Is this what you are noticing, or are you saying that the data is stored inside eXist instead of MySQL?

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: how should I turn off this way, and which are stored in the database?

Mucw
This post was updated on .
hello..
oh!I'm sorry.
I have no clear I mean, I mean my forms stored in \ webapps \ orbeon \ WEB - INF \ exist - the data, rather than stored in the mysql database.
In addition I use environment is jdk1.8 tomcat7, mysql5.6, Windows 7
Reply | Threaded
Open this post in threaded view
|

Re: how should I turn off this way, and which are stored in the database?

Mucw
In reply to this post by Alessandro Vernet
Oh!My god!
I was too careless, a small details didn't notice.
Fortunately, I found it,My problem is solved.Thank you..
Reply | Threaded
Open this post in threaded view
|

Re: how should I turn off this way, and which are stored in the database?

Alessandro  Vernet
Administrator
OK, excellent, I'm glad you found the solution. And no problem: there are lots of places in the database setup where just a typo can prevent the setup from working.

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