[Geoserver-devel] oracle spatial data store

GeoServer GeoServer Developer
1

hi--
i'm trying to use oracleSpatial10.2 with geoserver 1.6.5 on solaris8,
but am not able to get Oracle to show up in the DataStore Listings

i downloaded the oracle plugin and copied the jars into
  $GEOSERVER_HOME/webapps/geoserver/WEB-INF/lib
Oracle is installed on the same box as geoserver but i copied
  $ORACLE_HOME/jdbc/lib/{classes12.jar,ojdbc14.jar} into
$GEOSERVER_HOME/webapps/geoserver/WEB-INF/lib as well

restarted geoserver but still get no joy

any advice would be greatly appreciated

cheers
--kassim

2

Hi Kassim,

Following those steps it should work. Can you change the server config and turn up logging to full. Then restart the server and see if there are any relevant logs toward oracle. Hopefully that will help us spot the issue.

-Justin

Visram, Kassim wrote:

hi--
i'm trying to use oracleSpatial10.2 with geoserver 1.6.5 on solaris8,
but am not able to get Oracle to show up in the DataStore Listings

i downloaded the oracle plugin and copied the jars into $GEOSERVER_HOME/webapps/geoserver/WEB-INF/lib
Oracle is installed on the same box as geoserver but i copied $ORACLE_HOME/jdbc/lib/{classes12.jar,ojdbc14.jar} into
$GEOSERVER_HOME/webapps/geoserver/WEB-INF/lib as well

restarted geoserver but still get no joy

any advice would be greatly appreciated

cheers
--kassim

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

3

Justin Deoliveira wrote:

Hi Kassim,

Following those steps it should work. Can you change the server config and turn up
logging to full. Then restart the server and see if there are any relevant logs toward
oracle. Hopefully that will help us spot the issue.

-Justin

Visram, Kassim wrote:

hi--
i'm trying to use oracleSpatial10.2 with geoserver 1.6.5 on solaris8,
but am not able to get Oracle to show up in the DataStore Listings

i downloaded the oracle plugin and copied the jars into
  $GEOSERVER_HOME/webapps/geoserver/WEB-INF/lib
Oracle is installed on the same box as geoserver but i copied
  $ORACLE_HOME/jdbc/lib/{classes12.jar,ojdbc14.jar} into
$GEOSERVER_HOME/webapps/geoserver/WEB-INF/lib as well

restarted geoserver but still get no joy

any advice would be greatly appreciated

cheers
--kassim

I would copy only ojdbc14.jar - not classes12.jar. It's possible that they contain
conflicting class names, which can cause a spurious ClassNotFoundException.

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/
___________________________________________________________________________

4

hi justin and miles --

i only added the -cp business to startup command because i couldnt get
oracleSpatial to appear in the DataStores list when i tried running the
command without the modifications.

since our last email, i also tried running geoserver 1.6.5 on a
windows2003 server with the same results.

on solaris my java version is:

elvis[kxv4]{188}% /usr/java/bin/java -version
java version "1.5.0_03"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_03-b07)
Java HotSpot(TM) Server VM (build 1.5.0_03-b07, mixed mode)

thanks for your help on this
--kassim

Miles wrote:
Ah ok...

http://java.sun.com/j2se/1.5.0/docs/tooldocs/solaris/java.html#-jar

"When you use [the -jar] option, the JAR file is the source of all user
classes, and other user class path settings are ignored."

So in essence the -cp switch is being ignored in your startup command...
But it should pick them up if you put them in geoserver's default lib
directory anyway - "[GEOSERVER_HOME]/server/geoserver/WEB-INF/lib/"

Regards,

Miles

PS- Questions like this should be posted to the geoserver-users group...

-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Monday, October 06, 2008 8:16 PM
To: Visram, Kassim
Subject: Re: [Geoserver-devel] oracle spatial data store

Visram, Kassim wrote:

hey thanks for your response, justin

i'm starting geoserver as follows:
elvis[root10]{21}% java -DGEOSERVER_DATA_DIR=$GEOSERVER_DATA_DIR
-Djava.awt.headless=true -DSTOP.PORT=8079 -DSTOP.KEY=geoserver -cp

$GEOSERVER_HOME/lib/classes12.jar:$GEOSERVER_HOME/lib/ojdbc14.jar:$GEOSE

RVER_HOME/gt2-oracle-spatial-2.3.1.jar -jar start.jar

because using bin/startup.sh gives this error
    startup.sh: test: argument expected

Hi Visram,

I am not 100% sure but I don't believe specifying the oracle jars on the

command like this will work. Instead i believe you must copy them into
webapps/geoserver/WEB-INF/lib. I could be wrong but I am not sure that
jars from this classpath are propagated to the classpath given to the
web applications started in the container. I could be wrong, i would
have to double check how jetty class loading works.

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

5

Visram, Kassim wrote:

hi justin and miles --

i only added the -cp business to startup command because i couldnt
get oracleSpatial to appear in the DataStores list when i tried
running the command without the modifications.

since our last email, i also tried running geoserver 1.6.5 on a
windows2003 server with the same results.

on solaris my java version is:

elvis[kxv4]{188}% /usr/java/bin/java -version
java version "1.5.0_03"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_03-b07)
Java HotSpot(TM) Server VM (build 1.5.0_03-b07, mixed mode)

thanks for your help on this
--kassim

It seems that the oracle plugin may be broken on the 1.6.5 stable release - I just upgraded from the 1.6.5 beta that I had installed and now I can't get the oracle plugin to work either.

The plugin loads fine on 1.7 RC4.

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/
___________________________________________________________________________