[Geoserver-devel] Oracle DataStore

Has anybody any simple, step by step instructions on how to get the oracle datastore to work.

I keep getting a SEVERE log message saying FeatureTypeInfo bfora:::LOCATIONS ignored - as DataStore bfora is unavailable:org.geotools.data.SchemaNotFoundException: Feature type could not be found for LOCATIONS.

How do i tell geoserver which table to look at and what the columns are (assuming it cannot look this up from the database)

I am getting a connection made to the database.

what is the schema parameter to the oracle datastore - is it the database schema name?

John Grange
Software Team Leader

Tel: +44 (0) 1749 834922
Email: john.grange@anonymised.com

BlueFinger Limited
Underwood Business Park, Wookey Hole Road, Wells, Somerset, BA5 1AF, UK
Tel: +44 (0) 1749 834900
Fax: +44 (0) 1749 834902
Mobile: +44 (0) 7876 038058
web: www.bluefinger.com <http://www.bluefinger.com>

Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG.

*** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.***

Has anybody any simple, step by step instructions on how to get the
oracle
datastore to work.

The general GeoServer documentation combined with
http://geoserver.sourceforge.net/documentation/user/advanced.htm#oracle
should have enough answers. Let me know what more information should
be put in there. Or we could make a full page of simple oracle
instructions... Sean is the oracle maintainer, so he may be able to
provide better answers.

I keep getting a SEVERE log message saying FeatureTypeInfo
bfora:::LOCATIONS
ignored - as DataStore bfora is
unavailable:org.geotools.data.SchemaNotFoundException: Feature type
could
not be found for LOCATIONS.

How do i tell geoserver which table to look at and what the columns
are
(assuming it cannot look this up from the database)

The table to look up should be the <name> element in the featureType's
info.xml file, and it should refer to the oracel datastore. The schema
stuff has been the source of a few problems, you may try just leaving
it out all together - but yes, I think it is the database schema name,
but it's only really necessary if you have two tables of the same name
in different schemas.

hope this helps,

Chris

I am getting a connection made to the database.

what is the schema parameter to the oracle datastore - is it the
database
schema name?

John Grange
Software Team Leader

Tel: +44 (0) 1749 834922
Email: john.grange@anonymised.com

BlueFinger Limited
Underwood Business Park, Wookey Hole Road, Wells, Somerset, BA5 1AF,
UK
Tel: +44 (0) 1749 834900
Fax: +44 (0) 1749 834902
Mobile: +44 (0) 7876 038058
web: www.bluefinger.com <http://www.bluefinger.com>

Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay,
BRISTOL. BS1 6EG.

*** This E-mail contains confidential information for the addressee
only. If
you are not the intended recipient, please notify us immediately. You
should
not use, disclose, distribute or copy this communication if received
in
error. No binding contract will result from this e-mail until such
time as a
written document is signed on behalf of the company. BlueFinger
Limited
cannot accept responsibility for the completeness or accuracy of this
message as it has been transmitted over public networks.***

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Chris Holmes wrote:

Has anybody any simple, step by step instructions on how to get the
oracle datastore to work.
   

The general GeoServer documentation combined with
http://geoserver.sourceforge.net/documentation/user/advanced.htm#oracle
should have enough answers. Let me know what more information should
be put in there. Or we could make a full page of simple oracle
instructions... Sean is the oracle maintainer, so he may be able to
provide better answers.

Chris I spent a half hour with Pati (she was testing for us yesterday) not getting oracle to work. I am thinking of *not* including the oracle datastore in the war file.

We can then modify the instructions for the use of oracle to be the inclusion of three jars not two.

This issue is tracked as as the following:
http://jira.codehaus.org/secure/ViewIssue.jspa?key=GEOS-65
http://jira.codehaus.org/secure/ViewIssue.jspa?key=GEOT-89

Not including the jar would serve as a temporary fix for GEOT-89 - I don't want oracle in the list if it cannot work.