Hi, I am having the same issue as described in GEOS-4448. I wrote a quick program to get the information you requested, so here it is. I am using the JDBC driver from Microsoft v3.0 released in March of 2010, I believe, and my database server is SQL Server 2008 R2.
Note that the column #2 is the column that is being reported by geoserver as a byte array. The type Name is "geography" and its type is -3. I hope this helps! column 1 column Name: Name column typeName: varchar column sqlType: 12 column 2 column Name: the_geom column typeName: geography column sqlType: -3 column 3 column Name: longitude column typeName: float column sqlType: 8 column 4 column Name: latitude column typeName: float column sqlType: 8 column 5 column Name: agency column typeName: varchar column sqlType: 12 column 6 column Name: created column typeName: datetime2 column sqlType: 93 -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/GEOS-4448-Resolved-tp6656153p6817359.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
