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(at)ic(dot)ac(dot)uk smacedo(at)inescn(dot)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