[udig-devel] trying to connect to my PostGIS database

[bartvde@xxxxxxxxx]

Hi list,

I am trying to connect with uDIG 0.9.2 to my PostGIS 1.0 RC4 database on
localhost. I can view data with Mapserver without any problems.

The dialog comes back with 2 tables:

-top10 (the table I am expecting and that I want to view)
-pg_logdir_ls (why does this come back????)

I can't add the layer though, the error stack is pasted below. Can someone
help?

!ENTRY net.refractions.udig.project.ui 4 0 2005-03-29 10:11:11.828
!MESSAGE Feature type could not be found for top10
!STACK 0
org.geotools.data.SchemaNotFoundException: Feature type could not be found
for top10
	at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:264)
	at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getMapper(DefaultFIDMapperFactory.java:61)
	at
org.geotools.data.jdbc.JDBCDataStore.buildFIDMapper(JDBCDataStore.java:1146)
	at
org.geotools.data.jdbc.FeatureTypeHandler.getFIDMapper(FeatureTypeHandler.java:233)
	at
org.geotools.data.jdbc.FeatureTypeHandler.getFeatureTypeInfo(FeatureTypeHandler.java:199)
	at
org.geotools.data.jdbc.FeatureTypeHandler.getSchema(FeatureTypeHandler.java:168)
	at org.geotools.data.jdbc.JDBCDataStore.getSchema(JDBCDataStore.java:499)
	at
net.refractions.udig.catalog.internal.postgis.PostGISGeoResource$IGeoResourceShpInfo.<init>(PostGISGeoResource.java:144)
	at
net.refractions.udig.catalog.internal.postgis.PostGISGeoResource.getInfo(PostGISGeoResource.java:131)
	at
net.refractions.udig.project.internal.impl.LayerFactoryImpl.createDataStoreLayer(LayerFactoryImpl.java:177)
	at
net.refractions.udig.project.internal.impl.LayerFactoryImpl.createLayer(LayerFactoryImpl.java:259)
	at
net.refractions.udig.project.ui.internal.ProjectUIPlugin.processResources(ProjectUIPlugin.java:470)
	at
net.refractions.udig.project.ui.internal.ProjectUIPlugin$1.run(ProjectUIPlugin.java:289)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:66)
Caused by: org.postgresql.util.PSQLException: Onbekend antwoord type
	at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:191)
	at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
	at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
	at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
	at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
	at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
	at
org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.getPrimaryKeys(AbstractJdbc1DatabaseMetaData.java:2930)
	at
org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:218)
	... 13 more

Best regards,
Bart