Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
Locked
Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
 
|
Hi,
I'm having some problem seeing the Forms and data I have captured after I changed the persistence layer to MySQL by following through the instruction at
The difference is that my app server is JBoss 4.2.3 instead of Tomcat.
What I did was
- run the table creation script
- create a mysql-ds,xml in my server/deploy folder with the jndi-name as "jdbc/mysql"
- update my web.xml and jboss-web.xml to tie up the jndi name "jdbc/mysql"
- update the orbeon.war\WEB-INF\resources\config\properties-local.xml with
<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>
<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/> With the changes, I can create new form and form data, and when I query the orbeon_form_data table, I do see the records created.
But one thing noted was, when I create a new form, the record is created in orbeon_form_data, not orbeon_form_definition as mentioned in the guide above.
And, more importantly, the data I have created is never shown on the summary
ie.
I create a new form data through - http://localhost:8080/orbeon/fr/orbeon/bookshelf/new
Saw the record in orbeon_form_data table
Nothing is listed in - http://localhost:8080/orbeon/fr/orbeon/bookshelf/summary
Any idea is greatly appreciated.
Thanks.
Han Ming
-- 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 |
Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
Administrator
|
Hi Han,
It is normal for the data to go to orbeon_form_data. Only forms that you create with Form Builder and then deploy go to orbeon_form_definition. Now what isn't normal is that you don't see the data when going to the summary page. Could you double check that if you save data from the bookshelf/new page, a new row is indeed added to orbeon_form_data? If it is, when you go to the bookshelf/summary page, to you see any error in orbeon.log? Alex On Wed, Jul 28, 2010 at 2:32 AM, Han Ming Low <[hidden email]> wrote: > Hi, > > I'm having some problem seeing the Forms and data I have captured after I > changed the persistence layer to MySQL by following through the instruction > at > http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer#TOC-Orbeon-Forms-setup > > The difference is that my app server is JBoss 4.2.3 instead of Tomcat. > > What I did was > - run the table creation script > - create a mysql-ds,xml in my server/deploy folder with the jndi-name as > "jdbc/mysql" > - update my web.xml and jboss-web.xml to tie up the jndi name "jdbc/mysql" > - update the orbeon.war\WEB-INF\resources\config\properties-local.xml with > <property as="xs:anyURI" > name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/> > <property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" > value="/fr/service/mysql"/> > With the changes, I can create new form and form data, and when I query the > orbeon_form_data table, I do see the records created. > But one thing noted was, when I create a new form, the record is created in > orbeon_form_data, not orbeon_form_definition as mentioned in the guide > above. > > And, more importantly, the data I have created is never shown on the summary > ie. > I create a new form data through - > http://localhost:8080/orbeon/fr/orbeon/bookshelf/new > Saw the record in orbeon_form_data table > Nothing is listed in - > http://localhost:8080/orbeon/fr/orbeon/bookshelf/summary > > Any idea is greatly appreciated. > > Thanks. > > > Han Ming > > -- > 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 |
Re: Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
|
|
Hi Alex,
Thanks for the reply.
I have done a check.
I think I'm quite sure that the data is inserted into the database.
On the other hand, although there is no error seen when I refresh the summary, there is some error from the startup and log file
The startup give this error
09:45:18,406 INFO [STDOUT] 09:45:18,406 INFO [WebAppContext] Initializing Resource Manager with: {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, [hidden email]}
09:45:18,421 ERROR [STDERR] Initializing Resource Manager with: {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, [hidden email]} While the orbeon.log give an error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION orbeon.extractValue does not exist
followed by stacktrace I suppose that is because I started Orbeon with the default database which created some functions, then I switch to a RDBMS which didn't have the function created?
Any ideas?
Thanks.
Han Ming
On Thu, Jul 29, 2010 at 8:34 AM, Alessandro Vernet <[hidden email]> wrote:
Hi Han, -- 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 |
Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
|
Administrator
|
Han,
The summary page uses the extractValue() SQL function, and from I see on the page linked below, this is supported starting with MySQL 5.1.5. Could it be that the version you have installed is older? http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html Alex On Wednesday, July 28, 2010, Han Ming Low <[hidden email]> wrote: > Hi Alex, > > Thanks for the reply. > > I have done a check. > > I think I'm quite sure that the data is inserted into the database. > On the other hand, although there is no error seen when I refresh the summary, there is some error from the startup and log file > The startup give this error > 09:45:18,406 INFO [STDOUT] 09:45:18,406 INFO [WebAppContext] Initializing Resource Manager with: {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, org.orbeon.oxf.resources.WebAppResourceManagerImplServletContext=org.apache.catalina.core.ApplicationContextFacade@14a8134} > 09:45:18,421 ERROR [STDERR] Initializing Resource Manager with: {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, org.orbeon.oxf.resources.WebAppResourceManagerImplServletContext=org.apache.catalina.core.ApplicationContextFacade@14a8134} > > While the orbeon.log give an error > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION orbeon.extractValue does not exist > followed by stacktrace > > I suppose that is because I started Orbeon with the default database which created some functions, then I switch to a RDBMS which didn't have the function created? > > Any ideas? > > Thanks. > > > Han Ming > > > On Thu, Jul 29, 2010 at 8:34 AM, Alessandro Vernet <[hidden email]> wrote: > Hi Han, > > It is normal for the data to go to orbeon_form_data. Only forms that > you create with Form Builder and then deploy go to > orbeon_form_definition. Now what isn't normal is that you don't see > the data when going to the summary page. Could you double check that > if you save data from the bookshelf/new page, a new row is indeed > added to orbeon_form_data? If it is, when you go to the > bookshelf/summary page, to you see any error in orbeon.log? > > Alex > > > > 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 |
Re: Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
|
|
Hi Alex,
Thanks for the reply.
This must be it.
I'm sorry that I didn't find it as I'm too engrossed in my googling orbeon and extractValue.
I will have to upgrade MySQL which has to take some effort as there are a bit of data there.
Thanks.
Han Ming
On Thu, Jul 29, 2010 at 11:50 AM, Alessandro Vernet <[hidden email]> wrote: Han, -- 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 |
Re: Re: Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
|
Administrator
|
Han,
No problem; I added a note about MySQL 5.1.5+ being needed for this in the MySQL persistence layer documentation. You'll let us know if it works for you after you upgrade. Alex On Thu, Jul 29, 2010 at 12:24 AM, Han Ming Low <[hidden email]> wrote: > Hi Alex, > > Thanks for the reply. > > This must be it. > > I'm sorry that I didn't find it as I'm too engrossed in my googling orbeon > and extractValue. > > I will have to upgrade MySQL which has to take some effort as there are a > bit of data there. > > Thanks. > > > Han Ming > > On Thu, Jul 29, 2010 at 11:50 AM, Alessandro Vernet <[hidden email]> > wrote: >> >> Han, >> >> The summary page uses the extractValue() SQL function, and from I see >> on the page linked below, this is supported starting with MySQL 5.1.5. >> Could it be that the version you have installed is older? >> >> http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html >> >> Alex >> >> On Wednesday, July 28, 2010, Han Ming Low <[hidden email]> wrote: >> > Hi Alex, >> > >> > Thanks for the reply. >> > >> > I have done a check. >> > >> > I think I'm quite sure that the data is inserted into the database. >> > On the other hand, although there is no error seen when I refresh the >> > summary, there is some error from the startup and log file >> > The startup give this error >> > 09:45:18,406 INFO [STDOUT] 09:45:18,406 INFO [WebAppContext] >> > Initializing Resource Manager with: >> > {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, >> > oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, >> > oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, >> > oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, >> > org.orbeon.oxf.resources.WebAppResourceManagerImplServletContext=org.apache.catalina.core.ApplicationContextFacade@14a8134} >> > 09:45:18,421 ERROR [STDERR] Initializing Resource Manager with: >> > {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, >> > oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, >> > oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, >> > oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, >> > org.orbeon.oxf.resources.WebAppResourceManagerImplServletContext=org.apache.catalina.core.ApplicationContextFacade@14a8134} >> > >> > While the orbeon.log give an error >> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION >> > orbeon.extractValue does not exist >> > followed by stacktrace >> > >> > I suppose that is because I started Orbeon with the default database >> > which created some functions, then I switch to a RDBMS which didn't have the >> > function created? >> > >> > Any ideas? >> > >> > Thanks. >> > >> > >> > Han Ming >> > >> > >> > On Thu, Jul 29, 2010 at 8:34 AM, Alessandro Vernet <[hidden email]> >> > wrote: >> > Hi Han, >> > >> > It is normal for the data to go to orbeon_form_data. Only forms that >> > you create with Form Builder and then deploy go to >> > orbeon_form_definition. Now what isn't normal is that you don't see >> > the data when going to the summary page. Could you double check that >> > if you save data from the bookshelf/new page, a new row is indeed >> > added to orbeon_form_data? If it is, when you go to the >> > bookshelf/summary page, to you see any error in orbeon.log? >> > >> > Alex >> > >> > >> > >> > >> >> -- >> 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 > > -- 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 |
Re: Re: Re: Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
|
|
Hi Alex,
Just to let you know that upgrading my database to ver 5.1.49 fix the problem.
Thanks.
Han Ming
On Fri, Jul 30, 2010 at 1:39 AM, Alessandro Vernet <[hidden email]> wrote: Han, -- 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 |
Re: Re: Re: Re: Re: Help : Not seeing data in Form Builder after configuring for MySQL Persistence Layer
|
Administrator
|
Han,
Great, thanks for confirming that it works after upgrading MySQL. Alex On Tue, Aug 3, 2010 at 2:39 AM, Han Ming Low <[hidden email]> wrote: > Hi Alex, > > Just to let you know that upgrading my database to ver 5.1.49 fix the > problem. > > Thanks. > > > Han Ming > > On Fri, Jul 30, 2010 at 1:39 AM, Alessandro Vernet <[hidden email]> > wrote: >> >> Han, >> >> No problem; I added a note about MySQL 5.1.5+ being needed for this in >> the MySQL persistence layer documentation. You'll let us know if it >> works for you after you upgrade. >> >> Alex >> >> On Thu, Jul 29, 2010 at 12:24 AM, Han Ming Low <[hidden email]> >> wrote: >> > Hi Alex, >> > >> > Thanks for the reply. >> > >> > This must be it. >> > >> > I'm sorry that I didn't find it as I'm too engrossed in my googling >> > orbeon >> > and extractValue. >> > >> > I will have to upgrade MySQL which has to take some effort as there are >> > a >> > bit of data there. >> > >> > Thanks. >> > >> > >> > Han Ming >> > >> > On Thu, Jul 29, 2010 at 11:50 AM, Alessandro Vernet <[hidden email]> >> > wrote: >> >> >> >> Han, >> >> >> >> The summary page uses the extractValue() SQL function, and from I see >> >> on the page linked below, this is supported starting with MySQL 5.1.5. >> >> Could it be that the version you have installed is older? >> >> >> >> http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html >> >> >> >> Alex >> >> >> >> On Wednesday, July 28, 2010, Han Ming Low <[hidden email]> wrote: >> >> > Hi Alex, >> >> > >> >> > Thanks for the reply. >> >> > >> >> > I have done a check. >> >> > >> >> > I think I'm quite sure that the data is inserted into the database. >> >> > On the other hand, although there is no error seen when I refresh the >> >> > summary, there is some error from the startup and log file >> >> > The startup give this error >> >> > 09:45:18,406 INFO [STDOUT] 09:45:18,406 INFO [WebAppContext] >> >> > Initializing Resource Manager with: >> >> > >> >> > {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, >> >> > >> >> > oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, >> >> > >> >> > oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, >> >> > >> >> > oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, >> >> > >> >> > org.orbeon.oxf.resources.WebAppResourceManagerImplServletContext=org.apache.catalina.core.ApplicationContextFacade@14a8134} >> >> > 09:45:18,421 ERROR [STDERR] Initializing Resource Manager with: >> >> > >> >> > {oxf.resources.priority.1.oxf.resources.webapp.rootdir=/WEB-INF/resources, >> >> > >> >> > oxf.resources.factory=org.orbeon.oxf.resources.PriorityResourceManagerFactory, >> >> > >> >> > oxf.resources.priority.2=org.orbeon.oxf.resources.ClassLoaderResourceManagerFactory, >> >> > >> >> > oxf.resources.priority.1=org.orbeon.oxf.resources.WebAppResourceManagerFactory, >> >> > >> >> > org.orbeon.oxf.resources.WebAppResourceManagerImplServletContext=org.apache.catalina.core.ApplicationContextFacade@14a8134} >> >> > >> >> > While the orbeon.log give an error >> >> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION >> >> > orbeon.extractValue does not exist >> >> > followed by stacktrace >> >> > >> >> > I suppose that is because I started Orbeon with the default database >> >> > which created some functions, then I switch to a RDBMS which didn't >> >> > have the >> >> > function created? >> >> > >> >> > Any ideas? >> >> > >> >> > Thanks. >> >> > >> >> > >> >> > Han Ming >> >> > >> >> > >> >> > On Thu, Jul 29, 2010 at 8:34 AM, Alessandro Vernet >> >> > <[hidden email]> >> >> > wrote: >> >> > Hi Han, >> >> > >> >> > It is normal for the data to go to orbeon_form_data. Only forms that >> >> > you create with Form Builder and then deploy go to >> >> > orbeon_form_definition. Now what isn't normal is that you don't see >> >> > the data when going to the summary page. Could you double check that >> >> > if you save data from the bookshelf/new page, a new row is indeed >> >> > added to orbeon_form_data? If it is, when you go to the >> >> > bookshelf/summary page, to you see any error in orbeon.log? >> >> > >> >> > Alex >> >> > >> >> > >> >> > >> >> > >> >> >> >> -- >> >> 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 >> > >> > >> >> >> >> -- >> 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 > > -- 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 |
«
Return to Orbeon Forms community mailing list
|
1 view|%1 views
| Free forum by Nabble | Edit this page |