Hi All Hopefully I have just setup something wrong, but I am attempting to use a sql server 2008 data store and can't create a layer properly.
Geoserver 2.1-beta1 geoserver-2.1-beta1-sqlserver-plugin sqljdbc4.jar from sqljdbc_3.0 download from MS sql server 2008 java 1.6.0_21 on centos 5.5 I setup the store and it shows the tables fine. However when I try publish a table it does not show all the columns (it happens to show the first/pk, the second, and the last/geometry column) and does not pickup the SRS (4326). If I force the SRS it cannot compute the bounds. Checking the logs I see messages about the missing columns, all of which are nvarchar(255) with nulls allowed. 2010-11-10 16:44:37,329 DEBUG [geotools.jdbc] - CREATE CONNECTION 2010-11-10 16:44:37,332 DEBUG [geotools.jdbc] - Getting information about primary keys of MajHwys 2010-11-10 16:44:37,342 DEBUG [geotools.jdbc] - Grabbing table pk metadata: SELECT "ID" FROM "MajHwys" WHERE 0=1 2010-11-10 16:44:37,344 DEBUG [geotools.jdbc] - CLOSE CONNECTION 2010-11-10 16:44:37,344 DEBUG [geotools.jdbc] - CREATE CONNECTION 2010-11-10 16:44:37,351 WARN [geotools.jdbc] - Could not find mapping for 'HIGHWAY_NM', ignoring the column and setting the feature type read only 2010-11-10 16:44:37,352 WARN [geotools.jdbc] - Could not find mapping for 'LANG_CODE', ignoring the column and setting the feature type read only 2010-11-10 16:44:37,352 WARN [geotools.jdbc] - Could not find mapping for 'DIRONSIGN', ignoring the column and setting the feature type read only 2010-11-10 16:44:37,352 WARN [geotools.jdbc] - Could not find mapping for 'FUNC_CLASS', ignoring the column and setting the feature type read only 2010-11-10 16:44:37,352 WARN [geotools.jdbc] - Could not find mapping for 'ROUTE_TYPE', ignoring the column and setting the feature type read only 2010-11-10 16:44:37,352 WARN [geotools.jdbc] - Could not find mapping for 'FERRY_TYPE', ignoring the column and setting the feature type read only Any clues as to what's wrong or how to fix it? thanks, charles ------------------------------------------------------------------------------ The Next 800 Companies to Lead America's Growth: New Video Whitepaper David G. Thomson, author of the best-selling book "Blueprint to a Billion" shares his insights and actions to help propel your business during the next growth cycle. Listen Now! http://p.sf.net/sfu/SAP-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
