We may have a 10g instance to test the patch on, if you can provide an
easy test case for us to run.
Chris
David Zwiers wrote:
Hey guys,
I think I ran into a bug in the GeometryConverter ... though i'd run it past
cause I could be missing something.
In the toSDO method, the first line is "if( geom == null) return
asEmptyDataType();". When we go inside this, there is a call to "toSTRUCT(
null, DATATYPE )" ... which creates a nasty ORA-00600 errorcode (internal
error). After searching the net with the text (changes based on the actual
error) it looks like this is an array out of bounds happening inside oracle.
I think the culprit was the null in the second statement above. I replaced
that with
toSTRUCT( new Datum[5], DATATYPE ); and everything works for me (9.0.2).
Note JDBC does not support null geometries in the setNull methods, so this
was the only way that worked for me. Also, I got the [5] from the end of the
toSDO method.
The main reason for the msg, has todo with versions 8.x and 10.x. I'm not
familiar with there internals, and don't have a test server ... so didn't
want to mess this up for the other versions. Have you tested inserting null
geoms into those servers? And if so, do you have an instance to test this
patch?
Cheers,
David
--
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com
begin:vcard
fn:Chris Holmes
n:Holmes;Chris
org:The Open Planning Project
adr:;;377 Broadway, 11th Floor;New York;NY;10013;USA
email;internet:[EMAIL PROTECTED]
title:VP, Strategic Development
x-mozilla-html:FALSE
url:http://topp.openplans.org
version:2.1
end:vcard
