Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
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&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]. |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
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 |
Free forum by Nabble | Edit this page |