[Postgres-xc-general] JDBC driver for 0.9.4

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

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.