;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
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.
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
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
* 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 -
: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
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
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
---------
> 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
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
bot.com
>
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster
>
>
>
> -----------(end of broadcast)---
> TIP 1: subscribe and unsubscribe
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]
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
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
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
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
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.
-
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,
>
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
.
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
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
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
> &
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
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
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
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'
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]
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
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]
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
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
31 matches
Mail list logo