[JDBC] web page?

2001-06-19 Thread Thomas O';Dowd
;ve seen 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'Do

[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.

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

2001-06-25 Thread Thomas O';Dowd
ho has access to update these pages? I don't care about tutorials or stuff like that yet, but just info on known bugs, what works and what doesn't, the recommended versions to run for each database etc and somesort of changelog. I'm willing to help :) Chee

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

2001-06-25 Thread Thomas O';Dowd
rent known bugs or compliance issues? How 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 PROTECTE

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

2001-06-25 Thread Thomas O';Dowd
* Compatible blob support 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 -

Re: [JDBC] Problem in Remote PostgreSQL connection.

2001-06-28 Thread Thomas O';Dowd
:postgresql://Sys-B IP/dbName" > > when i invoke my application I am getting the error as NoRouteToHostException. > > When I 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 ent

Re: [JDBC] Problem in Remote PostgreSQL connection.

2001-06-28 Thread Thomas O';Dowd
your private network in a public forum as you 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://noo

Re: [JDBC] old product version number

2001-06-29 Thread Thomas O';Dowd
ion correctly returns 7.0. > Can't find anything in the docs or archives. the source for that function executes the code "select version()". What do you get when you psql into you database and execute this? Tom. -- Thomas O'Dowd. - Nooping - http://nooper.com [EMAIL

Re: [JDBC] old product version number

2001-06-29 Thread Thomas O';Dowd
--------- > PostgreSQL 7.1 on i586-pc-linux-gnu, compiled by GCC 2.96 > (1 row) > > > >Tom. > >-- > >Thomas O'Dowd. - Nooping - http://nooper.com > >[EMAIL PROTECTED] - Testing - http://no

Re: [JDBC] Methode is not yet implemented.

2001-07-16 Thread Thomas O';Dowd
egment. You're probably doing something wrong. It should be something like... ... java.sql.Statement stmt = con.createStatement(); java.sql.ResultSet rs = stmt.executeQuery("SELECT * from "); ... Where con is an open connection to your database. Also

Re: [JDBC] NullPointerException on next()

2001-08-09 Thread Thomas O';Dowd
bot.com > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > > > > -----------(end of broadcast)--- > TIP 1: subscribe and unsubscribe

[JDBC] Unterminated quoted string error.

2001-08-28 Thread Thomas O';Dowd
I'd shoot the list a mail 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
7;); buf.setCharAt(index + 1, ' '); buf.setCharAt(sql.indexOf('}', index), ' '); sql = new String(buf); index = sql.indexOf("{d"); } //System.out.println ("modified SQL: " + sql); return

Re: [JDBC] Unterminated quoted string error.

2001-08-28 Thread Thomas O';Dowd
nt.setString(myString) > > > t.r. 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 er

[JDBC] Re: Unterminated quoted string error.

2001-08-28 Thread Thomas O';Dowd
ind the problem. > > thanks, > --Barry > > 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 occur

[JDBC] Re: Escape Processing problems

2001-08-28 Thread Thomas O';Dowd
t there are a bunch of other '{X }' things that the Spec > defines that it should also be handling. > > thanks, > --Barry > > Thomas O'Dowd wrote: > > Hi all, > > > > The Connection.EscapeSQL() routine is broken IMHO . Actually, I'm not

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. -

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

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

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

2001-08-29 Thread Thomas O';Dowd
support > storing null characters. If your data 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 pro

[JDBC] Re: Escape Processing problems

2001-08-29 Thread Thomas O';Dowd
. Tom. On Tue, Aug 28, 2001 at 06:24:06PM -0700, Barry Lind wrote: > Thomas, > > I can see where there might 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 corr

Re: [JDBC] Re: Escape Processing problems

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

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 > &

Re: [JDBC] Re: Escape Processing problems

2001-09-04 Thread Thomas O';Dowd
in the next 48 hours. > > > Hmmm, after 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, > > > > &g

Re: [JDBC] driver source code indentation

2001-09-05 Thread Thomas O';Dowd
Other than that I'm all for cleaning up the source code to the one standard. Go for it! Tom. -- Thomas O'Dowd. - Nooping - http://nooper.com [EMAIL PROTECTED] - Testing - http://nooper.co.jp/labs ---(end of broadcast)--- TIP 3: if pos

[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 esca

Re: [JDBC] Patch for Statement Escape Processing problems

2001-09-14 Thread Thomas O';Dowd
dStatement if setEscapeProcessing is set true (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'

Re: [JDBC] Patch to add bytea support to JDBC

2001-09-14 Thread Thomas O';Dowd
is a patch to add bytea support to JDBC. [Rest of mail munched...] -- 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] TIMESTAMP

2001-10-01 Thread Thomas O';Dowd
ded seemed to work. > > > __ > Do 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

Re: [JDBC] [PATCHES] Ant configuration

2001-10-18 Thread Thomas O';Dowd
s/paths etc in the makefile. That said I haven't really looked 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
number= part, and then when you call setInt(2) you are getting the index out of range. The proper qstring should be: "UPDATE foo SET 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
27;?' :-) I meant ignores them 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 PROTEC