From: | Jeff Hoffmann <jeff(at)propertykey(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Binary Cursors (& Geometric Type Support) |
Date: | 2002-09-21 03:39:29 |
Message-ID: | 3D8BE9F1.3010905@propertykey.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I'm trying to port some code from C/libpq to Java & one of the things
I'm having trouble with is getting binary cursors to work. The C code
uses a binary cursor to speed up a loop through a bunch of polygons & I
was hoping it would have the same effect with Java. The code for a
non-binary cursor works fine, but is just taking too long. Basically,
here's what I'm doing:
query.executeUpdate("declare my_cursor cursor for select p from
my_polygon");
ResultSet rs = query.executeQuery("fetch 1 from my_cursor");
PGpolygon p = (PGpolygon)rs.getObject("p");
When I switch the "cursor" to a "binary cursor", I get the following error:
Conversion of point failed - java.lang.NumberFormatException:
??n?gk(at)A?z?v A?OT&?A(at)A
Is there something else I have to do to get this to work or am I going
to be out of luck? I've seen references to people successfully using
binaries cursors in earlier messages in the list -- is it just the
non-standard geometric types that are troublesome from a binary perspective?
Thanks,
Jeff Hoffmann
PropertyKey.com
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2002-09-22 15:58:25 | Re: Binary Cursors (& Geometric Type Support) |
Previous Message | Laurentiu Drob | 2002-09-20 19:19:10 | Postgres 7.3b1 + pg73b1jdbc3 rs.last() error |