I have created a Postgis table and am trying to load it into geoserver
and I am getting the following error:
09:58:10,343 ERROR [STDERR] org.geotools.data.SchemaNotFoundException:
Feature type could not be found for inrix_tmc_codes
09:58:10,343 ERROR [STDERR] at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:283)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getMapper(DefaultFIDMapperFactory.java:97)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.postgis.PostgisDataStore.buildFIDMapper(PostgisDataStore.java:968)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.jdbc.FeatureTypeHandler.getFIDMapper(FeatureTypeHandler.java:234)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.jdbc.FeatureTypeHandler.getFeatureTypeInfo(FeatureTypeHandler.java:200)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.jdbc.FeatureTypeHandler.getSchema(FeatureTypeHandler.java:169)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.jdbc.JDBC1DataStore.getSchema(JDBC1DataStore.java:368)
09:58:10,343 ERROR [STDERR] at
org.geotools.data.postgis.PostgisDataStore.getSchema(PostgisDataStore.java:1869)
The version of geoserver that I am using is using gt2 version
2.2.3-SNAPSHOT. Any idea what the problem might be? The code I used to
create the table is:
SELECT DropGeometryColumn('','inrix_tmc_codes','the_geom');
DROP TABLE "inrix_tmc_codes";
BEGIN;
CREATE TABLE "inrix_tmc_codes" (gid serial PRIMARY KEY,
"market_code" int4,
"region" int4,
"tmc_code" int4,
"direction" char(1),
"speed" int4,
"color" int4,
"route" varchar(254),
"start_mm" numeric,
"end_mm" numeric,
the_geom geometry
)
WITHOUT OIDS;
SELECT
AddGeometryColumn('','inrixtmccodes','the_geom','-1','MULTILINESTRING',2);
CREATE INDEX "inrix_tmc_codes_the_geom_gist" ON "inrix_tmc_codes" using
gist ("the_geom" gist_geometry_ops);
Any help would be appreciated. Thanks, David
--
David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: [EMAIL PROTECTED]
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/bookstore/titles/1597816523.htm
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-gt2-users mailing list
Geotools-gt2-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
