Postgres Pro
Downloads
Home   >   mailing lists

Thread: JDBC improvements

JDBC improvements

From
"Nicolas Verger"
Date:
Hi,
We ( me and my teammate ) try to write a graphical client in Java.
We made our first stable version ( pgInhaler.ifrance.com for ones who want
to try it ...) and we need some JDBC features for next version :- catch EXPLAIN plan- cancel QUERY
Is it possible ?

Suggestions and fellings about this project will be welcome.

Nicolas.

Re: JDBC improvements

From
"Nicolas Verger"
Date:
> -----Message d'origine-----
> De : Barry Lind [mailto:barry@xythos.com]
> Nicolas,
>
> AFAIK you should be able to get the EXPLAIN plan from the jdbc driver.
> All INFO messages from the backend are treated as warnings by the jdbc
> driver.  If you do a getWarnings() you should be able to get the explain
> plan information.
>
> Cancel query is on the jdbc todo list.  However I don't know of anyone
> that plans to implement it.  So a patch that adds that functionality
> would be welcome.
>
> thanks,
> --Barry
>
>

Ok, the getWarnings() method works on the Connection but not on the Statment
nor ResultSet... Why ?
I look in the source and it's just a little patch to do it.
I'm not used in GPL licence so if I make this patch what may I do with it ?

I watched for cancel query too, and I may work on it too ...

Nicolas

Re: JDBC improvements

From
Bruce Momjian
Date:
> > Cancel query is on the jdbc todo list.  However I don't know of anyone
> > that plans to implement it.  So a patch that adds that functionality
> > would be welcome.
> >
> > thanks,
> > --Barry
> >
> >
>
> Ok, the getWarnings() method works on the Connection but not on the Statment
> nor ResultSet... Why ?
> I look in the source and it's just a little patch to do it.
> I'm not used in GPL licence so if I make this patch what may I do with it ?
>
> I watched for cancel query too, and I may work on it too ...

We are BSD license.  Is that what you meant?  Sure, send it over to jdbc
list or patches list.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: JDBC improvements

From
Bruce Momjian
Date:
Just send over the patch and we will add it for 7.3.

---------------------------------------------------------------------------

Nicolas Verger wrote:
> > -----Message d'origine-----
> > De : Barry Lind [mailto:barry@xythos.com]
> > Nicolas,
> >
> > AFAIK you should be able to get the EXPLAIN plan from the jdbc driver.
> > All INFO messages from the backend are treated as warnings by the jdbc
> > driver.  If you do a getWarnings() you should be able to get the explain
> > plan information.
> >
> > Cancel query is on the jdbc todo list.  However I don't know of anyone
> > that plans to implement it.  So a patch that adds that functionality
> > would be welcome.
> >
> > thanks,
> > --Barry
> >
> >
>
> Ok, the getWarnings() method works on the Connection but not on the Statment
> nor ResultSet... Why ?
> I look in the source and it's just a little patch to do it.
> I'm not used in GPL licence so if I make this patch what may I do with it ?
>
> I watched for cancel query too, and I may work on it too ...
>
> Nicolas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026