log4jdbc Setup

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

log4jdbc Setup

guy_usi
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: 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].
Reply | Threaded
Open this post in threaded view
|

Re: log4jdbc Setup

Alessandro  Vernet
Administrator
Hi Guy,

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


- 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 <[hidden email]> 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: 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 [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: log4jdbc Setup

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

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


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


<a imageanchor="1" href="about:invalid#zClosurez" style="margin-left: 1em; margin-right: 1em;">Actions Editor - Service Response.JPG


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" target="_blank" rel="nofollow" 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 <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="_rT4f89EDAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">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 <a href="javascript:" target="_blank" gdf-obfuscated-mailto="_rT4f89EDAAJ" 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="_rT4f89EDAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">orb...@....

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

Re: log4jdbc Setup

Alessandro  Vernet
Administrator
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 <[hidden email]> wrote:
Thanks for the quick reply. Yes, I was actually following that document. Here's the screen snaps:

DB Service Editor.JPG


Actions Editor.JPG


Actions Editor - Service Response.JPG


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.


- 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 <[hidden email]> 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: 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 [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 [hidden email].
To post to this group, send email to [hidden email].
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: log4jdbc Setup

guy_usi
No luck. 

Has anyone successfully used the "log4jdbc" program to capture JDBC to log files?


Thanks,

Guy


On Sunday, August 12, 2018 at 12:47:48 PM UTC-4, Alessandro Vernet wrote:
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:

DB Service Editor.JPG


Actions Editor.JPG


Actions Editor - Service Response.JPG


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

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

Re: log4jdbc Setup

Erik Bruchez
Administrator
log4jdbc is quite old and I am not sure it is a good recommendation anymore.

Can you see, at your database level, whether there is at least an incoming
query?

We should provide better ways to debug services. I entered an issue to track
that:

    https://github.com/orbeon/orbeon-forms/issues/3674


-Erik

--
Sent from: 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].
Reply | Threaded
Open this post in threaded view
|

Re: log4jdbc Setup

guy_usi
Thanks for submitting the enhancement request.

I was able to figure out how to see what is executing on the SQL Server.
There are no connections being made from Orbeon. My simple Java program is
showing up.

I suspect I don't have the JDBC setup properly in Tomcat. I'll need to
figure out how to test via Tomcat. If you have any insight that'd be great.


Thanks,

Guy

--
Sent from: 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].
Reply | Threaded
Open this post in threaded view
|

Re: log4jdbc Setup

guy_usi
OK, I got Tomcat integrated into my Eclipse environment and then wrote a
small Java servlet (my first!) to validate that JDBC is set up and working.
It uses the same server.xml setup that is recommended in the Orbeon
installation manual.

I have had success so that would indicate that JDBC is running. When I run
Form Builder and test my form, I still do *NOT* get any data.

I'm evaluating whether I purchase this product and at this point am
frustrated by the fact I cannot fully test. Is there another support
mechanism other than this forum for people that are evaluating the product?
I can't go back and forth and hope I get an answer. I'd hate to pass up what
appears to be a solid product because I can't fully test (readily admit it's
probably some incorrect setting somewhere that I made).

--
Sent from: 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].
Reply | Threaded
Open this post in threaded view
|

Re: log4jdbc Setup

Erik Bruchez
Administrator
For reference, we handled this offline.

-Erik

--
Sent from: 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].