Re: Server side validation on Orbeon Forms

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

1. Run the following data definition statements to create the tables:

        create table orbeon_form_definition (
            created timestamp,
            last_modified datetime,
            username varchar(256),
            app varchar(256),
            form varchar(256),
            deleted char(1),
            xml mediumtext
        );
        create table orbeon_form_definition_attach (
            created timestamp,
            last_modified timestamp,
            username varchar(256),
            app varchar(256),
            form varchar(256),
            deleted char(1),
            file_name varchar(256),
            file_content longblob
        );
        create table orbeon_form_data (
            created timestamp,
            last_modified timestamp,
            username varchar(256),
            app varchar(256),
            form varchar(256),
            document_id varchar(256),
            deleted char(1),
            xml mediumtext
        );
        create table orbeon_form_data_attach (
            created timestamp,
            last_modified timestamp,
            username varchar(256),
            app varchar(256),
            form varchar(256),
            document_id varchar(256),
            deleted char(1),
            file_name varchar(256),
            file_content longblob
        );


2. Download  mysql-connector-java-5.1.12-bin.jar and place it in apache-tomcat\lib folder

3. In the conf.xml insert the database details

e.g

<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="orbeon"
    password="orbeon"
    url="jdbc:mysql://localhost:3306/orbeon"/>

4. Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)

5. Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI"  name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

Thts it ! After you make these changes you should construct a form, save it , publish it. Then you shld check the table you created. The form will be stored as xml in the database!

---