RE: Anyway in JDBC to dectect if DB supports pre-co mpilation

Not always. PreparedStatements can be created on the fly from any
select/update/insert query and as such can return rows (something that
functions can't). They also only live the length of the query.

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

-----Original Message-----
From: Joseph Shraibman [mailto:jks(at)selectacast(dot)net]
Sent: Monday, July 24, 2000 8:58 PM
To: Peter Mount
Cc: george stewart; Interfaces
Subject: Re: [INTERFACES] Anyway in JDBC to dectect if DB supports
pre-compilation

Isn't creating a function the same as precompiling?

Peter Mount wrote:
>
> No. as the backend doesn't currently supports it. As soon as it does, it
> will do.
>
> PreparedStatement is currently handled purely by the JDBC driver. As soon
as
> "pre-compilation" is supported, then the performance improvement would be
> immense.
>
> Peter
>
> --
> Peter T Mount peter(at)retep(dot)org(dot)uk, peter(at)retepdigital(dot)com,
me(at)petermount(dot)com
> Homepage: http://www.retep.org.uk Contact details @ http://petermount.com
> PostgreSQL JDBC: http://www.retep.org.uk/postgres/
> Java PDF generator: http://www.retep.org.uk/pdf/
>
> ----- Original Message -----
> From: george stewart <georgestewartiv(at)yahoo(dot)com>
> To: Interfaces <pgsql-interfaces(at)postgresql(dot)org>
> Sent: Sunday, July 23, 2000 10:52 PM
> Subject: [INTERFACES] Anyway in JDBC to dectect if DB supports
> pre-compilation
>
> Sorry for slightly off-topic, but is there some way in
> JDBC to detect if the connection supports
> pre-compilation of prepared statements.
>
> Regards, george
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/