Thread: [Geotools-gt2-users] DataStoreException !

Toolkit for working with and mapping geospatial data

Brought to you by: aaime, afabiani, cholmesny, cory2070, and 15 others

geotools-gt2-users

[Geotools-gt2-users] DataStoreException !

From: Leonardo R. <leo...@gm...> - 2009-08-27 04:38:13

Hi list!

Map params = new HashMap();
        params.put("dbtype", "postgis");
        //params.put("wkb enabled", "true");
        //params.put("loose bbox", "true");
        params.put("host","localhost");
        params.put("database","geo0");
        params.put("user", "tiresias");
        params.put("port","5432");
        params.put("passwd","1234");
        //params.put("table","streets");

        PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
        DataStore ds = pf.createDataStore(params);
        /*
        PostgisDataStore pds = (PostgisDataStore)ds;
        FeatureSource<SimpleFeatureType,SimpleFeature> fs =
pds.getFeatureSource("streets");

        FeatureCollection<SimpleFeatureType,SimpleFeature> fc =
fs.getFeatures();
        System.out.println(fc.size());
        */
        //CQL.
        Filter filter = CQL.toFilter("stationid < 40");
        String[] getColumns = new String[]
        {
            "geom","streetname"
        };
        Query q = new DefaultQuery("busstation", filter, getColumns);
        FeatureReader fr = ds.getFeatureReader(q, new DefaultTransaction());

Re: [Geotools-gt2-users] DataStoreException !

From: Leonardo R. <leo...@gm...> - 2009-08-27 04:42:39

WTF!  Again:

        params.put("dbtype", "postgis");
        params.put("host","localhost");
        params.put("database","geo0");
        params.put("user", "tiresias");
        params.put("port","5432");
        params.put("passwd","1234");


        PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
        DataStore ds = pf.createDataStore(params);
        Filter filter = CQL.toFilter("stationid < 40");
        String[] getColumns = new String[]
        {
            "geom","streetname"
        };
        Query q = new DefaultQuery("busstation", filter, getColumns);
        FeatureReader fr = ds.getFeatureReader(q, new DefaultTransaction());

        The Error at runtime:

org.geotools.data.DataSourceException: Error querying relation:busstation.
Possible
cause:org/geotools/filter/visitor/SimplifyingFilterVisitor$FIDValidator
    at
org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.java:658)
    at
org.geotools.data.jdbc.FeatureTypeHandler.getFeatureTypeInfo(FeatureTypeHandler.java:198)
    at
org.geotools.data.jdbc.FeatureTypeHandler.getSchema(FeatureTypeHandler.java:166)
    at
org.geotools.data.jdbc.JDBC1DataStore.getSchema(JDBC1DataStore.java:336)
    at
org.geotools.data.postgis.PostgisDataStore.getSchema(PostgisDataStore.java:1934)
    at proyecto1.Servlet1.buildGraph(Servlet1.java:89)
    at proyecto1.Servlet1.init(Servlet1.java:52)
    at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
    at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
    at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
    at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NoClassDefFoundError:
org/geotools/filter/visitor/SimplifyingFilterVisitor$FIDValidator
    at
org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.java:648)
    ... 19 more
Caused by: java.lang.ClassNotFoundException:
org.geotools.filter.visitor.SimplifyingFilterVisitor$FIDValidator
    at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
    at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    ... 20 more

Hints?
Thanks!


2009/8/27 Leonardo Rodriguez <leo...@gm...>

> Hi list!
>
> Map params = new HashMap();
>         params.put("dbtype", "postgis");
>         //params.put("wkb enabled", "true");
>         //params.put("loose bbox", "true");
>         params.put("host","localhost");
>         params.put("database","geo0");
>         params.put("user", "tiresias");
>         params.put("port","5432");
>         params.put("passwd","1234");
>         //params.put("table","streets");
>
>         PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
>         DataStore ds = pf.createDataStore(params);
>         /*
>         PostgisDataStore pds = (PostgisDataStore)ds;
>         FeatureSource<SimpleFeatureType,SimpleFeature> fs =
> pds.getFeatureSource("streets");
>
>         FeatureCollection<SimpleFeatureType,SimpleFeature> fc =
> fs.getFeatures();
>         System.out.println(fc.size());
>         */
>         //CQL.
>         Filter filter = CQL.toFilter("stationid < 40");
>         String[] getColumns = new String[]
>         {
>             "geom","streetname"
>         };
>         Query q = new DefaultQuery("busstation", filter, getColumns);
>         FeatureReader fr = ds.getFeatureReader(q, new
> DefaultTransaction());
>
>

Re: [Geotools-gt2-users] DataStoreException !

From: Leonardo R. <leo...@gm...> - 2009-08-27 05:10:25

It's the last error:
Caused by: java.lang.ClassNotFoundException:
org.geotools.filter.visitor.SimplifyingFilterVisitor$FIDValidator
    at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
    at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
    ... 20 more

When can i find the maven pom data for this class????? It's a newbie
question xD

2009/8/27 Leonardo Rodriguez <leo...@gm...>

> WTF!  Again:
>
>         params.put("dbtype", "postgis");
>         params.put("host","localhost");
>         params.put("database","geo0");
>         params.put("user", "tiresias");
>         params.put("port","5432");
>         params.put("passwd","1234");
>
>
>         PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
>         DataStore ds = pf.createDataStore(params);
>         Filter filter = CQL.toFilter("stationid < 40");
>         String[] getColumns = new String[]
>         {
>             "geom","streetname"
>         };
>         Query q = new DefaultQuery("busstation", filter, getColumns);
>         FeatureReader fr = ds.getFeatureReader(q, new
> DefaultTransaction());
>
>         The Error at runtime:
>
> org.geotools.data.DataSourceException: Error querying relation:busstation.
> Possible
> cause:org/geotools/filter/visitor/SimplifyingFilterVisitor$FIDValidator
>     at
> org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.java:658)
>     at
> org.geotools.data.jdbc.FeatureTypeHandler.getFeatureTypeInfo(FeatureTypeHandler.java:198)
>     at
> org.geotools.data.jdbc.FeatureTypeHandler.getSchema(FeatureTypeHandler.java:166)
>     at
> org.geotools.data.jdbc.JDBC1DataStore.getSchema(JDBC1DataStore.java:336)
>     at
> org.geotools.data.postgis.PostgisDataStore.getSchema(PostgisDataStore.java:1934)
>     at proyecto1.Servlet1.buildGraph(Servlet1.java:89)
>     at proyecto1.Servlet1.init(Servlet1.java:52)
>     at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
>     at
> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>     at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
>     at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
>     at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
>     at java.lang.Thread.run(Thread.java:619)
> Caused by: java.lang.NoClassDefFoundError:
> org/geotools/filter/visitor/SimplifyingFilterVisitor$FIDValidator
>     at
> org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.java:648)
>     ... 19 more
> Caused by: java.lang.ClassNotFoundException:
> org.geotools.filter.visitor.SimplifyingFilterVisitor$FIDValidator
>     at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
>     at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
>     at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
>     ... 20 more
>
> Hints?
> Thanks!
>
>
> 2009/8/27 Leonardo Rodriguez <leo...@gm...>
>
> Hi list!
>>
>> Map params = new HashMap();
>>         params.put("dbtype", "postgis");
>>         //params.put("wkb enabled", "true");
>>         //params.put("loose bbox", "true");
>>         params.put("host","localhost");
>>         params.put("database","geo0");
>>         params.put("user", "tiresias");
>>         params.put("port","5432");
>>         params.put("passwd","1234");
>>         //params.put("table","streets");
>>
>>         PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
>>         DataStore ds = pf.createDataStore(params);
>>         /*
>>         PostgisDataStore pds = (PostgisDataStore)ds;
>>         FeatureSource<SimpleFeatureType,SimpleFeature> fs =
>> pds.getFeatureSource("streets");
>>
>>         FeatureCollection<SimpleFeatureType,SimpleFeature> fc =
>> fs.getFeatures();
>>         System.out.println(fc.size());
>>         */
>>         //CQL.
>>         Filter filter = CQL.toFilter("stationid < 40");
>>         String[] getColumns = new String[]
>>         {
>>             "geom","streetname"
>>         };
>>         Query q = new DefaultQuery("busstation", filter, getColumns);
>>         FeatureReader fr = ds.getFeatureReader(q, new
>> DefaultTransaction());
>>
>>
>
>

Re: [Geotools-gt2-users] DataStoreException !

From: Jody G. <jod...@gm...> - 2009-08-27 07:40:16

Sounds like you are missing some jars .. mvn dependency:tree provides
me with the following:

[INFO] [dependency:tree]
[INFO] org.geotools:gt-wfs:jar:2.6-SNAPSHOT
[INFO] +- org.geotools:gt-wms:jar:2.6-SNAPSHOT:compile
[INFO] |  +- org.geotools:gt-main:jar:2.6-SNAPSHOT:compile
[INFO] |  |  +- com.vividsolutions:jts:jar:1.10:compile
[INFO] |  |  +- jdom:jdom:jar:1.0:compile
[INFO] |  |  \- commons-beanutils:commons-beanutils:jar:1.7.0:compile
[INFO] |  +- org.geotools:gt-coverage:jar:2.6-SNAPSHOT:compile
[INFO] |  +- org.geotools:gt-xml:jar:2.6-SNAPSHOT:compile
[INFO] |  \- commons-lang:commons-lang:jar:2.3:compile
[INFO] +- org.geotools:gt-referencing:jar:2.6-SNAPSHOT:compile
[INFO] |  +- java3d:vecmath:jar:1.3.2:compile
[INFO] |  +- commons-pool:commons-pool:jar:1.3:compile
[INFO] |  \- org.geotools:gt-metadata:jar:2.6-SNAPSHOT:compile
[INFO] |     +- org.opengis:geoapi:jar:2.3-M1:compile
[INFO] |     +- org.opengis:geoapi-pending:jar:2.3-M1:compile
[INFO] |     \- net.java.dev.jsr-275:jsr-275:jar:1.0-beta-2:compile
[INFO] +- org.geotools:gt-sample-data:jar:2.6-SNAPSHOT:test
[INFO] +- org.geotools.xsd:gt-xsd-wfs:jar:2.6-SNAPSHOT:compile
[INFO] |  +- org.geotools.xsd:gt-xsd-filter:jar:2.6-SNAPSHOT:compile
[INFO] |  |  +- org.geotools.xsd:gt-xsd-core:jar:2.6-SNAPSHOT:compile
[INFO] |  |  |  +- org.geotools:gt-graph:jar:2.6-SNAPSHOT:compile
[INFO] |  |  |  +- picocontainer:picocontainer:jar:1.2:compile
[INFO] |  |  |  |  \- xml-apis:xml-apis:jar:1.3.04:compile (version
managed from 1.0.b2)
[INFO] |  |  |  +- xerces:xercesImpl:jar:2.7.1:compile
[INFO] |  |  |  +- xml-apis:xml-apis-xerces:jar:2.7.1:compile
[INFO] |  |  |  +- commons-jxpath:commons-jxpath:jar:1.2:compile
[INFO] |  |  |  |  \- ant:ant-optional:jar:1.5.1:compile
[INFO] |  |  |  +- commons-collections:commons-collections:jar:3.1:compile
[INFO] |  |  |  \- org.eclipse.xsd:xsd:jar:2.2.2:compile
[INFO] |  |  +- org.geotools.xsd:gt-xsd-gml2:jar:2.6-SNAPSHOT:compile
[INFO] |  |  \- org.geotools.xsd:gt-xsd-gml3:jar:2.6-SNAPSHOT:compile
[INFO] |  \- org.geotools.xsd:gt-xsd-ows:jar:2.6-SNAPSHOT:compile
[INFO] +- org.geotools.ogc:net.opengis.wfs:jar:2.6-SNAPSHOT:compile
[INFO] |  +- org.geotools.ogc:net.opengis.ows:jar:2.6-SNAPSHOT:compile
[INFO] |  |  \- org.geotools.ogc:org.w3.xlink:jar:2.6-SNAPSHOT:compile
[INFO] |  +- org.geotools:gt-api:jar:2.6-SNAPSHOT:compile
[INFO] |  +- org.eclipse.emf:common:jar:2.2.1:compile
[INFO] |  \- org.eclipse.emf:ecore:jar:2.2.2:compile
[INFO] +- xpp3:xpp3:jar:1.1.3.4.O:compile
[INFO] +- org.geotools:gt-epsg-hsql:jar:2.6-SNAPSHOT:test
[INFO] |  \- hsqldb:hsqldb:jar:1.8.0.7:test
[INFO] +- commons-httpclient:commons-httpclient:jar:3.1:compile
[INFO] |  +- commons-logging:commons-logging:jar:1.1.1:compile
[INFO] |  \- commons-codec:commons-codec:jar:1.2:compile
[INFO] +- javax.media:jai_core:jar:1.1.3:provided
[INFO] \- junit:junit:jar:4.4:test

Instructions for getting the source code (including the pom.xml file)
are on the wiki; you can download or checkout your choice
(http://docs.codehaus.org/display/GEOT/2+Building).

Jody


On Thu, Aug 27, 2009 at 3:10 PM, Leonardo
Rodriguez<leo...@gm...> wrote:
> It's the last error:
> Caused by: java.lang.ClassNotFoundException:
> org.geotools.filter.visitor.SimplifyingFilterVisitor$FIDValidator
>     at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
>     at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
>     at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
>     ... 20 more
>
> When can i find the maven pom data for this class????? It's a newbie
> question xD
>
> 2009/8/27 Leonardo Rodriguez <leo...@gm...>
>>
>> WTF!  Again:
>>
>>         params.put("dbtype", "postgis");
>>         params.put("host","localhost");
>>         params.put("database","geo0");
>>         params.put("user", "tiresias");
>>         params.put("port","5432");
>>         params.put("passwd","1234");
>>
>>
>>         PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
>>         DataStore ds = pf.createDataStore(params);
>>         Filter filter = CQL.toFilter("stationid < 40");
>>         String[] getColumns = new String[]
>>         {
>>             "geom","streetname"
>>         };
>>         Query q = new DefaultQuery("busstation", filter, getColumns);
>>         FeatureReader fr = ds.getFeatureReader(q, new
>> DefaultTransaction());
>>
>>         The Error at runtime:
>>
>> org.geotools.data.DataSourceException: Error querying relation:busstation.
>> Possible
>> cause:org/geotools/filter/visitor/SimplifyingFilterVisitor$FIDValidator
>>     at
>> org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.java:658)
>>     at
>> org.geotools.data.jdbc.FeatureTypeHandler.getFeatureTypeInfo(FeatureTypeHandler.java:198)
>>     at
>> org.geotools.data.jdbc.FeatureTypeHandler.getSchema(FeatureTypeHandler.java:166)
>>     at
>> org.geotools.data.jdbc.JDBC1DataStore.getSchema(JDBC1DataStore.java:336)
>>     at
>> org.geotools.data.postgis.PostgisDataStore.getSchema(PostgisDataStore.java:1934)
>>     at proyecto1.Servlet1.buildGraph(Servlet1.java:89)
>>     at proyecto1.Servlet1.init(Servlet1.java:52)
>>     at
>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
>>     at
>> org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:809)
>>     at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
>>     at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>>     at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>>     at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>>     at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>>     at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>>     at
>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
>>     at
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
>>     at
>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
>>     at java.lang.Thread.run(Thread.java:619)
>> Caused by: java.lang.NoClassDefFoundError:
>> org/geotools/filter/visitor/SimplifyingFilterVisitor$FIDValidator
>>     at
>> org.geotools.data.postgis.PostgisDataStore.buildSchema(PostgisDataStore.java:648)
>>     ... 19 more
>> Caused by: java.lang.ClassNotFoundException:
>> org.geotools.filter.visitor.SimplifyingFilterVisitor$FIDValidator
>>     at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
>>     at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
>>     at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
>>     ... 20 more
>>
>> Hints?
>> Thanks!
>>
>>
>> 2009/8/27 Leonardo Rodriguez <leo...@gm...>
>>>
>>> Hi list!
>>>
>>> Map params = new HashMap();
>>>         params.put("dbtype", "postgis");
>>>         //params.put("wkb enabled", "true");
>>>         //params.put("loose bbox", "true");
>>>         params.put("host","localhost");
>>>         params.put("database","geo0");
>>>         params.put("user", "tiresias");
>>>         params.put("port","5432");
>>>         params.put("passwd","1234");
>>>         //params.put("table","streets");
>>>
>>>         PostgisDataStoreFactory pf = new PostgisDataStoreFactory();
>>>         DataStore ds = pf.createDataStore(params);
>>>         /*
>>>         PostgisDataStore pds = (PostgisDataStore)ds;
>>>         FeatureSource<SimpleFeatureType,SimpleFeature> fs =
>>> pds.getFeatureSource("streets");
>>>
>>>         FeatureCollection<SimpleFeatureType,SimpleFeature> fc =
>>> fs.getFeatures();
>>>         System.out.println(fc.size());
>>>         */
>>>         //CQL.
>>>         Filter filter = CQL.toFilter("stationid < 40");
>>>         String[] getColumns = new String[]
>>>         {
>>>             "geom","streetname"
>>>         };
>>>         Query q = new DefaultQuery("busstation", filter, getColumns);
>>>         FeatureReader fr = ds.getFeatureReader(q, new
>>> DefaultTransaction());
>>>
>>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Geotools-gt2-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>