| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
| Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bill Moran <wmoran(at)potentialtech(dot)com>, Vitalii Tymchyshyn <vit(at)tym(dot)im>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: JDBC behaviour |
| Date: | 2016-02-23 13:48:37 |
| Message-ID: | CAMsr+YEwDDCWgKFm2V1G5-sWY_P6MYiTLWs=z6fW1y0w50zyjg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
On 23 February 2016 at 12:06, Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com
> wrote:
>
> I mean, we will not change existing functionality/behavior/code as there
> may be dependency applications with same behavior
>
>
What you need to do is help test and review the patch that you've already
been sent links to. It will add a connection option that you can use to
control whether or not the driver does automatic savepoints. So you won't
have to change application code so long as the application gives you a way
to specify options in the JDBC URL or Properties dictionary. At least, not
because of that.
Go look at https://github.com/pgjdbc/pgjdbc/pull/477 . If you really want
to make progress, take that patch and add support for a JDBC URL connection
option then send a new pull request. With unit tests.
I am confident that automatic SAVEPOINTs are the *only* way you will get
the behaviour you want with PostgreSQL and PgJDBC.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2016-02-23 14:07:20 | Re: [HACKERS] JDBC behaviour |
| Previous Message | Robert Haas | 2016-02-23 13:34:17 | Re: [HACKERS] JDBC behaviour |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-02-23 13:51:59 | Re: Declarative partitioning |
| Previous Message | Craig Ringer | 2016-02-23 13:43:59 | Re: Writing new unit tests with PostgresNode |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2016-02-23 14:07:20 | Re: [HACKERS] JDBC behaviour |
| Previous Message | Robert Haas | 2016-02-23 13:34:17 | Re: [HACKERS] JDBC behaviour |