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

[Michael P. <mic...@gm...>]

I still need to review this patch.
Once it is corrected and committed, feel free to use the head.

On Thu, May 19, 2011 at 11:23 PM, Lionel Frachon
<lio...@gm...>wrote:

> 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
> >
>



-- 
Michael Paquier
http://michael.otacoo.com