pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

[INTERFACES] JDBC escape problem
2+ messages / 2 participants
[nested] [flat]

* [INTERFACES] JDBC escape problem
@ 1999-07-08 07:56  Rolland Crunk <rc@aenet.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Rolland Crunk @ 1999-07-08 07:56 UTC (permalink / raw)
  To: pgsql-interfaces@hub.org



I'm encountering a problem with the implementation of escapes using
the 6.5 JDBC driver.  If I attempt to insert a timestamp value using
the following syntax, I get an error from the postgreSQL parser complaining
about the '{' character:

  stmt.executeUpdate("insert into tstest values ( { ts '1999-07-07 00:00:00' } )");

However, the following statement works:

  stmt.executeUpdate("insert into tstest values ( '{ ts 1999-07-07 00:00:00 }' )");

Unfortunately, the former is the correct syntax where the second isn't.

From what I could determine tracing the code, there is no escape processing
performed in the PostgreSQL jdbc driver, and the error is originating from the
database backend.

I thought it unusual that I didn't see reference to this problem in the mail
archives (though I admit I only went back a few months).  Is this a known
problem?  

What are the consequences of fixing it in the back-end?  Will it break other 
drivers that depend on this syntax?  

Any advise would be appreciated.

Thanks in advance,

rc



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: [INTERFACES] JDBC escape problem
@ 1999-07-08 08:34  Peter Mount <petermount@it.maidstone.gov.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Mount @ 1999-07-08 08:34 UTC (permalink / raw)
  To: 'Rolland Crunk' <rc@aenet.net>; pgsql-interfaces@hub.org; +Cc: Peter Mount (Home) <peter@retep.org.uk>

This is probably caused by the fact that currently we don't parse
anything within the JDBC driver. I'll put it on my todo list for 6.6.

-----Original Message-----
From: Rolland Crunk [mailto:rc@aenet.net]
Sent: 08 July 1999 08:57
To: pgsql-interfaces@hub.org
Subject: [INTERFACES] JDBC escape problem




I'm encountering a problem with the implementation of escapes using
the 6.5 JDBC driver.  If I attempt to insert a timestamp value using
the following syntax, I get an error from the postgreSQL parser
complaining
about the '{' character:

  stmt.executeUpdate("insert into tstest values ( { ts '1999-07-07
00:00:00' } )");

However, the following statement works:

  stmt.executeUpdate("insert into tstest values ( '{ ts 1999-07-07
00:00:00 }' )");

Unfortunately, the former is the correct syntax where the second isn't.

From what I could determine tracing the code, there is no escape
processing
performed in the PostgreSQL jdbc driver, and the error is originating
from the
database backend.

I thought it unusual that I didn't see reference to this problem in the
mail
archives (though I admit I only went back a few months).  Is this a
known
problem?  

What are the consequences of fixing it in the back-end?  Will it break
other 
drivers that depend on this syntax?  

Any advise would be appreciated.

Thanks in advance,

rc



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~1999-07-08 08:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-08 07:56 [INTERFACES] JDBC escape problem Rolland Crunk <rc@aenet.net>
1999-07-08 08:34 RE: [INTERFACES] JDBC escape problem Peter Mount <petermount@it.maidstone.gov.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox