[INTERFACES] JDBC 'Unterminated quoted string' 
Author Message
 [INTERFACES] JDBC 'Unterminated quoted string'

Yes it does look like it's the insert that's at fault. I've tested it on a
current backend here and it has the same problem.

Peter

--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council

WWW: http://www.***.com/
All views expressed within this email are not the views of Maidstone Borough
Council

Quote:
-----Original Message-----

Sent: Friday, November 10, 2000 10:21 AM
To: Peter Mount

Cc: Interfaces
Subject: Re: [INTERFACES] JDBC 'Unterminated quoted string'

Peter,

Joseph Shraibman contacted me yesterday about whether or not the patch that
I
sent actually does the correct thing. I enclose my response below.

In brief, there seems to be some problem at the backend inserting a \0. I
have
tested the query from the modified jdbc driver, psql and a standalone
backend.

Regards,
Grant

I tested by doing the following:-
In psql...
CREATE TABLE t ( aa char(1) );
INSERT INTO t VALUES ('\0');

In java test program...
      PreparedStatement ps =
         conn.prepareStatement("insert into t values (?)");
      ps.setString(1, String.valueOf('\0'));
      ps.executeUpdate();

In psql...
test=# select * from t;
 aa
----

(2 rows)
test=# select ascii(aa) from t;
 ascii
-------
    32
    32
(2 rows)

This is wierd! Both psql and the java app insert the same value and both are
not 0.

However,
test=# select ascii('\0');
 ascii
-------
     0
(1 row)

This appears correct, so the problem would appear to be in the insert.

--
> Poorly planned software requires a genius to write it
> and a hero to use it.


Software Engineer         Universal Computer Services
Tel  (+27)(11)712-1366    PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536    20th Floor, 209 Smit St., Braamfontein
Fax  (+27)(11)339-3421    Johannesburg, South Africa



Tue, 29 Apr 2003 18:32:31 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Findfirst's criteria string with single quote synax error

2. using quotes in 'locatePattern'

3. need expert's Help: single quote '

4. Problem with 'quote marks'

5. Looking for a 'quote'

6. Oracle's JDBC driver's PreparedStatement.cancel() doesn't work

7. [WEBMASTER] 'www/html interfaces.html'

8. 'Help-Find'-style interface for vb4 programmed database search

9. [WEBMASTER] 'www/html interfaces.html'

10. [WEBMASTER] 'www/html interfaces.html'

11. [WEBMASTER] 'www/html interfaces.html'

12. [WEBMASTER] 'www/html interfaces.html'


 
Powered by phpBB® Forum Software