Hi Alex,
I am trying to store orbeon form in mysql database.
I alreday have mysql 5.7.1 database setted up. I have created schema orbeon
using user root & password xyz. I have executed DDL of orbeon tables so
tables got created.
Then for configuration I have done below steps-
1. In my tomcat8 i have added mysql-connector-java-5.1.38.jar under
tomcat/lib/
then added jndi Resource in tomcats server.xml as below
<context path="/orbeon" docBase="orbeon" reloadable="false"
override="true" allowLinking="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="root"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
validationQuery="SELECT * FROM orbeon_form_data"
url="jdbc:mysql://localhost:3306/orbeon"/>
</context>
2. Then I ahve added resource configuration in orbeon webapps web.xml file
as
<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>
3. Then added properties-local.xml file under
orbeon\WEB-INF\resources\config with below contents
<?xml version="1.0" encoding="UTF-8"?>
<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.myapp.*.*"
value="mysql"/>
<property as="xs:string" name="oxf.fr.persistence.mysql.datasource"
value="mysql"/>
</properties>
4. Then started tomcat server & tested orbeon form builder.
I have created a form form1 with app name myapp and added 2-3 input textbox.
when I try to save the form it gives an error "There was an error
communicating with the database..."
I have also checked orbeon.log file but i haven;t found anything realted to
db error. I have also tried with enabling log for sqlprocessor on log4j xml
of orbeon. Still not got any error in orbeon.log file.
so please let me know what i missed.
Thanks
Ashok
--
View this message in context:
http://discuss.orbeon.com/Need-help-to-integrate-orbeon-form-builder-runner-with-java-spring-webapp-tp4661160p4661240.html