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@selectacast.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@retep.org.uk, peter@retepdigital.com,
me@petermount.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@yahoo.com>
> To: Interfaces <pgsql-interfaces@postgresql.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/