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

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

Hello,

thanks Michael for your quick reply. However, continuing the tests,
the problem appears wider than table creation (issues appears aswell
when creating the test case indexes). The client (even hosted on very
same server and connecting through 127.0.0.1) still complains about
loosing connection.
I did some workaround by executing the creation scripts through local
coordinator (psql), which runs ok - that gives an argument to your
point.

I'll patch the version I use (the git May 13th one) and give you feedback asap.

If I could be of any help regarding jdbc testing, let me know.

Regards

Lionel FRACHON
---------------------
Database Administrator
Open Source Team Leader
THALES - Critical Information Systems


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
>