Re: PostgreSQL-JDBC correct URL

On Wed, 12 Apr 2000, Haroldo Stenger wrote:
> Now I need help in finding:

Hello to you too. :)


>     - I need to track the queries that the backend receives, so that I can
> see what GeneXus is sending to PostgreSQL.

http://www.postgresql.org/docs/admin/pg-options.htm


>
>     - A list of the errors of the backend, _WITH_ the numbers, not only the
> texts.

Try to print the SQLException and SQLWarning descriptions
using e.getMessage()  and e.getSQLState()

This and the tip above should give you enough info.

I don't know what error codes you are talking - if you mean the ones
returned by getErrorCode() at the JDBC level, getMessage will help you for
sure. If you mean others, at backend level (?), I don't know.

Also, I usually have my own software printing the SQL queries during debug
time (before they are sent, if they are not PreparedStatement s)

>
> I coudn't find this info in the doc, either. Any Ideas? Thanks in
> advance.
> > Did you read them ?!
> No, because the driver has no documentation, or I couldn't find it.

http://www.postgresql.org/docs/programmer/jdbc.htm

or better, one of the mirrors .


Good Work!


--
``````````` Silvio Emanuel Nunes Barbosa de Macedo (PhD Std) '''''''''''''
smacedo@ic.ac.uk                                         smacedo@inescn.pt
Intelligent and Interactive Systems                Telecom. and Multimedia
Imperial College, University of London                         INESC Porto
Exhibition Road,                                       Pc da Republica, 93
London SW7 2AZ, England                            4050-497 Porto Portugal
Tel:+44 171 5946323                                    Tel:+351 22 2094220