[Geoserver-devel] problems with postgis-datasource

Jean-Pierre_Praz · September 6, 2003, 9:15pm

hello!

i just installed geoserver 0.98 as a webapplication in tomcat 4.1.24 (jsdk 1.4.2) on win xp. the example in the "topp--road"-directory with the shapefile works perfectly. to get some experience i tried to modify the example so that it works with postgis. i applied shp2sql to road.shp and loaded the data in a table called 'road''. i didn't change the schema.xml but modified the info.xml:

<?xml version="1.0" encoding="UTF-8"?>
<featureType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <Name>road</Name>
         <Title>Random Road Centerlines</Title>
         <Abstract>This is some random road features</Abstract>
         <Keywords>road, New York City, TOPP</Keywords>
         <SRS>-1</SRS>
         <LatLonBoundingBox minx="-74.27000" miny="40.50000" maxx="-73.80000" maxy="40.94000"/>
         <Host>localhost</Host>
         <Port>5432</Port>
         <DatabaseName>test</DatabaseName>
         <User>Jean-Pierre</User>
         <Password/>
         <Dbtype>postgis</Dbtype>
         <Table>road</Table>
</featureType>

now i receive the following exception when i execute a request ( http://127.0.0.1:8081/geoserver/Dispatcher?request=GetFeature&typename=road ):

....
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Searching system properties
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Key 'org.geotools.feature.AttributeTypeFactory' not found
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Searching for service: META-INF/services/org.geotools.feature.AttributeTypeFactory
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Reading Factory , has stream : false
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Service 'META-INF/services/org.geotools.feature.AttributeTypeFactory' not found
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Resorting to default
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Creating instance from 'org.geotools.feature.DefaultAttributeTypeFactory'
  46016 [FEIN] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
  46026 [FEIN] org.vfny.geoserver.responses.WfsException - > [null]:
   UNCAUGHT EXCEPTION: java.lang.NullPointerException
  46026 [FEIN] org.vfny.geoserver.responses.WfsException - return wfs exception is <?xml version="1.0" ?>
<ServiceExceptionReport
    version="1.2.0"
    xmlns="http://www.opengis.net/ogc"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.opengis.net/ogc ../wfs/1.0.0/OGC-exception.xsd">
    <ServiceException>
       UNCAUGHT EXCEPTION: java.lang.NullPointerException
       at java.lang.Class.isAssignableFrom(Native Method)
       at org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:37)
       at org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:73)
       at org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:86)
       at org.geotools.data.postgis.PostgisDataSource.makeSchema(PostgisDataSource.java:274)
....

with LoggingLevel on FINEST i can see, that all connection-parameters from info.xml a read correctly.

do you have an idea what i could do to avoid this exception?

thanks
jpp

Chris_Holmes1 · September 9, 2003, 12:03am

We just figured out this issue off of the list. In case anyone is
wondering, the problem was that shp2pgsql was making the gid column an
int8, which was causing problems with PostgisDataSource, as it doesn't
know how to handle int8's. So if you run into this problem, the temporary
solution is to change your table creation to use int4 instead of int8, and
we will work with the geotools team to fix the issue for the long term.

thanks,

Chris

hello!

i just installed geoserver 0.98 as a webapplication in tomcat 4.1.24 (jsdk
1.4.2) on win xp. the example in the "topp--road"-directory with the
shapefile works perfectly. to get some experience i tried to modify the
example so that it works with postgis. i applied shp2sql to road.shp and
loaded the data in a table called 'road''. i didn't change the schema.xml
but modified the info.xml:

<?xml version="1.0" encoding="UTF-8"?>
<featureType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
         <Name>road</Name>
         <Title>Random Road Centerlines</Title>
         <Abstract>This is some random road features</Abstract>
         <Keywords>road, New York City, TOPP</Keywords>
         <SRS>-1</SRS>
         <LatLonBoundingBox minx="-74.27000" miny="40.50000"
maxx="-73.80000" maxy="40.94000"/>
         <Host>localhost</Host>
         <Port>5432</Port>
         <DatabaseName>test</DatabaseName>
         <User>Jean-Pierre</User>
         <Password/>
         <Dbtype>postgis</Dbtype>
         <Table>road</Table>
</featureType>

now i receive the following exception when i execute a request (
http://127.0.0.1:8081/geoserver/Dispatcher?request=GetFeature&typename=road ):

....
....
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Searching system
properties
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Key
'org.geotools.feature.AttributeTypeFactory' not found
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Searching for
service: META-INF/services/org.geotools.feature.AttributeTypeFactory
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Reading Factory
, has stream : false
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Service
'META-INF/services/org.geotools.feature.AttributeTypeFactory' not found
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Resorting to default
  46016 [AM FEINSTEN] org.geotools.factory.FactoryFinder - Creating
instance from 'org.geotools.feature.DefaultAttributeTypeFactory'
  46016 [FEIN] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager
- Connection closed - adding to available connections.
  46026 [FEIN] org.vfny.geoserver.responses.WfsException - > [null]:
   UNCAUGHT EXCEPTION: java.lang.NullPointerException
  46026 [FEIN] org.vfny.geoserver.responses.WfsException - return wfs
exception is <?xml version="1.0" ?>
<ServiceExceptionReport
    version="1.2.0"
    xmlns="http://www.opengis.net/ogc"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.opengis.net/ogc
../wfs/1.0.0/OGC-exception.xsd">
    <ServiceException>
       UNCAUGHT EXCEPTION: java.lang.NullPointerException
       at java.lang.Class.isAssignableFrom(Native Method)
       at
org.geotools.feature.DefaultAttributeTypeFactory.createAttributeType(DefaultAttributeTypeFactory.java:37)
       at
org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:73)
       at
org.geotools.feature.AttributeTypeFactory.newAttributeType(AttributeTypeFactory.java:86)
       at
org.geotools.data.postgis.PostgisDataSource.makeSchema(PostgisDataSource.java:274)
....
....

with LoggingLevel on FINEST i can see, that all connection-parameters from
info.xml a read correctly.

do you have an idea what i could do to avoid this exception?

thanks
jpp

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel