Orbeon Forms Integraions with Liferay

Hi All,
1.I have downloaded the orbeon source code version 4.3.0 from Github
2.I have done scala plugin support with Eclipse IDE
3.Loaded the source code in eclipse as ant build.xml
4.I have configured the MySQL configurations in server.xml and local-properties.xml
5.I have performed ant clean and then ant test then code was executed fines
6.I have opened URL in browser http://localhost:8080/orbeon then home page opening then click on FormBuilder the editor was opened then create form

Problem :
Form was creating fine but problem was created forms are not stored in MySQL DB

My orbeon log was below :

In Orbeon

2014-02-27 10:52:15,892 INFO  ProcessorService  - /fr/service/exist/crud/orbeon/builder/data/45d9d9b79662adc5a4ca273a07c5fe30f467ed5e/data.xml - Timing: 214
2014-02-27 10:52:15,893 INFO  ProcessorService  - /fr/service/persistence/crud/orbeon/builder/data/45d9d9b79662adc5a4ca273a07c5fe30f467ed5e/data.xml - Timing: 231


Please kindly help me or else provide me any documentation for this
issue.


Thanks
RaaZ

Hi RaaZ,

Based on the snippet you quote, it seems eXist is still being used, and Orbeon isn't even trying to go through MySQL. I'm not sure if this is a typo just in this message, but the name of the file isn't local-properties.xml but properties-local.xml.

Also, to start "simple", I would making this work with a 4.4 build you just deploy on Tomcat. For starter don't try to build it yourself. You can always do it later once your setup with MySQL is working.

Alex

Thank you 'Alex' now its working
1.I have downloaded 4.4 version
2.I have incorrectly configured in properties-local.xml
 
Not Working :  
    <property as="xs:anyURI"  name="oxf.fr.persistence.mysql.uri"                               value="/fr/service/mysql"/>
    <property as="xs:string"  name="oxf.fr.persistence.mysql.datasource"                        value="mysql"/>

Working Syntax :
     <property as="xs:string" name="oxf.fr.persistence.provider.*.*.*" value="mysql"/>
     <property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql"/>

Thanks,
RaaZ
 

Hi RaaZ,

Excellent, I am glad you found the solution. Indeed, what you had there were the pre-4.0 properties to setup the persistence layer. And thanks for sharing your solution with the community.

Alex

Hi Alex,

Please help me
1.I have deployed orbeon .war into my liferay server
2.I have configured configuration as mentioned in below link
http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/form-runner-proxy-portlet-guide#TOC-Configure-the-proxy-portlet
3.In my liferay website i have logged in and able to create the forms are fine
4.Form are storing in my SQL-DB Fine
4.I have configured below properties in properties-local.xml

<property as="xs:string" name="oxf.fr.authentication.method"          value="header"/>
<property as="xs:string" name="oxf.fr.authentication.header.username" value="Liferay-Orbeon-User-User-Id"/>
<property as="xs:string" name="oxf.fr.authentication.header.group"    value="Liferay-Orbeon-User-Group"/>
<property as="xs:string" name="oxf.fr.authentication.header.roles"    value="Liferay-Orbeon-User-Roles"/>
<property as="xs:string" name="oxf.xforms.forward-submission-headers"
                         value="Liferay-Orbeon-User-User-Id "Liferay-Orbeon-User-Roles"/>
<property as="xs:string" name="oxf.http.forward-headers"
value="Liferay-Orbeon-User-User-Id "Liferay-Orbeon-User-Roles"/> 

5.But liferay logged in user information not stored in username,last_modifid_by in orbeon_form_data nothing will be placed in this column (empty is inserting)

Problems :

1.Username was not stored in my SQL db (Culumn username,lastmodified)
2.Please help me how to handle users
3.who will create the form ( who was logged in my site) that  logged in user information need to insert in orbeon_form_data (Columns : username,last_modify_by)

Please help me
Thansk

RaaZ

RaaZ,

This seems like something we need to try out. I will try to reproduce this scenario with 4.5.

-Erik