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

[Michael P. <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