[postgis-users] JDBC-Postgis bug

[C F]

>Well, first, thanks for using WKB4J!

Yep, very happy with it.  I added an SVG factory as well.  If you're 
interested, I'll submit it when it's been polished.

>
>Second, the final version of WKB4J will allow you to retrieve integers
>along with the byte array representing the geometry, so it might solve
>some of you problems. The change is already in the CVS and I'm in the
>process of completing the test framework in order to make sure that
>everything works fine.

Unfortunately, I need to be able to retrieve other data types... varchar, 
date, etc.

>Finally I have a question: are you telling me that it works fine with
>your modification but without any other change (like switching to text
>cursors) ?

I didn't use any explicit cursors at all.  I just do a simply query.  All 
the code change is in WKBReader.getData()....

from...
            wkbSta.execute("begin");
            wkbSta.execute("declare wkb_cursor binary cursor for " + 
completeSQLQuery);
            ResultSet wkbRecords = wkbSta.executeQuery("fetch forward all in 
wkb_cursor");
            
parser.parseData(wkbRecords.getBytes("wkb"),wkbRecords.getBytes("srid"));
            .
            wkbRecords.close();
            wkbSta.close();


to.....

           ResultSet wkbRecords = wkbSta.executeQuery(completeSQLQuery);
           
parser.parseData(wkbRecords.getBytes("wkb"),wkbRecords.getInt("srid"));


.... with the key difference being in the query string that I pass to 
getData().


>At first I didn't used bytea because I thought that it
>encoded bytes as String objects and that performance would suffer.

Yeah, I guess that's possible.  I'm not sure... that goes beyond my level of 
expertise :-)

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail