[Geoserver-devel] Problems Connecting To Oracle Spatial Database

I am installing GeoServer1.2.0-rc1 and am trying to connect to an Oracle 9i Database. I have a classes12.jar but my sdoapi.jar does not contain the correct classes.

I checked the source for the oracle-spatial jar from geotools and the classes that it imports do not exist (nor do the packages) in the sdoapi.jar. I downloaded the jar file from the Oracle Tech Net at http://otn.oracle.com/software/products/spatial/index.html .

Has Oracle changed the package structure of its spatial Java class libraries or do I not have the correct version of the jar? If I do not have the correct version can someone please send me correct sdoapi.jar?

Thanks

Ian Ives

Alle 21:50, martedì 15 giugno 2004, Ian Ives ha scritto:

I am installing GeoServer1.2.0-rc1 and am trying to connect to an Oracle
9i Database. I have a classes12.jar but my sdoapi.jar does not contain
the correct classes.

I checked the source for the oracle-spatial jar from geotools and the
classes that it imports do not exist (nor do the packages) in the
sdoapi.jar. I downloaded the jar file from the Oracle Tech Net at
http://otn.oracle.com/software/products/spatial/index.html .

Has Oracle changed the package structure of its spatial Java class
libraries or do I not have the correct version of the jar? If I do not
have the correct version can someone please send me correct sdoapi.jar?

Unfortunately yes, the API has changed heavily since 9i and the datastore
has been developed against 8i with a whole different API. We are aware of
the problem, but frankly I don't know if anyone will have the time to rewrite
part of the datastore to support the new API... not me for sure, maybe Sean?

Best regards
Andrea Aime

> I am installing GeoServer1.2.0-rc1 and am trying to connect to an Oracle
> 9i Database. I have a classes12.jar but my sdoapi.jar does not contain
> the correct classes.
>
> I checked the source for the oracle-spatial jar from geotools and the
> classes that it imports do not exist (nor do the packages) in the
> sdoapi.jar. I downloaded the jar file from the Oracle Tech Net at
> http://otn.oracle.com/software/products/spatial/index.html .
>
> Has Oracle changed the package structure of its spatial Java class
> libraries or do I not have the correct version of the jar? If I do not
> have the correct version can someone please send me correct sdoapi.jar?

Unfortunately yes, the API has changed heavily since 9i and the datastore
has been developed against 8i with a whole different API. We are aware of
the problem, but frankly I don't know if anyone will have the time to rewrite
part of the datastore to support the new API... not me for sure, maybe Sean?

I think Jody may have written a replacement for sdoapi, in anticipation of
this move by oracle. I may be misunderstanding the work he did, but if it
can replace the sdoapi, even if not faster, I think we have compelling
reason to use it now, namely that none of our users can get the old jar.
Jody, do you have time or could you show me how to roll that work in?

Chris

Best regards
Andrea Aime

-------------------------------------------------------
This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--