Skip site navigation (1) Skip section navigation (2)

Port Bug Report: Parse error for insert statement when using jdbc.

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgresql(dot)org
Subject: Port Bug Report: Parse error for insert statement when using jdbc.
Date: 1999-05-07 22:48:34
Message-ID: 199905072248.SAA47256@hub.org (view raw or flat)
Thread:
Lists: pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Shashi Kumar
Your email address      : menonsk(at)hotmail(dot)com

Category                : runtime: back-end
Severity                : critical

Summary: Parse error for insert statement when using jdbc.

System Configuration
--------------------
  Operating System   : Red Hat Linux 5.2

  PostgreSQL version : 6.2.1

  Compiler used      : jdk 1.1.7

Hardware:
---------
Linux 2.0.36 #1 Tue Jun 30 08:32:04 CDT 1998 i686 unknown

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
 
My database table has one of the attributes
  scandata varchar(2000)
I have to insert a String into this column. This string
can have all Ascii character from ascii(33) and above.

The String looks something like this :

BZT597         A29905071439149905071439
14                  POS            0000
01T#A<$G0507 POSS0100  691533B000340600
14391439<"!T** #B(!!1(&$0507(%$HNBA(#%6
9153(+#BSC(R$1439(,''wxyz(S$1439(.!6<F+E
221546264B<H!2<I-POS Test Site(/,806287
701919(0!1>*$0200** **

When I insert this string to the table through
the psql prompt, it gets inserted.(I only
have to take care of the single quotes in the
string).

I am using JDBC to connect to (jdbc:postgresql:) and
try to insert the same string. I get an Error
java.sql.SQLException: WARN:parser: parse error at or near "" .
I tried tracking the source of this error and found that
the input SQL string is being written to the Socket in
PG_Stream.java file. The return Message that it receives
give the error. So I think there is some parsing problem
at the backend server. Remember the same command that I 
use to insert this string works through psql prompt.
  If u can help me out, I would appreciate that.

Thanks
Shashi




--------------------------------------------------------------------------

Test Case:
----------
I am using the following string in
executeUpdate(String);

INSERT INTO scandata VALUES ('806287701871', '0200', 'POD', '1999:5:7:14:39:14', '1', 'Posting Error- No Scan Posted', 'BZT597         A2990507143914990507143914                  POS            000001T#A<$G0507 POSS0100  606053B00034060014391439<"!T** #B(!!1(&$0507(%$OLVA(#%60605(+#STA(R$1439(,''wxyz(S$1439(.!6<F+E221546264B<H!3<I-POS Test Site(/,806287701871(0!1>*$0200** **');

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date

Next:From: Unprivileged userDate: 1999-05-08 10:46:43
Subject: Port Bug Report: initdb: stuck spinlock
Previous:From: Peter GalbavyDate: 1999-05-07 14:26:57
Subject: did this ever get integrated ? (for OpenBSD)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group