log4jdbc Setup

<a imageanchor="1" href="about:invalid#zClosurez" style="margin-left: 1em; margin-right: 1em;">

<a imageanchor="1" href="about:invalid#zClosurez" style="margin-left: 1em; margin-right: 1em;">

<a imageanchor="1" href="about:invalid#zClosurez" style="margin-left: 1em; margin-right: 1em;">

I have tested through a small Java program in Eclipse that I can indeed reach the database and retrieve data with the SQL above. So I'm pretty sure that I have the server.xml properly set up.

Guy

Thank you for the screenshots, Guy.  In the Service Response Actions tab of the Actions Editor dialog, can you try changing the references to the column names to be all in lowercase, and replace the underscores by dashes? You'll let me know if this helps.

Alex

On Sun, Aug 12, 2018 at 1:32 PM <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="WpwwYmeSDAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">Guy.Wei...@uncommonschools.org> wrote:

Thanks for the quick reply. Yes, I was actually following that document. Here's the screen snaps:

I have tested through a small Java program in Eclipse that I can indeed reach the database and retrieve data with the SQL above. So I'm pretty sure that I have the server.xml properly set up.

Guy

On Saturday, August 11, 2018 at 1:05:54 PM UTC-4, Alessandro Vernet wrote:

Hi Guy,

I imagine that the documentation you are referring to is the one linked below.

<a href="https://doc.orbeon.com/form-builder/advanced/services-and-actions/database-services" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fdoc.orbeon.com%2Fform-builder%2Fadvanced%2Fservices-and-actions%2Fdatabase-services\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNE6dwydqPtlH-fVxdLFLqPnp3ltcg&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fdoc.orbeon.com%2Fform-builder%2Fadvanced%2Fservices-and-actions%2Fdatabase-services\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNE6dwydqPtlH-fVxdLFLqPnp3ltcg&#39;;return true;">https://doc.orbeon.com/form-builder/advanced/services-and-actions/database-services

- If you haven't gone through it already, I think you'll find this page useful.

- If you followed those steps but sill get an empty dropdown, could you attach a screenshot of your Database Service Editor dialog and another one for your Actions Editor dialog?

Alex

On Fri, Aug 10, 2018 at 11:55 PM guy_usi <guy.wei...@uncommonschools.org> wrote:

Onto the next issue: 

I have followed the Orbeon docs to set up a dropdown to receive data from my
database. When run in Test there is nothing populated. I'm not seeing
anything in the orbeon.log file (I uncommented the SQL processor line). I've
tried setting up log4jdbc and I'm able to get the log files created when I
start Tomcat, but nothing is going into the files. I have logging set at
"info".

In addition to downloading and installing log4jdbc I also installed slf4j as
was suggested on the log4jdbc site.

Again, don't know a lot about Java, Tomcat, etc so not really sure where to
start on debugging the setup. I suspect I don't have a .jar file in the
right location.

Anyone successfully use log4jdbc?


Thanks.

--
Sent from: <a href="http://discuss.orbeon.com/" rel="nofollow" target="_blank" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fdiscuss.orbeon.com%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF5V5zfD-87RVoalaG4cqO_RzdDcA&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fdiscuss.orbeon.com%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF5V5zfD-87RVoalaG4cqO_RzdDcA&#39;;return true;">http://discuss.orbeon.com/

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="WpwwYmeSDAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">orbeon+un...@googlegroups.com.
To post to this group, send email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="WpwwYmeSDAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">orb...@....