[Geoserver-users] Trying to hook up Oracle

GeoServer GeoServer User
1

Hello,

I am trying to get GeoServer 1.6.2 to use an Oracale server, but can't
get the connection to work.

On the GeoServer console I found this:
form connection params { schema="", port="1521", passwd="user1",
dbtype="oracle ", host="ORA11G", instance="ORCL", user="user1"}
21 Apr 10:47:24 WARN [geotools.data] - Could not acquire Oracle
Spatial Database :java.lang.NoClassDefFoundError:
org/geotools/geometry/JTS$ReferencedEnvelope
java.lang.NoClassDefFoundError:
org/geotools/geometry/JTS$ReferencedEnvelope at
org.geotools.data.oracle.OracleDataStoreFactory.createDataStore(OracleDataStoreFactory.java:177)
        at org.geotools.data.DataStoreFinder.getDataStore(DataStoreFinder.java:9
1)
        at org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.ja
va:62)
        at org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtil
s.java:51)
        at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(Dat
aDataStoresEditorAction.java:134)
        at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)

I suspect I am missing a component.
Any ideas on what is going wrong? I am able to connect to the Oracle
server with other utilities.
Thanks.

2

CB ha scritto:

Hello,

I am trying to get GeoServer 1.6.2 to use an Oracale server, but can't
get the connection to work.

On the GeoServer console I found this:
form connection params { schema="", port="1521", passwd="user1",
dbtype="oracle ", host="ORA11G", instance="ORCL", user="user1"}
21 Apr 10:47:24 WARN [geotools.data] - Could not acquire Oracle
Spatial Database :java.lang.NoClassDefFoundError:
org/geotools/geometry/JTS$ReferencedEnvelope
java.lang.NoClassDefFoundError:
org/geotools/geometry/JTS$ReferencedEnvelope at
org.geotools.data.oracle.OracleDataStoreFactory.createDataStore(OracleDataStoreFactory.java:177)

This error message seems to suggest a mismatch between GeoServer
and the Oracle datastore plugin you are using.
You cannot use an oracle plugin for, say, 1.5.3 in 1.6.2, the
GeoTools API changed in the meantime in a binary incompatible
way.

Please clean up you GeoServer installation, download the Oracle
extension for GeoServer 1.6.2 and try again.

Cheers
Andrea

3

Hi,

I believe many new users are having troubles, because the natural link from
http://geoserver.org/display/GEOSDOC/Oracle+DataStore
is leading to here http://prdownloads.sourceforge.net/geoserver/geoserver-1.3.x-oracle-ext.zip?download
and that version will not work if I have understood it right.

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net]
Puolesta Andrea Aime
Lähetetty: 22. huhtikuuta 2008 9:46
Vastaanottaja: CB
Kopio: Geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] Trying to hook up Oracle

CB ha scritto:
> Hello,
>
> I am trying to get GeoServer 1.6.2 to use an Oracale
server, but can't
> get the connection to work.
>
> On the GeoServer console I found this:
> form connection params { schema="", port="1521", passwd="user1",
> dbtype="oracle ", host="ORA11G", instance="ORCL", user="user1"}
> 21 Apr 10:47:24 WARN [geotools.data] - Could not acquire Oracle
> Spatial Database :java.lang.NoClassDefFoundError:
> org/geotools/geometry/JTS$ReferencedEnvelope
> java.lang.NoClassDefFoundError:
> org/geotools/geometry/JTS$ReferencedEnvelope at
>
org.geotools.data.oracle.OracleDataStoreFactory.createDataStore(Oracle
> DataStoreFactory.java:177)

This error message seems to suggest a mismatch between
GeoServer and the Oracle datastore plugin you are using.
You cannot use an oracle plugin for, say, 1.5.3 in 1.6.2, the
GeoTools API changed in the meantime in a binary incompatible way.

Please clean up you GeoServer installation, download the
Oracle extension for GeoServer 1.6.2 and try again.

Cheers
Andrea

--------------------------------------------------------------
-----------
This SF.net email is sponsored by the 2008 JavaOne(SM)
Conference Don't miss this year's exciting event. There's
still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java

.sun.com/javaone

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

4

Rahkonen Jukka ha scritto:

Hi,

I believe many new users are having troubles, because the natural link from http://geoserver.org/display/GEOSDOC/Oracle+DataStore
is leading to here http://prdownloads.sourceforge.net/geoserver/geoserver-1.3.x-oracle-ext.zip?download
and that version will not work if I have understood it right.

Ah, right, you're absolutely right. I fixed the link, but noticed the page has some other outdated information (e.g., we do include the jdbc
driver in the download as far as I know).

I've scheduled an issue to fix this since atm I cannot work on it:
http://jira.codehaus.org/browse/GEOS-1879

Cheers
Andrea

5

On Tue, Apr 22, 2008 at 6:31 AM, Andrea Aime <aaime@anonymised.com> wrote:

Rahkonen Jukka ha scritto:

> Hi,
>
> I believe many new users are having troubles, because the natural link from
> http://geoserver.org/display/GEOSDOC/Oracle+DataStore
> is leading to here http://prdownloads.sourceforge.net/geoserver/geoserver-1.3.x-oracle-ext.zip?download
> and that version will not work if I have understood it right.

Ah, right, you're absolutely right. I fixed the link, but noticed the
page has some other outdated information (e.g., we do include the jdbc
driver in the download as far as I know).

I've scheduled an issue to fix this since atm I cannot work on it:
http://jira.codehaus.org/browse/GEOS-1879

Cheers
Andrea

Thanks, everyone. It seems to have been a version mismatch. Appears
to be working now.
CB