Re: [Postgres-xc-developers] [JDBC Regression] Fix for XC does not support serializable transactions

[Koichi S. <koi...@gm...>]

I'm afraid we have an issue in REPEATABLE_READ too.   Do you need to
support REPEATABLE_READ as well?   We may need some more test for this.

Regards;
---
Koichi Suzuki


2013/8/5 Abbas Butt <abb...@en...>

>
>
> On Mon, Aug 5, 2013 at 2:18 PM, Masataka Saito <pg...@gm...> wrote:
>
>> The patch will work fine.
>>
>> But this is my basal question:
>> setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE) after XC
>> block doesn't raise an exception, I know.
>> Is it right shelving unsupported isolation level without an error?
>>
>
> It is due to already checked in code
>
> void
> assign_XactIsoLevel(const char *newval, void *extra)
> {
>     XactIsoLevel = *((int *) extra);
> #ifdef PGXC
>     /*
>      * PGXCTODO - PGXC does not support 9.1 serializable transactions yet
>      */
>     if (XactIsoLevel == XACT_SERIALIZABLE)
>         XactIsoLevel = XACT_REPEATABLE_READ;
> #endif
> }
>
> I think we already have a source forge ticket to deal with this XC
> limitation.
>
>
>
>>
>> On Fri, Aug 2, 2013 at 4:36 PM, Abbas Butt <abb...@en...>
>> wrote:
>> > Hi,
>> > PFA patch to make sure that JDBC regression skips tests for serializable
>> > transactions.
>> >
>> > --
>> > Abbas
>> > Architect
>> >
>> > Ph: 92.334.5100153
>> > Skype ID: gabbasb
>> > www.enterprisedb.com
>> >
>> > Follow us on Twitter
>> > @EnterpriseDB
>> >
>> > Visit EnterpriseDB for tutorials, webinars, whitepapers and more
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Get your SQL database under version control now!
>> > Version control is standard for application code, but databases havent
>> > caught up. So what steps can you take to put your SQL databases under
>> > version control? Why should you start doing it? Read more to find out.
>> >
>> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
>> > _______________________________________________
>> > Postgres-xc-developers mailing list
>> > Pos...@li...
>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>> >
>>
>
>
>
> --
> --
> *Abbas*
>  Architect
>
> Ph: 92.334.5100153
>  Skype ID: gabbasb
> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
> *
> Follow us on Twitter*
> @EnterpriseDB
>
> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community>and more<http://www.enterprisedb.com/resources-community>
>
>
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent
> caught up. So what steps can you take to put your SQL databases under
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>