in terms of not handling them as normal variable
placement holders or whatever the correct terminology is :) But I
guess that wasn't crystal clear in the way that I phrased it.
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
message = ? WHERE number = ?
Cheers,
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
at the current build process for the driver.
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http
(which is the default).
Tom.
On Mon, Sep 10, 2001 at 05:27:17PM +0900, Thomas O'Dowd wrote:
Hi all,
I'm attaching a patch which fixes the corruption in strings caused
by escape processing in the SQL statement. I've tested this for a
while now and it appears to work well. Previously string data
Hi all,
I'm attaching a patch which fixes the corruption in strings caused
by escape processing in the SQL statement. I've tested this for a
while now and it appears to work well. Previously string data
with {d was getting corrupt as the {d was being stripped regardless
of whether it was an
a little more testing, I fixed a problem with backslashes.
New code attached.
Tom.
On Thu, Aug 30, 2001 at 11:46:16AM +0900, Thomas O'Dowd wrote:
Hi all,
I found some time this morning to write and test a new EscapeSQL() method.
I didn't make a patch for the driver yet as I'd
On Sat, Sep 01, 2001 at 11:02:47PM +0200, Rene Pijlman wrote:
On Thu, 30 Aug 2001 11:46:16 +0900, Thomas O'Dowd wrote:
I found some time this morning to write and test a new EscapeSQL()
method. I didn't make a patch for the driver yet as I'd like to
hear some comments.
To what extent
contains nulls then you need to
use the binary datatype bytea. Unfortunately the JDBC drivers do not
currently support the bytea datatype.
thanks,
--Barry
Thomas O'Dowd wrote:
I found problem. My string has a null character in the middle of it. I
noticed from the Connection.java code
be bugs in the implementation of this
escaping stuff. I don't think it is used very often. I believe your
understanding of how this is supposed to work is correct.
thanks,
--Barry
Thomas O'Dowd wrote:
Hi Barry,
I found the part in the spec that talks about escape processing
before going to bed.
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
= sql.indexOf({d);
}
//System.out.println (modified SQL: + sql);
return sql;
}
Cheers,
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
---(end of broadcast)---
TIP 6: Have you
. missner
level(3) communications
-Original Message-
From: Thomas O'Dowd [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 9:23 AM
To: [EMAIL PROTECTED]
Subject: [JDBC] Unterminated quoted string error.
Hi all,
I'm currently chasing down a bug. Wonder if anyone can throw some
Thomas O'Dowd wrote:
Hi all,
I'm currently chasing down a bug. Wonder if anyone can throw some light
on it. I get the following exception.
An I/O error has occured while flushing the output - Exception:
java.io.IOException: Connection reset by peer
Stack Trace
.
thanks,
--Barry
Thomas O'Dowd wrote:
Hi all,
The Connection.EscapeSQL() routine is broken IMHO . Actually, I'm not
sure why it is trying to fix strings starting with {d in the first place?
Anyway, currently I've turned it off in the statement with
setEscapeProcessing(false
On Wed, Aug 29, 2001 at 09:18:26AM +0900, Thomas O'Dowd wrote:
INSERT INTO test VALUES('don't change this {d '-mm-dd'} as its correct.
Opps. I didn't backslash the single quotes here but you know what I mean...
Tom.
---(end of broadcast
but I'm wondering if the preparedStatement.setString()
shouldn't escape nulls or something. It already escapes single quotes and
backslashes. What do people think?
Cheers,
Tom.
On Wed, Aug 29, 2001 at 08:53:31AM +0900, Thomas O'Dowd wrote:
Thanks Barry,
I turned on debugging in postgresql
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
---(end of broadcast
...
...
java.sql.Statement stmt = con.createStatement();
java.sql.ResultSet rs = stmt.executeQuery(SELECT * from table);
...
Where con is an open connection to your database.
Also, try grabbing a driver from: http://jdbc.fastcrypt.com/
Cheers,
Tom.
--
Thomas O'Dowd. - Nooping
, what works and what doesn't, the recommended versions to
run for each database etc and somesort of changelog. I'm willing to help :)
Cheers,
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
---(end of broadcast
about the web site? Stuff I'd like added would be, where to find
this list, where to find the cvs version, updated binaries, I know
someone on this list has made them available.
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
[EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs
21 matches
Mail list logo