SQL debug problem to populate a dropdown

Hi,

I wonder how I could trouble shoot the connection to the database. I have
setup the database connection in context.xml (not server.xml) and then I
have defined the database service and actions in order to populate a drop
down after the controls has loaded with the appropriate itemset values. I
have also turned on logging for the SQL parser

   <category name="org.orbeon.oxf.processor.sql.SQLProcessor">
        <priority value="debug"/>
    </category>

But I can't see in the orbeon.log file when the connection or the SQL
statement is done. Is there a way to try the DB connection in a simple
manner within orbeon or where in the log file can I see the connection and
statements that are issued to the database?

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

Hi Filip,

In cases like this, I'd recommend you check the `orbeon.log`. If the
connection fails, you should have some information there telling you more
about the reason. You'll let us know if you find something useful in the
`orbeon.log`. Talking of which, you might also find the information on the
page linked below useful.

https://doc.orbeon.com/configuration/troubleshooting/orbeon-log

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
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].

Hi,

The problem was resolved after publishing the form, and not just testing it
in the form builder. After publishing the log showed the SQL statements.
Maybe this is correct that testing is not actually taking care of the
database services or the logging was not considered correctly.



--
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 orbeon+unsubscribe@googlegroups.com.
To post to this group, send email to orbeon@googlegroups.com.

OK, excellent Filip. I'm glad everything is working out when the form is
published.

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
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].