Re: [Geotools-gt2-users] DataStoreException !

[Leonardo R. <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());
>
>