Form runner not populating control values from DB

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

Form runner not populating control values from DB

praveen.tyagi

Hi,

 

I have an requirement where in,

 

I have a template  where on click on a particular control, brings data from database(Mysql) and populates the fields on

Template, then I should be able to generate PDF of template using PDF button on form runner.  

 

To achieve this,

 

#  I have designed a template(Form)  using form builder which have DataBaseService(pointing to jndi datasource)/Action defined for the form,

 

Template is having minimal three fields,

 

#  A button, on click of which database service is called

#  A SingleLineText control which is used to pass parameter for database service.

#  A SingleLineText control which is used to present the value returned from the database service.

 

On placing value in input control, the output control is not getting populated after

clicking the the button to invoke database service.

 

I am not getting error as well,

 

The below is snapshot of orbeon logs on doing above action.

 

2009-08-10 15:54:05,131 INFO  ProcessorService  - /xforms-server - Received request

2009-08-10 15:54:05,162 INFO  ProcessorService  - /fr/service/custom/orbeon/database - Received request

2009-08-10 15:54:05,240 INFO  DatabaseContext  - Committing JDBC connection for datasource: jdbc/test.

2009-08-10 15:54:05,240 INFO  ProcessorService  - /fr/service/custom/orbeon/database - Timing: 78 - Cache hits for cache.main: 472, fault: 2, adds: 0, expirations: 0, success rate: 99%

2009-08-10 15:54:05,287 WARN  XFormsServer  - XForms -     function - Instance not found with xxforms:instance() function {instance id: "fr-uuid"}

2009-08-10 15:54:05,287 WARN  XFormsServer  - XForms -     function - Instance not found with xxforms:instance() function {instance id: "fr-save-locally-file-name"}

2009-08-10 15:54:05,318 INFO  ProcessorService  - /xforms-server - Timing: 187 - Cache hits for cache.main: 24, fault: 1, adds: 0, expirations: 0, success rate: 96%

 

Based on above logs can anyone point to the issue,

 

Would appreciate any help,

 

Regards,

Praveen

 

 

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.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
Reply | Threaded
Open this post in threaded view
|

Re: Form runner not populating control values from DB

Alessandro Vernet
Administrator
Praveen,

praveen.tyagi wrote
The below is snapshot of orbeon logs on doing above action.
[...]
There isn't much in this log. Can you try to enable the debug logging for XFormsServer by uncommenting the following lines in config/log4j.xml (you'll need to restart Tomcat after changing this file):

<category name="org.orbeon.oxf.xforms.processor.XFormsServer">
    <priority value="debug"/>
</category>

With this more information should be logged if the submission fails.

Alex