Stuart,
Thanks for the suggestions, I’ll try them out and let you know how I got on. I had already carried out Chris’s suggestions, to no avail.
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
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.***
-----Original Message-----
From: Stuart.Girvan@anonymised.com [mailto:Stuart.Girvan@anonymised.com]
Sent: Tuesday, March 16, 2004 10:46 PM
To: john.grange@anonymised.com
Cc: cholmes@anonymised.com; Sean.Geoghegan@anonymised.com
Subject: RE: [Geoserver-devel] Oracle DataStoreJohn,
Here’s a few brief notes I kept while recently installing Geoserver and getting it to connect to Oracle:
Feature name for Oracle source must be in upper case in info.xml file
Oracle spatial table must have correct entry in USER_SDO_GEOM_METADATA view
Can’t include primary keys in attributes section of info.xml
Namespaces in the catalog.xml file have datastore ids associated with them. Thus two namespaces can not use the same datastore.
If Feature is upper case, as it must be in the info.xml file for Oracle data sources, then you must call it using upper case.
Whatever table you use MUST have a primary key declared
Chris, these are pretty basic points but you may want to add these to an FAQ type list?
Cheers,
Stuart-----Original Message-----
From: Grange, John [mailto:john.grange@anonymised.com]
Sent: Tuesday, 16 March 2004 3:38
To: ‘geoserver-devel@lists.sourceforge.net’
Subject: [Geoserver-devel] Oracle DataStoreHas 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 LeaderTel: +44 (0) 1749 834922
Email: john.grange@anonymised.comBlueFinger 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.***