[JDBC] web page?

2001-06-19 Thread Thomas O'Dowd
a couple of postings pointing to more recent builds for different jvm versions/database versions. It would be handy to point to them too... This might save some list b/w as it seems the archives aren't read too often for similar problems. Keep up the good work. Tom. -- Thomas O'Dowd. - Nooping - http

[JDBC] updateable ResultSets?

2001-06-22 Thread Thomas O'Dowd
Hi all, I noticed that the update methods are not implemented yet on the ResultSet object. Is anyone working on them? It would be really useful. If so, is it a near future thing? Thanks, Tom. -- Thomas O'Dowd. - Nooping - http://nooper.com [EMAIL PROTECTED] - Testing - http://nooper.co.jp

[JDBC] Todo/missing? (was Re: [ADMIN] High memory usage [PATCH])

2001-06-25 Thread Thomas O'Dowd
, 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

Re: [JDBC] Todo/missing? (was Re: [ADMIN] High memory usage [PATCH])

2001-06-25 Thread Thomas O'Dowd
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

Re: [JDBC] Todo/missing? (was Re: [ADMIN] High memory usage [PATCH])

2001-06-26 Thread Thomas O'Dowd
Bruce, This is great. I'd like to see Error codes on the list too pending of course work on the backend first. Good to put it on the list though, right? * Error Codes (pending backend implementation) Cheers, Tom. -- Thomas O'Dowd. - Nooping - http://nooper.com [EMAIL PROTECTED] - Testing

Re: [JDBC] Problem in Remote PostgreSQL connection.

2001-06-28 Thread Thomas O'Dowd
ran the same application from another system(Sys-C) which is in the same network as Sys-B (no firewall ), I am able to access DB, Without any entry in pg_hba.conf file on remote PostgreSQL (Sys-B) . -- Thomas O'Dowd. - Nooping - http://nooper.com [EMAIL PROTECTED] - Testing - http

Re: [JDBC] Problem in Remote PostgreSQL connection.

2001-06-29 Thread Thomas O'Dowd
never know who's gathering the info. Ask your network guys, I'm sure they'll have a quick answer for you. Cheers, Tom. -- Thomas O'Dowd. - Nooping - http://nooper.com [EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs ---(end of broadcast)--- TIP

Re: [JDBC] old product version number

2001-06-29 Thread Thomas O'Dowd
database and execute this? from psql: testdb= select version(); version --- PostgreSQL 7.1 on i586-pc-linux-gnu, compiled by GCC 2.96 (1 row) Tom. -- Thomas O'Dowd. - Nooping

Re: [JDBC] Methode is not yet implemented.

2001-07-16 Thread Thomas O'Dowd
... ... 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

Re: [JDBC] NullPointerException on next()

2001-08-09 Thread Thomas O'Dowd
---(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

[JDBC] Unterminated quoted string error.

2001-08-28 Thread Thomas O'Dowd
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]

[JDBC] Escape Processing problems

2001-08-28 Thread Thomas O'Dowd
= 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

Re: [JDBC] Unterminated quoted string error.

2001-08-28 Thread Thomas O'Dowd
. 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

[JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Thomas O'Dowd
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

[JDBC] Re: Escape Processing problems

2001-08-28 Thread Thomas O'Dowd
. 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

Re: [JDBC] Re: Escape Processing problems

2001-08-28 Thread Thomas O'Dowd
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

Re: [JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Thomas O'Dowd
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

Re: [JDBC] Re: Unterminated quoted string error.

2001-08-29 Thread Thomas O'Dowd
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

[JDBC] Re: Escape Processing problems

2001-08-29 Thread Thomas O'Dowd
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

Re: [JDBC] Re: Escape Processing problems

2001-09-01 Thread Thomas O'Dowd
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

Re: [JDBC] Re: Escape Processing problems

2001-09-04 Thread Thomas O'Dowd
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

[JDBC] Patch for Statement Escape Processing problems

2001-09-10 Thread Thomas O'Dowd
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

Re: [JDBC] Patch for Statement Escape Processing problems

2001-09-14 Thread Thomas O'Dowd
(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

Re: [JDBC] TIMESTAMP

2001-10-01 Thread Thomas O'Dowd
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

Re: [JDBC] [PATCHES] Ant configuration

2001-10-18 Thread Thomas O'Dowd
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]

Re: [JDBC] Does PG's JDBC support prepared statements at all?

2001-10-20 Thread Thomas O'Dowd
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

Re: [JDBC] Does PG's JDBC support prepared statements at all?

2001-10-22 Thread Thomas O'Dowd
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