database support for orbeon
Locked
 
|
hi...
Am srividhya ...am developing form in orbeon technology...and i have build the sample form through orbe on form designer...now...i want to give database connection for form which i have developed through orbeon..... -- Srividhya... |
|
|
I am out of the office until 26th July *********************************************************************************************** This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents.
Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material.
Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards. *********************************************************************************************** The Stationery Office Limited is registered in England No. 3049649 at 10 Eastbourne Terrace, London, W2 6LG
|
Re: database support for orbeon
|
|
In reply to this post by vidhyanatarajan
I have used mysql with orbeon. I think the steps should be same for any DB.
Refer the following link for mysql support. I used Tomcat/Jboss/mysql/orbeon combo. 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! |
|
|
I am out of the office until 26th July *********************************************************************************************** This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents.
Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material.
Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards. *********************************************************************************************** The Stationery Office Limited is registered in England No. 3049649 at 10 Eastbourne Terrace, London, W2 6LG
|
Re: database support for orbeon
|
|
In reply to this post by karthik Jayaraman
|
|
|
I am out of the office until 26th July *********************************************************************************************** This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents.
Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material.
Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards. *********************************************************************************************** The Stationery Office Limited is registered in England No. 3049649 at 10 Eastbourne Terrace, London, W2 6LG
|
Re: database support for orbeon
|
|
In reply to this post by karthik Jayaraman
|
|
|
I am out of the office until 26th July *********************************************************************************************** This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents.
Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material.
Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards. *********************************************************************************************** The Stationery Office Limited is registered in England No. 3049649 at 10 Eastbourne Terrace, London, W2 6LG
|
Re: database support for orbeon
|
|
In reply to this post by vidhyanatarajan
If you follow the steps to achieve mysql support in orbeon, after you save and publish the form, there should be two entries in the database. One in orbeon_form_data and another in orbeon_form_definition.
Once you fill in the form and save it, another entry will be added in the orbeon_form_data table but this time the xml file also contains the value you entered in the form. Thus by parsing this entry, you can acheive the entered value. If this all seems too complicated for you (which i believe is not), 1. first make sure you follow the steps for using mysql support in orbeon. 2.Then create a sample form and save it and publish it ! See whether you have some entry in the database. Then you enter some value in the form and save it. 3. Then you can see a new entry in the database. Navigate to the xml column of the database and you will see that the whole form along with the entered values will be stored in the database. From that data you can use sax/dom parser to extract the required values. |
|
|
I am out of the office until 26th July *********************************************************************************************** This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents.
Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material.
Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards. *********************************************************************************************** The Stationery Office Limited is registered in England No. 3049649 at 10 Eastbourne Terrace, London, W2 6LG
|
| Free forum by Nabble | Edit this page |