Can not connect orbeon form with mysql

Could you try again with Orbeon Forms 4.4? Version 4.3 had some known issues with MySQL, and since you're starting off, you're better off anyway using the latest version. You'll let us know if this solves your problem.

Alex

--
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].

I do the same step but orbeon form no started.
Orbeon 4.4

Are you seeing any error in the console? If not, are there any error in the orbeon.log?

Alex

Hi,

I'm not sure if this will solve your problem, but I got it working with 4.4.
What I did was the following:

1. In tomcat conf/context.xml (using Tomcat 6.0.36)

<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"
    validationQuery="select 1 from dual"
    testOnBorrow="true"
    username="orbeon"
    password=""
    url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>

2. In tomcat conf/context.ml
(this is to change the location of the forms and work outside of orbeon folder)


        <Parameter override="false"
               name="oxf.resources.priority.0"
               value="org.orbeon.oxf.resources.FilesystemResourceManagerFactory"/>
    <Parameter override="false"
               name="oxf.resources.priority.0.oxf.resources.filesystem.sandbox-directory"
               value="e:/work/www/xforms/resources"/>



3. in Mysql:
- create DB orbeon
- create user orbeon with empty password
- create tables:

CREATE TABLE `orbeon_form_data` (
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_modified_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_modified_by` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `groupname` varchar(255) DEFAULT NULL,
  `app` varchar(255) DEFAULT NULL,
  `form` varchar(255) DEFAULT NULL,
  `form_version` int(11) NOT NULL,
  `document_id` varchar(255) DEFAULT NULL,
  `draft` char(1) NOT NULL,
  `deleted` char(1) NOT NULL,
  `xml` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `orbeon_form_data_attach` */

DROP TABLE IF EXISTS `orbeon_form_data_attach`;

CREATE TABLE `orbeon_form_data_attach` (
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_modified_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_modified_by` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `groupname` varchar(255) DEFAULT NULL,
  `app` varchar(255) DEFAULT NULL,
  `form` varchar(255) DEFAULT NULL,
  `form_version` int(11) NOT NULL,
  `document_id` varchar(255) DEFAULT NULL,
  `draft` char(1) NOT NULL,
  `deleted` char(1) NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_content` longblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `orbeon_form_definition` */

DROP TABLE IF EXISTS `orbeon_form_definition`;

CREATE TABLE `orbeon_form_definition` (
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_modified_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_modified_by` varchar(255) DEFAULT NULL,
  `app` varchar(255) DEFAULT NULL,
  `form` varchar(255) DEFAULT NULL,
  `form_version` int(11) NOT NULL,
  `deleted` char(1) NOT NULL,
  `xml` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `orbeon_form_definition_attach` */

DROP TABLE IF EXISTS `orbeon_form_definition_attach`;

CREATE TABLE `orbeon_form_definition_attach` (
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_modified_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_modified_by` varchar(255) DEFAULT NULL,
  `app` varchar(255) DEFAULT NULL,
  `form` varchar(255) DEFAULT NULL,
  `form_version` int(11) NOT NULL,
  `deleted` char(1) NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_content` longblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

4. In e:/work/www/xforms/resources (my working dir)
- create dir config
- create file properties-local.xml with:

<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.*.*.*" value="mysql"/>
			<property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql"/>
</properties>

hope this helps
Cheers
hesos

Thanks for your reply.
Instead of defining "resource" information in apache-tomcat-6.0.37\conf\context.xml file, I have added these below lines in apache-tomcat-6.0.37\conf\server.xml. And now it works for me.

<Context
  path="/orbeon"
  docBase="/path/to/orbeon.war"
  reloadable="false"
  override="true"
  allowLinking="true">
    <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?useUnicode=true&amp;characterEncoding=UTF8"/>
</Context>

I am glad this is now working for you. This is also what I am doing locally here (i.e. define the <Resource> inside the <Context> for Orbeon Forms, in Tomcat's server.xml).

And Hesos, thank you for sharing your config!

Alex

Hi all,
I am completely new to Orbeon Forms. How to save the orbeon forms in Postgresql.
Some one check this post
http://stackoverflow.com/questions/31201679/orbeon-forms-postgres-db-connection and help me to I need to save the orbeon forms in Postgresql.

While publish the forms in the form builder it says the error  in orbeon.log file.

ERROR XFormsServer   -  xfroms-submit-error - setting throwable
{throwable : "
                          ERROR XFormsServer   -

--
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].