[Geoserver-users] Trying to hook up Oracle [Sec=Unclassified]

Hi CB

> From: CB
>
> 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.createDataSto
> re(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.
>

Did you download the JDBC driver? It's called ojdbc14.jar and is
available at
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Place it in webapps/geoserver/WEB-INF/lib and restart Geoserver.

This is described in further detail in the Geoserver Documentation.
http://geoserver.org/display/GEOSDOC/Oracle+DataStore

Regards

Miles
___________________________________________________________________________

    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
        Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________

Miles Jordan wrote:

Hi CB
> From: CB
> 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
> 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.

Did you download the JDBC driver? It's called ojdbc14.jar and is
available at
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Place it in webapps/geoserver/WEB-INF/lib and restart Geoserver.

You can also use ojdbc5.jar if running with Java 5 or better (Oracle 10 or later comes with ojdbc5.jar). You should be able to find it in $ORACLE_HOME/jdbc/lib in your Oracle installation.

--
Ben Caradoc-Davies <Ben.Caradoc-Davies@anonymised.com>
Software Engineer, CSIRO Exploration and Mining
Australian Resources Research Centre
26 Dick Perry Ave, Kensington WA 6151, Australia