I found the problem. I was subclassing the Postgis plugin for my own use
and I had a problem in the constructor. Thanks for your help. David
David Robison wrote:
I modified the file to be:
SELECT DropGeometryColumn('public','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
)
WITHOUT OIDS;
SELECT
AddGeometryColumn('public','inrix_tmc_codes','the_geom','-1','LINESTRING',2);
CREATE INDEX "inrix_tmc_codes_the_geom_gist" ON "inrix_tmc_codes" using
gist ("the_geom" gist_geometry_ops);
but I'm still getting the same error.
13:43:45,265 ERROR [STDERR] org.geotools.data.SchemaNotFoundException:
Feature type could not be found for inrix_tmc_codes
13:43:45,265 ERROR [STDERR] at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:283)
13:43:45,265 ERROR [STDERR] at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getMapper(DefaultFIDMapperFactory.java:97)
13:43:45,265 ERROR [STDERR] at
org.geotools.data.postgis.PostgisDataStore.buildFIDMapper(PostgisDataStore.java:968)
Any other ideas? It seems to be complaining about the primary key. Do I
need to have a specific field name for the key? Thanks in advance, David
Cory Horner wrote:
David Robison wrote:
I have created a Postgis table and am trying to load it into geoserver
and I am getting the following error:
... 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
Try removing the_geom from your create table statement
(AddGeometryColumn does this for you), and use this:
AddGeometryColumn('public','inrix_tmc_codes','the_geom','-1','MULTILINESTRING',2);
The prior statement tried to add a column to a non-existent table in
the schema "", with name "inrixtmccodes".
You'll also be happier if you specify the CRS of your data when you
are importing it; -1 will just cause you trouble later.
Cheers,
Cory.
----
Cory Horner
Refractions Research Inc.
http://www.refractions.net
--
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
