ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

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

ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

paleandromus
I have installed orbeon 3.7.1 in jboss 4.2.2 and tomcat 5.5.29. If I use as persistance layer Oracle*, all works fine, but if I use as persistence layer MySQL 5.1 (driver mysql-connector-java-5.1.12-bin.jar) then appears this error when retrieving lists (forms, book, ...), in both servers:
ERROR XFormsServer  - XForms - submission - xforms-submit-error throwable: org.orbeon.oxf.xforms.XFormsModelSubmission$XFormsSubmissionException: line 24 of oxf:/config/xforms-widgets.xsl (processing instance replacement): Body received with non-XML media type for replace="instance": text/html
oxf:/config/xforms-widgets.xsl, line 24, column -1: Body received with non-XML media type for replace="instance": text/htm
Any idea why could appear this error? Regards. * Working with jboss 4.2.2 is necesary to change SQLProcessorOracleTomcat4Delegate class as is commented is this thread: http://orbeon-forms-ops-users.24843.n4.nabble.com/Problem-saving-data-from-Orbeon-to-Oracle-if-server-is-JBoss-no-problem-in-Tomcat-td2173417.html#a2173417
Reply | Threaded
Open this post in threaded view
|

Re: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

Alessandro  Vernet
Administrator
We would need more info to be able to help with this. What is it
you're doing with MySQL? If you're using Form Builder / Form Runner,
then it is normal as the support for MySQL is new in 3.8.

Alex

On Fri, Jul 9, 2010 at 7:06 AM, paleandromus <[hidden email]> wrote:

> I have installed orbeon 3.7.1 in jboss 4.2.2 and tomcat 5.5.29. If I use as
> persistance layer Oracle*, all works fine, but if I use as persistence layer
> MySQL 5.1 (driver mysql-connector-java-5.1.12-bin.jar) then appears this
> error when retrieving lists (forms, book, ...), in both servers:
>
> ERROR XFormsServer  - XForms - submission - xforms-submit-error throwable:
> org.orbeon.oxf.xforms.XFormsModelSubmission$XFormsSubmissionException: line
> 24 of oxf:/config/xforms-widgets.xsl (processing instance replacement): Body
> received with non-XML media type for replace="instance": text/html
> oxf:/config/xforms-widgets.xsl, line 24, column -1: Body received with
> non-XML media type for replace="instance": text/htm
>
> Any idea why could appear this error? Regards. * Working with jboss 4.2.2 is
> necesary to change SQLProcessorOracleTomcat4Delegate class as is commented
> is this thread:
> http://orbeon-forms-ops-users.24843.n4.nabble.com/Problem-saving-data-from-Orbeon-to-Oracle-if-server-is-JBoss-no-problem-in-Tomcat-td2173417.html#a2173417
> ________________________________
> View this message in context: ERROR XFormsServer with orbeon
> 3.7.1.200905272119 and MySQL
> 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
>
>


--
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: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

paleandromus
Alessandro Vernet wrote
We would need more info to be able to help with this. What is it
you're doing with MySQL? If you're using Form Builder / Form Runner,
then it is normal as the support for MySQL is new in 3.8.

Alex
Hello Alex,

I'm using Form Builder, but I thought that orbeon 3.7.1 supported MySQL as Persistance Layer... then, Is not possible to use MySQL with the Form Builder orbeon 3.7.1?, however there are classes and set-ups for use MySQL with orbeon 3.7.1, Is experimental for this versión?, Is possible to arrange it for work with MySQL in orbeon 3.7.1?

Thank you for your help and information, Alex.
Reply | Threaded
Open this post in threaded view
|

Re: Re: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

Alessandro  Vernet
Administrator
The support for MySQL in Form Runner is new in Orbeon Forms 3.8. See:

http://wiki.orbeon.com/forms/doc/developer-guide/release-orbeon-forms-38#TOC-Form-Runner-Improvements

Back porting this to 3.7 is not as simple as copying the files for the
MySQL persistence layer implementation, as changes were also made to
the SQL processor Java code. What would you need to be able to upgrade
to Orbeon Forms 3.8?

Alex

On Sat, Jul 10, 2010 at 7:47 AM, paleandromus <[hidden email]> wrote:

>
>
> Alessandro  Vernet wrote:
>>
>> We would need more info to be able to help with this. What is it
>> you're doing with MySQL? If you're using Form Builder / Form Runner,
>> then it is normal as the support for MySQL is new in 3.8.
>>
>> Alex
>>
>>
>
> Hello Alex,
>
> I'm using Form Builder, but I thought that orbeon 3.7.1 supported MySQL as
> Persistance Layer... then, Is not possible to use MySQL with the Form
> Builder orbeon 3.7.1?, however there are classes and set-ups for use MySQL
> with orbeon 3.7.1, Is experimental for this versión?, Is possible to arrange
> it for work with MySQL in orbeon 3.7.1?
>
> Thank you for your help and information, Alex.
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/ERROR-XFormsServer-with-orbeon-3-7-1-200905272119-and-MySQL-tp2283222p2284580.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
>
>


--
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: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

paleandromus
Alessandro Vernet wrote
The support for MySQL in Form Runner is new in Orbeon Forms 3.8. See:

http://wiki.orbeon.com/forms/doc/developer-guide/release-orbeon-forms-38#TOC-Form-Runner-Improvements

Back porting this to 3.7 is not as simple as copying the files for the
MySQL persistence layer implementation, as changes were also made to
the SQL processor Java code. What would you need to be able to upgrade
to Orbeon Forms 3.8?

Alex
Hello Alex,

We'are using only form builder feature to create xforms and store them in a database (we tryed with Oracle and MySQL, and finally the choose is MySQL because we don't need attachments and MySQL is a better option). So We don't need form runner or the rest of features, but form builder and form runner are bundled.

In Orbeon 3.7.1 all of the features are available to use for free, but we need one of them: Internationalization, to create multi languages forms that in Orbeon 3.8 is only available in the Professional Edition, and now we knows too that MySQL support is only available in Orbeon 3.8.

Orbeon 3.8 CE was sufficient for us if it supported Internationalization.

Is strange that Orbeon 3.7.1 supports Oracle as Persistence Layer but not supports MySQL, and in the other hand, Orbeon 3.8 CE supports MySQL but not supports Oracle (only in PE version).

Thanks for the reply, Alex.
Reply | Threaded
Open this post in threaded view
|

Re: Re: Re: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

Alessandro  Vernet
Administrator
I understand better. The Oracle support was available in Orbeon Forms
3.7 because there was no PE at the time. When we introduced Orbeon
Forms PE with 3.8, we chose the Oracle support would go in the PE, as
it is a more "enterprise" feature, which is general used by companies
who can afford a license to the PE, and thus can support the
development of Orbeon Forms.

Using 3.7 just because you need i18n in Form Builder is quite a
sacrifice, as there were a number of improvements done since then, and
you mihgt get stuck at 3.7. I would try to upgrade to the 3.8 PE, but
hey, I might be biases here ;) and this is of course your decision.

Alex

On Tue, Jul 13, 2010 at 1:06 AM, paleandromus <[hidden email]> wrote:

>
>
> Alessandro  Vernet wrote:
>>
>> The support for MySQL in Form Runner is new in Orbeon Forms 3.8. See:
>>
>> http://wiki.orbeon.com/forms/doc/developer-guide/release-orbeon-forms-38#TOC-Form-Runner-Improvements
>>
>> Back porting this to 3.7 is not as simple as copying the files for the
>> MySQL persistence layer implementation, as changes were also made to
>> the SQL processor Java code. What would you need to be able to upgrade
>> to Orbeon Forms 3.8?
>>
>> Alex
>>
>
> Hello Alex,
>
> We'are using only form builder feature to create xforms and store them in a
> database (we tryed with Oracle and MySQL, and finally the choose is MySQL
> because we don't need attachments and MySQL is a better option). So We don't
> need form runner or the rest of features, but form builder and form runner
> are bundled.
>
> In Orbeon 3.7.1 all of the features are available to use for free, but we
> need one of them: Internationalization, to create multi languages forms that
> in Orbeon 3.8 is only available in the Professional Edition, and now we
> knows too that MySQL support is only available in Orbeon 3.8.
>
> Orbeon 3.8 CE was sufficient for us if it supported Internationalization.
>
> Is strange that Orbeon 3.7.1 supports Oracle as Persistence Layer but not
> supports MySQL, and in the other hand, Orbeon 3.8 CE supports MySQL but not
> supports Oracle (only in PE version).
>
> Thanks for the reply, Alex.
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/ERROR-XFormsServer-with-orbeon-3-7-1-200905272119-and-MySQL-tp2283222p2287134.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
>
>


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

Out of Office AutoReply: Re: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

pappleby
Out of Office AutoReply: Re: ERROR XFormsServer with orbeon 3.7.1.200905272119 and MySQL

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