Re: [GENERAL] Postgres 7.3b1 + JDBC3 (2002-09-05) truncates SQL

I can't reproduce this problem.  Can you submit a simple test case that
reproduces the problem?

thanks,
--Barry



H. Meyer wrote:
> hi
>
> i have a very wired problem.
> when i try to execute the following SQL command:
>
> INSERT INTO SERIES
>
(seriesDateTime,modality,seriesnumber,seriesinstanceuid,seriesdescr,bodypartexamined,slicethickness,sequencename,viewdirection,studytype,fieldofview,contrastAgent,numberseriesrelatedimages,manufacturermodel,stuParent,insertTimestamp)

> VALUES ('2002-05-07 14:34:12.0', 'MR', '2',
> '1.2.804.114118.1.20020507.143415.2812940098.1.1', 'SCRAPBOOK', '',
> '006.000000E+00', 'b0_1000', 'HEAD', 'MEA', '261*261', '', 0, 'MAGNETOM
> Harmony', '1.3.12.2.1107.5.2.5.10288.20020426150938000', '2002-09-17
> 11:07:30.293');
>
> via the JDBC3 beta driver for postgres 7.3b1 i get the following error.
>
> 2002-09-17 11:07:30 [24588]  LOG:  query: INSERT INTO SERIES
>
(seriesDateTime,modality,seriesnumber,seriesinstanceuid,seriesdescr,bodypartexamined,slicethickness,sequencename,viewdirection,studytype,fieldofview,contrastAgent,numberseriesrelatedimages,manufacturermodel,stuParent,insertTimestamp)

> VALUES ('2002-05-07 14:34:12.0', 'MR', '2',
> '1.2.804.114118.1.20020507.143415.2812940098.1.1', 'SCRAPBOOK
> 2002-09-17 11:07:30 [24588]  ERROR:  parser: unterminated quoted string
> at or near "'SCRAPBOOK" at character 349
> 2002-09-17 11:07:30 [24588]  LOG:  statement: INSERT INTO SERIES
>
(seriesDateTime,modality,seriesnumber,seriesinstanceuid,seriesdescr,bodypartexamined,slicethickness,sequencename,viewdirection,studytype,fieldofview,contrastAgent,numberseriesrelatedimages,manufacturermodel,stuParent,insertTimestamp)

> VALUES ('2002-05-07 14:34:12.0', 'MR', '2',
> '1.2.804.114118.1.20020507.143415.2812940098.1.1', 'SCRAPBOOK
>
> it seems as if the SQL command was truncated.
> i added and removed some spaces to the command. it is always trunctated
> ryt where the ' behind SCRAPBOOK is supposed to be.
> so it doesn't seem to be some fixed character number (i.e. due to some
> undersizes buffer) after which the statment is truncated.
> the exact same programm/statment works on an IBM DB/2 db without
> problems, btw.
>
> I was wondering if this is maybe a known problem in the 7.3b1 release of
> postgresql or the beta jdbc driver.
>
> THX
>
> mfg
> meyer
>
> PS:
>
> some additional information, maybe it is usefull.
>
> table definition:
> CREATE TABLE
> SERIES
> (
>
>        seriesdatetime          timestamp NOT
> NULL,                                   modality
> VARchar(16) NOT NULL,
> seriesnumber            VARchar(12) NOT NULL,
>        seriesinstanceuid       VARchar(64) NOT
> NULL,                                 seriesdescr
> VARchar(64) ,
> bodypartexamined        VARchar(16) ,
>        slicethickness          numeric(30,6)
> ,                                       sequencename
> VARchar(16) ,
> studytype               VARchar(16) ,
>        viewdirection           VARchar(16)
> ,                                         fieldofview
> VARchar(32) ,
> contrastAgent           VARchar(16) ,
>        numberseriesrelatedimages     integer NOT
> NULL,                               manufacturermodel       VARchar(64)
> ,                                         stuParent
> VARchar(64) NOT NULL,
> insertTimestamp         timestamp NOT NULL                             );
> CREATE INDEX SERIES_SERIES_X ON SERIES (seriesinstanceuid);
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>