Re: [Geoserver-users] Problem with geoserver 2.1 and sql server data store

[Justin D. <jde...@op...>]

This is a known issue.

http://jira.codehaus.org/browse/GEOS-3842

There is a patch sitting there. I will try to get to it soon. However i
remember an issue across jdbc driver versions mapping those columns
differently. Anwywyas, I suggest you sign up to watch the issue so you can
be notified when it is fixed.

Unfortunately at this point the workaround is not to use nvarchar and nchar.

-Justin

On Wed, Nov 10, 2010 at 3:00 PM, Charles Galpin <cg...@lh...> wrote:

> 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
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>



-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.