Re: [Postgres-xc-general] JDBC driver for 0.9.4

[Lionel F. <lio...@gm...>]

Good news, as far as I see, the patch is working ok ! :)

(Not reviewed the whole code to know if it meets the quality
criterias, but will keep it for now)

Lionel F.



2011/5/19 Michael Paquier <mic...@gm...>:
> This is a PGXC-side problem for sure, JDBC may not be involved.
> The fact is that we are currently having problems with JDBC driver like in
> bug 3299211 at table creation.
> The cause of that is we haven't done so many tests with it.
>
> Howver, we got a patch on the JDBC bug there. It has not yet been reviewed:
> http://sourceforge.net/tracker/?func=detail&aid=3299211&group_id=311227&atid=1310232
>
> If you try to apply it, does your problem disappear?
>
> On Thu, May 19, 2011 at 5:53 PM, Lionel Frachon <lio...@gm...>
> wrote:
>>
>> Hello,
>>
>> I'm trying to run BenchmarkSQL against a (for the moment) single node
>> on 0.9.4, however I face some connection issues.
>>
>> Running the create table script, here is what I get :
>>
>> ------------- ExecJDBC Start Date = Thu May 19 10:41:14 CEST
>> 2011-------------
>> driver=org.postgresql.Driver
>> conn=jdbc:postgresql://10.114.12.39:26001/testperfs
>> user=pgxc
>> password=******
>> commandFile=sqlTableCreates
>> -------------------------------------------------
>>
>>
>>
>> create table warehouse (
>> w_id        integer   not null,
>> w_ytd       decimal(12,2),
>> w_tax       decimal(4,4),
>> w_name      varchar(10),
>> w_street_1  varchar(20),
>> w_street_2  varchar(20),
>> w_city      varchar(20),
>> w_state     char(2),
>> w_zip       char(9)
>> );
>> -- SQL Success: Runtime = 33 ms --
>>
>> commit;
>> -- SQL Runtime Exception -----------------------------------------
>> DBMS SqlCode=0  DBMS Msg=
>>  Une erreur d'entrée/sortie a eu lieu lors d'envoi vers le serveur.
>> ------------------------------------------------------------------
>>
>>
>>
>> create table district (
>> d_w_id       integer       not null,
>> d_id         integer       not null,
>> d_ytd        decimal(12,2),
>> d_tax        decimal(4,4),
>> d_next_o_id  integer,
>> d_name       varchar(10),
>> d_street_1   varchar(20),
>> d_street_2   varchar(20),
>> d_city       varchar(20),
>> d_state      char(2),
>> d_zip        char(9)
>> );
>> -- SQL Runtime Exception -----------------------------------------
>> DBMS SqlCode=0  DBMS Msg=
>>  This connection has been closed.
>> ------------------------------------------------------------------
>>
>> and all the lasting table are not created, while the first one is.
>>
>> I updated the provided BenchmarkSQL jdbc driver (from
>> postgresql-8.0.309.jdbc3.jar to the latest
>> postgresql-9.0-801.jdbc3.jar) but no luck in this.
>>
>> What looks strange to me is
>> "
>> -- SQL Runtime Exception -----------------------------------------
>> DBMS SqlCode=0  DBMS Msg=
>>  Une erreur d'entrée/sortie a eu lieu lors d'envoi vers le serveur."
>>
>> (it means An I/O error occured while sending data to the server") but
>> the SqlCode is 0. I tried to remove the commit line, same effect.
>>
>> Is there any possibility to get debug info on this to know what's
>> happening, or have hints to the proper method (java libs on client
>> side, ....)
>>
>> Thanks for your help
>>
>> Regards.
>>
>> Lionel F.
>>
>
>
> --
> Michael Paquier
> http://michael.otacoo.com
>