[Geoserver-devel] Oracle and Geoserver 1.1 beta

GeoServer GeoServer Developer
1

I am trying to get Geoserver 1.1 (beta) to talk to my Oracle Spatial
database. I have got this working in Geoserver 1.0.1 but cannot get it
right for 1.1. My main problem is the new 'schema' field in the catalog.xml
file. What value is this supposed to hold? The tablename? (this is what I
have been using)

Here's what I have in the geoserver\WEB-INF\catalog.xml file:
   <datastore id="oracle.kimbaqldrstn" enabled="true" namespace="cdf">
      <description>Kimba Oracle Database QLD Railway Stations</description>
      <connectionParams>
        <parameter name="dbtype" value="oracle"/>
        <parameter name="host" value="kimba"/>
        <parameter name="port" value="1521"/>
        <parameter name="instance" value="kimba"/>
        <parameter name="user" value="gnaf_tas"/>
        <parameter name="passwd" value="gnaf"/>
        <parameter name="schema" value="QLDRSTN"/>
      </connectionParams>
    </datastore>

And heres what I have in the
geoserver\data\featureTypes\qldrstn_ora\info.xml file:
  <featureType datastore="oracle.kimbaqldrstn">
        <name>qldrstn_ora</name>
        <SRS>8311</SRS><!-- native wich EPGS code for the FeatureType -->
        <title>test</title>
        <abstract>Test</abstract>
        <keywords>Queensland</keywords>
        <latLonBoundingBox dynamic="false" minx="137" miny="-30" maxx="157"
maxy="-16"/>
      <!-- the list of styles this FeatureType can be represented by.
        at least must contain the "default" attribute -->
      <styles default="normal"/>
  </featureType>

The error I keep getting is:
C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver\data\featureTypes\qldrst
n_ora\info.xml
In FeatureTypeConfig.getSchema()
1201 [FINE] org.geotools.data.jdbc.JDBCDataStore - creating new locking
manager
org.geotools.data.InProcessLockingManager@anonymised.com
1211 [FINE] org.geotools.data.jdbc.ConnectionPool - No available
connections, c
reating a new one.
3134 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Conne
ction closed - adding to available connections.
3144 [FINE] org.vfny.geoserver.config.DataStoreConfig - connection
established
by DataStoreConfig[namespace=cdf, enabled=true, abstract=null, connection
parame
ters={user=gnaf_tas, instance=kimba, passwd=gnaf, host=kimba,
schema=GNAF_TAS, p
ort=1521, dbtype=oracle}]
3154 [INFO] org.geotools.data.jdbc.JDBCDataStore - returning locking
manager or
g.geotools.data.InProcessLockingManager@anonymised.com
org.geotools.data.SchemaNotFoundException: Feature type could not be found
for q
ldrstn_ora
        at
org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:247
)
        at
org.geotools.data.jdbc.JDBCDataStore.getFeatureSource(JDBCDataStore.j
ava:338)
        at
org.vfny.geoserver.config.FeatureTypeConfig.getRealFeatureSource(Feat
ureTypeConfig.java:352)
        at
org.vfny.geoserver.config.FeatureTypeConfig.getSchema(FeatureTypeConf
ig.java:470)
        at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:148)
        at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:471)
        at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
        at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
        at
org.vfny.geoserver.config.CatalogConfig.<init>(CatalogConfig.java:190
)
        at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:318)
        at
org.vfny.geoserver.config.ServerConfig.<init>(ServerConfig.java:95)
        at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:205)
        at org.vfny.geoserver.servlets.FreefsLog.init(FreefsLog.java:50)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:916)
        at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:80
8)
        at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3266)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3
395)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
org.vfny.geoserver.config.ConfigurationException: Error obtaining schema for
cdf
:qldrstn_ora: Feature type could not be found for qldrstn_ora
        at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:151)
        at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:471)
        at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
        at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
        at
org.vfny.geoserver.config.CatalogConfig.<init>(CatalogConfig.java:190
)
        at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:318)
        at
org.vfny.geoserver.config.ServerConfig.<init>(ServerConfig.java:95)
        at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:205)
        at org.vfny.geoserver.servlets.FreefsLog.init(FreefsLog.java:50)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:916)
        at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:80
8)
        at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3266)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3
395)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
Caused by: org.geotools.data.SchemaNotFoundException: Feature type could not
be
found for qldrstn_ora
        at
org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:247
)
        at
org.geotools.data.jdbc.JDBCDataStore.getFeatureSource(JDBCDataStore.j
ava:338)
        at
org.vfny.geoserver.config.FeatureTypeConfig.getRealFeatureSource(Feat
ureTypeConfig.java:352)
        at
org.vfny.geoserver.config.FeatureTypeConfig.getSchema(FeatureTypeConf
ig.java:470)
        at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:148)
        ... 27 more
3495 [WARNING] org.vfny.geoserver.config.CatalogConfig - could not add
FeatureT
ype at C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver\data\featureTypes
\qldrstn_ora\info.xml due to
org.vfny.geoserver.config.ConfigurationException: E
rror obtaining schema for cdf:qldrstn_ora: Feature type could not be found
for q
ldrstn_ora

Thanks
Bronwyn

2

The schema parameter allows you to specify the oracle schema that the table is within, it is optional and only really needs to be specified to prevent clashes when there are tables of the same name in different schemas. The default schema name for a table in oracle is the user name of the creator of the table. You should be able to find more info in the Oracle docs.

Sean

Bronwyn Cook wrote:

I am trying to get Geoserver 1.1 (beta) to talk to my Oracle Spatial
database. I have got this working in Geoserver 1.0.1 but cannot get it
right for 1.1. My main problem is the new 'schema' field in the catalog.xml
file. What value is this supposed to hold? The tablename? (this is what I
have been using)

Here's what I have in the geoserver\WEB-INF\catalog.xml file:
  <datastore id="oracle.kimbaqldrstn" enabled="true" namespace="cdf">
     <description>Kimba Oracle Database QLD Railway Stations</description>
     <connectionParams>
       <parameter name="dbtype" value="oracle"/>
       <parameter name="host" value="kimba"/>
       <parameter name="port" value="1521"/>
       <parameter name="instance" value="kimba"/>
       <parameter name="user" value="gnaf_tas"/>
       <parameter name="passwd" value="gnaf"/>
       <parameter name="schema" value="QLDRSTN"/>
     </connectionParams>
   </datastore>

And heres what I have in the
geoserver\data\featureTypes\qldrstn_ora\info.xml file:
<featureType datastore="oracle.kimbaqldrstn">
       <name>qldrstn_ora</name>
       <SRS>8311</SRS><!-- native wich EPGS code for the FeatureType -->
       <title>test</title>
       <abstract>Test</abstract>
       <keywords>Queensland</keywords>
       <latLonBoundingBox dynamic="false" minx="137" miny="-30" maxx="157"
maxy="-16"/>
     <!-- the list of styles this FeatureType can be represented by.
       at least must contain the "default" attribute -->
     <styles default="normal"/>
</featureType>

The error I keep getting is:
C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver\data\featureTypes\qldrst
n_ora\info.xml
In FeatureTypeConfig.getSchema()
1201 [FINE] org.geotools.data.jdbc.JDBCDataStore - creating new locking
manager
org.geotools.data.InProcessLockingManager@anonymised.com
1211 [FINE] org.geotools.data.jdbc.ConnectionPool - No available
connections, c
reating a new one.
3134 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Conne
ction closed - adding to available connections.
3144 [FINE] org.vfny.geoserver.config.DataStoreConfig - connection
established
by DataStoreConfig[namespace=cdf, enabled=true, abstract=null, connection
parame
ters={user=gnaf_tas, instance=kimba, passwd=gnaf, host=kimba,
schema=GNAF_TAS, p
ort=1521, dbtype=oracle}]
3154 [INFO] org.geotools.data.jdbc.JDBCDataStore - returning locking
manager or
g.geotools.data.InProcessLockingManager@anonymised.com
org.geotools.data.SchemaNotFoundException: Feature type could not be found
for q
ldrstn_ora
       at
org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:247
)
       at
org.geotools.data.jdbc.JDBCDataStore.getFeatureSource(JDBCDataStore.j
ava:338)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getRealFeatureSource(Feat
ureTypeConfig.java:352)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getSchema(FeatureTypeConf
ig.java:470)
       at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:148)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:471)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.<init>(CatalogConfig.java:190
)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:318)
       at
org.vfny.geoserver.config.ServerConfig.<init>(ServerConfig.java:95)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:205)
       at org.vfny.geoserver.servlets.FreefsLog.init(FreefsLog.java:50)
       at javax.servlet.GenericServlet.init(GenericServlet.java:258)
       at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:916)
       at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:80
8)
       at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3266)
       at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3
395)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
       at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
       at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
       at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
       at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
org.vfny.geoserver.config.ConfigurationException: Error obtaining schema for
cdf
:qldrstn_ora: Feature type could not be found for qldrstn_ora
       at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:151)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:471)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.<init>(CatalogConfig.java:190
)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:318)
       at
org.vfny.geoserver.config.ServerConfig.<init>(ServerConfig.java:95)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:205)
       at org.vfny.geoserver.servlets.FreefsLog.init(FreefsLog.java:50)
       at javax.servlet.GenericServlet.init(GenericServlet.java:258)
       at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:916)
       at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:80
8)
       at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3266)
       at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3
395)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
       at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
       at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
       at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
       at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
Caused by: org.geotools.data.SchemaNotFoundException: Feature type could not
be
found for qldrstn_ora
       at
org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:247
)
       at
org.geotools.data.jdbc.JDBCDataStore.getFeatureSource(JDBCDataStore.j
ava:338)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getRealFeatureSource(Feat
ureTypeConfig.java:352)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getSchema(FeatureTypeConf
ig.java:470)
       at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:148)
       ... 27 more
3495 [WARNING] org.vfny.geoserver.config.CatalogConfig - could not add
FeatureT
ype at C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver\data\featureTypes
\qldrstn_ora\info.xml due to
org.vfny.geoserver.config.ConfigurationException: E
rror obtaining schema for cdf:qldrstn_ora: Feature type could not be found
for q
ldrstn_ora

Thanks
Bronwyn

-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

3

I made the following changes to try and get Geoserver talking to Oracle:
1. Renamed the feature type from qldrstn_ora to QLDRSTN (the actual table
name, in uppercase)
2. Removed the schema reference from the category.xml file (as it is not
required in this case)

But now I can't even get the server up. When I try and do a GetCapabilities
request I get the following error in the browser window:

javax.servlet.ServletException: Error instantiating servlet class
org.vfny.geoserver.servlets.wfs.Capabilities
  at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:89
3)
  at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:653)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:214)
      ...
root cause
java.lang.ExceptionInInitializerError
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
  at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
      ...
Caused by: java.lang.IllegalStateException: The server configuration has not
been loaded yet
  at
org.vfny.geoserver.config.ServerConfig.getInstance(ServerConfig.java:190)
  at org.vfny.geoserver.servlets.AbstractService.(AbstractService.java:82)
  ... 36 more

Its directly related to the QLDRSTN feature type because when I get rid of
it (ie. delete the QLDRSTN directory from the featureTypes directory and
restart) everything works OK again. The funny thing is though is that no
errors are reported in the logging. Below is an excerpt of the logging (to
do with loading the oracle connection).

1122 [FINE] org.vfny.geoserver.config.ServerConfig - loading configuration
file
C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver11b\data\featureTypes\QLDRSTN\in
fo.xml
In FeatureTypeConfig.getSchema()
1352 [FINE] org.geotools.data.jdbc.JDBCDataStore - creating new locking
manager
org.geotools.data.InProcessLockingManager@anonymised.com
1352 [FINE] org.geotools.data.jdbc.ConnectionPool - No available
connections, creating a new one.
4687 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Connection closed - adding to available connections.
4687 [FINE] org.vfny.geoserver.config.DataStoreConfig - connection
established by DataStoreConfig[namespace=cdf,enabled=true, abstract=null,
connection parameters={user=gnaf_tas, instance=kimba, passwd=gnaf,
host=kimba, port=1521, dbtype=oracle}]
4687 [INFO] org.geotools.data.jdbc.JDBCDataStore - returning locking
manager org.geotools.data.InProcessLockingManager@anonymised.com
4727 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
4937 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Connection closed - adding to available connections.
4947 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
5087 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Connection closed - adding to available connections.
5097 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
5127 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Connection closed - adding to available connections.
Starting service Tomcat-Apache
Apache Tomcat/4.0.3

I'll list the contents of my config files here again, just in case you need
them...

catalog.xml (the oracle connection extract)
-------------------------------------------

   <datastore id="oracle.kimba" enabled="true" namespace="cdf">
      <description>Kimba Oracle Database QLD Railway Stations</description>
      <connectionParams>
        <parameter name="dbtype" value="oracle"/>
        <parameter name="host" value="kimba"/>
        <parameter name="port" value="1521"/>
        <parameter name="instance" value="kimba"/>
        <parameter name="user" value="gnaf_tas"/>
        <parameter name="passwd" value="gnaf"/>
      </connectionParams>
    </datastore>

info.xml (in the geoserver\data\featureTypes\QLDRSTN directory)
---------------------------------------------------------------
  <featureType datastore="oracle.kimba">
        <name>QLDRSTN</name>
        <SRS>8311</SRS><!-- native wich EPGS code for the FeatureType -->
        <title>test</title>
        <abstract>Test</abstract>
        <keywords>Queensland</keywords>
        <latLonBoundingBox dynamic="false" minx="137" miny="-30" maxx="157"
maxy="-16"/>
      <!-- the list of styles this FeatureType can be represented by.
        at least must contain the "default" attribute -->
      <styles default="normal"/>

  </featureType>

Cheers
Bronwyn

-----Original Message-----
From: Sean Geoghegan [mailto:sean@anonymised.com]
Sent: Monday, 22 December 2003 1:23 PM
To: Bronwyn Cook
Cc: Geoserver List
Subject: Re: [Geoserver-devel] Oracle and Geoserver 1.1 beta

The schema parameter allows you to specify the oracle schema that the
table is within, it is optional and only really needs to be specified to
prevent clashes when there are tables of the same name in different
schemas. The default schema name for a table in oracle is the user name
of the creator of the table. You should be able to find more info in
the Oracle docs.

Sean

Bronwyn Cook wrote:

I am trying to get Geoserver 1.1 (beta) to talk to my Oracle Spatial
database. I have got this working in Geoserver 1.0.1 but cannot get it
right for 1.1. My main problem is the new 'schema' field in the

catalog.xml

file. What value is this supposed to hold? The tablename? (this is what I
have been using)

Here's what I have in the geoserver\WEB-INF\catalog.xml file:
  <datastore id="oracle.kimbaqldrstn" enabled="true" namespace="cdf">
     <description>Kimba Oracle Database QLD Railway Stations</description>
     <connectionParams>
       <parameter name="dbtype" value="oracle"/>
       <parameter name="host" value="kimba"/>
       <parameter name="port" value="1521"/>
       <parameter name="instance" value="kimba"/>
       <parameter name="user" value="gnaf_tas"/>
       <parameter name="passwd" value="gnaf"/>
       <parameter name="schema" value="QLDRSTN"/>
     </connectionParams>
   </datastore>

And heres what I have in the
geoserver\data\featureTypes\qldrstn_ora\info.xml file:
<featureType datastore="oracle.kimbaqldrstn">
       <name>qldrstn_ora</name>
       <SRS>8311</SRS><!-- native wich EPGS code for the FeatureType -->
       <title>test</title>
       <abstract>Test</abstract>
       <keywords>Queensland</keywords>
       <latLonBoundingBox dynamic="false" minx="137" miny="-30"

maxx="157"

maxy="-16"/>
     <!-- the list of styles this FeatureType can be represented by.
       at least must contain the "default" attribute -->
     <styles default="normal"/>
</featureType>

The error I keep getting is:
C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver\data\featureTypes\qldrst
n_ora\info.xml
In FeatureTypeConfig.getSchema()
1201 [FINE] org.geotools.data.jdbc.JDBCDataStore - creating new locking
manager
org.geotools.data.InProcessLockingManager@anonymised.com
1211 [FINE] org.geotools.data.jdbc.ConnectionPool - No available
connections, c
reating a new one.
3134 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
Conne
ction closed - adding to available connections.
3144 [FINE] org.vfny.geoserver.config.DataStoreConfig - connection
established
by DataStoreConfig[namespace=cdf, enabled=true, abstract=null, connection
parame
ters={user=gnaf_tas, instance=kimba, passwd=gnaf, host=kimba,
schema=GNAF_TAS, p
ort=1521, dbtype=oracle}]
3154 [INFO] org.geotools.data.jdbc.JDBCDataStore - returning locking
manager or
g.geotools.data.InProcessLockingManager@anonymised.com
org.geotools.data.SchemaNotFoundException: Feature type could not be found
for q
ldrstn_ora
       at
org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:247
)
       at
org.geotools.data.jdbc.JDBCDataStore.getFeatureSource(JDBCDataStore.j
ava:338)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getRealFeatureSource(Feat
ureTypeConfig.java:352)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getSchema(FeatureTypeConf
ig.java:470)
       at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:148)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:471)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.<init>(CatalogConfig.java:190
)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:318)
       at
org.vfny.geoserver.config.ServerConfig.<init>(ServerConfig.java:95)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:205)
       at org.vfny.geoserver.servlets.FreefsLog.init(FreefsLog.java:50)
       at javax.servlet.GenericServlet.init(GenericServlet.java:258)
       at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:916)
       at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:80
8)
       at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3266)
       at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3
395)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
       at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
       at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
       at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
       at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
org.vfny.geoserver.config.ConfigurationException: Error obtaining schema

for

cdf
:qldrstn_ora: Feature type could not be found for qldrstn_ora
       at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:151)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:471)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.loadFeatureTypes(CatalogConfi
g.java:462)
       at
org.vfny.geoserver.config.CatalogConfig.<init>(CatalogConfig.java:190
)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:318)
       at
org.vfny.geoserver.config.ServerConfig.<init>(ServerConfig.java:95)
       at
org.vfny.geoserver.config.ServerConfig.load(ServerConfig.java:205)
       at org.vfny.geoserver.servlets.FreefsLog.init(FreefsLog.java:50)
       at javax.servlet.GenericServlet.init(GenericServlet.java:258)
       at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:916)
       at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:80
8)
       at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3266)
       at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3
395)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
       at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

       at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
       at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
       at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
       at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
       at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
Caused by: org.geotools.data.SchemaNotFoundException: Feature type could

not

be
found for qldrstn_ora
       at
org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:247
)
       at
org.geotools.data.jdbc.JDBCDataStore.getFeatureSource(JDBCDataStore.j
ava:338)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getRealFeatureSource(Feat
ureTypeConfig.java:352)
       at
org.vfny.geoserver.config.FeatureTypeConfig.getSchema(FeatureTypeConf
ig.java:470)
       at
org.vfny.geoserver.config.FeatureTypeConfig.<init>(FeatureTypeConfig.
java:148)
       ... 27 more
3495 [WARNING] org.vfny.geoserver.config.CatalogConfig - could not add
FeatureT
ype at C:\Program
Files\jakarta-tomcat-4.0.3\webapps\geoserver\data\featureTypes
\qldrstn_ora\info.xml due to
org.vfny.geoserver.config.ConfigurationException: E
rror obtaining schema for cdf:qldrstn_ora: Feature type could not be found
for q
ldrstn_ora

Thanks
Bronwyn

-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel