not able to connect the mysql database wth orbeon ........

classic Classic list List threaded Threaded
25 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: Help on implementing some future features

Alessandro  Vernet
Administrator
Han,

At this point, we don't yet have documentation describing how you can
provide your own buttons in Form Runner. But in essence, you'll edit
your form (if from Form Builder, in the bar, under Advanced, Edit
Source), and under the <fr:body> (i.e. after the closing tag
</fr:body>), you'll add something along these lines:

<fr:bottom>
    <fr:buttons-bar>
        <fr:buttons>
            <fr:button>
                <xforms:label>My button</xforms:label>
                <xforms:action ev:event="DOMActivate">...</xforms:action>
            </fr:button>
        </fr:buttons>
    </fr:buttons-bar>
</fr:bottom>

This opens to you all the power of XForms, but of course requires you
to know more about XForms.

Alex

On Monday, August 2, 2010, Han Ming Low <[hidden email]> wrote:

> Hi Alex,
>
> Thanks for the reply.
>
> I understand there is no through documentation on this.
>
> However, is there any notes to mention about customize button and visibility rules?
>
> Thanks.
>
>
> Han Ming
>
>
>
> On Sat, Jul 31, 2010 at 9:44 AM, Alessandro Vernet <[hidden email]> wrote:
> Han,
>
> I would do all this with one  Form Builder form. What you describe as
> being on form 1, 2, and 3 would be on different sections of that Form
> Builder form. You would have visibility rules determining what section
> to show when, and implement your custom buttons to go from one section
> to the next, with only one section visible at any given time. I know
> you would need more information on this to be able to do it, and
> unfortunately I don't have the time right now to really document this
> thoroughly - sorry about that!
>
> Alex
>
>
>
> On Thu, Jul 29, 2010 at 9:19 PM, Han Ming Low <[hidden email]> wrote:
>> Alex,
>>
>> Thanks for explaining.
>>
>> What I'd like to achieve, is for example, I would like to create a series of
>> forms for company registration.
>> 1st form will let the user to enter personal particular, then when he
>> submits, it will show the 2nd form.
>> The 2nd form will let the user to enter the company particular, then when he
>> submits, this time instead going directly to 3rd form, it will be submitted
>> to a backend servlet to do some backend validation and then forward the
>> request to the 3rd form url.
>> So, the information of the 1st, 2nd, 3rd form should be captured as linked
>> in some ways.
>>
>> Is this possible?
>>
>> I understand that the 1st to 2nd form submission may be merged as a tab
>> form, but would just like to see the possiblity of achieving it.
>>
>> And, as I'm writing this example, just thought of a problem, which is, what
>> if the backend validation fails and send back to the form 2?
>> Thanks a lot for your patience in answering to all the queries.
>>
>>
>>
>> Han Ming
>>
>>
>> On Fri, Jul 30, 2010 at 9:11 AM, Alessandro Vernet <[hidden email]>
>> wrote:
>>>
>>> Han,
>>>
>>> Let me precise what I said: you *can* have the instance containing the
>>> data entered by users posted to another page using the workflow-send.
>>> See:
>>>
>>>
>>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button
>>>
>>> However, the code getting the initial instance expects the XML
>>> document to be posted differently (base64 encoded in a request
>>> parameter, instead of the XML being in the body). And even if you
>>> could get form B to receive the instance from form A, the XML
>>> documents for A and B would need to have exactly the same format,
>>> which would limit the application of this technique. Maybe you can
>>> tell us what you'd like to achieve, at a higher level.
>>>
>>> Alex
>>>
>>> On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:
>>> > Hi Alex,
>>> >
>>> > Thanks for the reply and clarification on my misunderstanding.  :p
>>> >
>>> > I will need to read up more on it.
>>> >
>>> > Can I ask if I would like to implement some simple page flow, does it
>>> > means
>>> > that it can be achieved by changing the config to
>>> > 1) post the form data to the url of a second form
>>> > 2) allow the 2nd form to receive data as initial instance
>>> >
>>> > As you mentioned that submitting XML is not implemented yet, but I
>>> > "thought"
>>> > I have created a submit button on a Form Builder's form by editing the
>>> > source through the Edit source menu to define a button with
>>> > xforms:submission to post to another form url
>>> > e.g.
>>> > http://localhost:8080/orbeon/fr/test/Form2/new
>>> >
>>> > By the same token, does it means for the submitting XML to work, I will
>>> > need
>>> > to edit th
--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Re: Help on implementing some future features

Han Ming Low
Hi Alex,
 
Thanks for the tip.
 
Will look into the details of it.
 
I think I understand what is required to be done.
 
Just refering to an earlier note when I say I wish to have Form B to receive Form A data as an data instance.
Since you mentioned that in order for that to happen, Form B need to receive a base64 encoded request parameter but Form A is sending an XML.
So, I'm just thinking if I can write a servlet filter to convert any xml posted to a 64base encoded request parameter to satisfy the condition.
 
In any case, will be good to try it out.
 
Cheers.
 
 
Han Ming

On Fri, Aug 6, 2010 at 8:49 AM, Alessandro Vernet <[hidden email]> wrote:
Han,

At this point, we don't yet have documentation describing how you can
provide your own buttons in Form Runner. But in essence, you'll edit
your form (if from Form Builder, in the bar, under Advanced, Edit
Source), and under the <fr:body> (i.e. after the closing tag
</fr:body>), you'll add something along these lines:

<fr:bottom>
   <fr:buttons-bar>
       <fr:buttons>
           <fr:button>
               <xforms:label>My button</xforms:label>
               <xforms:action ev:event="DOMActivate">...</xforms:action>
           </fr:button>
       </fr:buttons>
   </fr:buttons-bar>
</fr:bottom>

This opens to you all the power of XForms, but of course requires you
to know more about XForms.

Alex

On Monday, August 2, 2010, Han Ming Low <[hidden email]> wrote:
> Hi Alex,
>
> Thanks for the reply.
>
> I understand there is no through documentation on this.
>

> However, is there any notes to mention about customize button and visibility rules?
>
> Thanks.
>
>
> Han Ming
>
>
>
> On Sat, Jul 31, 2010 at 9:44 AM, Alessandro Vernet <[hidden email]> wrote:
> Han,
>
> I would do all this with one  Form Builder form. What you describe as
> being on form 1, 2, and 3 would be on different sections of that Form
> Builder form. You would have visibility rules determining what section
> to show when, and implement your custom buttons to go from one section
> to the next, with only one section visible at any given time. I know
> you would need more information on this to be able to do it, and
> unfortunately I don't have the time right now to really document this
> thoroughly - sorry about that!
>
> Alex
>
>
>
> On Thu, Jul 29, 2010 at 9:19 PM, Han Ming Low <[hidden email]> wrote:
>> Alex,
>>
>> Thanks for explaining.
>>
>> What I'd like to achieve, is for example, I would like to create a series of
>> forms for company registration.
>> 1st form will let the user to enter personal particular, then when he
>> submits, it will show the 2nd form.
>> The 2nd form will let the user to enter the company particular, then when he
>> submits, this time instead going directly to 3rd form, it will be submitted
>> to a backend servlet to do some backend validation and then forward the
>> request to the 3rd form url.
>> So, the information of the 1st, 2nd, 3rd form should be captured as linked
>> in some ways.
>>
>> Is this possible?
>>
>> I understand that the 1st to 2nd form submission may be merged as a tab
>> form, but would just like to see the possiblity of achieving it.
>>
>> And, as I'm writing this example, just thought of a problem, which is, what
>> if the backend validation fails and send back to the form 2?
>> Thanks a lot for your patience in answering to all the queries.
>>
>>
>>
>> Han Ming
>>
>>
>> On Fri, Jul 30, 2010 at 9:11 AM, Alessandro Vernet <[hidden email]>
>> wrote:
>>>
>>> Han,
>>>
>>> Let me precise what I said: you *can* have the instance containing the
>>> data entered by users posted to another page using the workflow-send.
>>> See:
>>>
>>>
>>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button
>>>
>>> However, the code getting the initial instance expects the XML
>>> document to be posted differently (base64 encoded in a request
>>> parameter, instead of the XML being in the body). And even if you
>>> could get form B to receive the instance from form A, the XML
>>> documents for A and B would need to have exactly the same format,
>>> which would limit the application of this technique. Maybe you can
>>> tell us what you'd like to achieve, at a higher level.
>>>
>>> Alex
>>>
>>> On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:
>>> > Hi Alex,
>>> >
>>> > Thanks for the reply and clarification on my misunderstanding.  :p
>>> >
>>> > I will need to read up more on it.
>>> >
>>> > Can I ask if I would like to implement some simple page flow, does it
>>> > means
>>> > that it can be achieved by changing the config to
>>> > 1) post the form data to the url of a second form
>>> > 2) allow the 2nd form to receive data as initial instance
>>> >
>>> > As you mentioned that submitting XML is not implemented yet, but I
>>> > "thought"
>>> > I have created a submit button on a Form Builder's form by editing the
>>> > source through the Edit source menu to define a button with
>>> > xforms:submission to post to another form url
>>> > e.g.
>>> > http://localhost:8080/orbeon/fr/test/Form2/new
>>> >
>>> > By the same token, does it means for the submitting XML to work, I will
>>> > need
>>> > to edit th

--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: not able to connect the mysql database wth orbeon ........

vidhyanatarajan
In reply to this post by karthik Jayaraman
hi karthik ,
    This is srividhya, am working on orbeon and i want to clarify one thing in Orbeon how the validations are to be done at server side. For validations they are using xml schema and some validations are done through xforms bind and my question is how the orbeon server handles the validation at server side, is  they are using some libraries for validation at server side?

  


From: karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]>
To: vidhyanatarajan <[hidden email]>
Sent: Monday, 26 July 2010 10:02 AM
Subject: Re: not able to connect the mysql database wth orbeon ........

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

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!


View message @ http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p2301897.html
To unsubscribe from not able to connect the mysql database wth orbeon ........, click here.



Reply | Threaded
Open this post in threaded view
|

Re: not able to connect the mysql database wth orbeon ........

gaurav
In reply to this post by karthik Jayaraman
hi karthik Jayaraman,
i am trying to connect  mysql database with orbeon forms,but i cant do so due to existing mapping with the default database of orbeon that is eXist DB,
please guide me how to disconnect the connection between eXist DB and create a new connection with mysql,
and i am using JBoss 6.1 so please say me the name of the xml file equivalent to conf.xml of tomcat
Reply | Threaded
Open this post in threaded view
|

Re: Re: not able to connect the mysql database wth orbeon ........

Erik Bruchez
Administrator
For doc on the MySQL persistence layer:

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/oracle-and-mysql-persistence-layers

Configuration is largely done via properties. See:

http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties

-Erik

On Mon, Nov 19, 2012 at 8:55 PM, gaurav <[hidden email]> wrote:

> hi karthik Jayaraman,
> i am trying to connect  mysql database with orbeon forms,but i cant do so
> due to existing mapping with the default database of orbeon that is eXist
> DB,
> please guide me how to disconnect the connection between eXist DB and create
> a new connection with mysql,
> and i am using JBoss 6.1 so please say me the name of the xml file
> equivalent to conf.xml of tomcat
>
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p4655996.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
12