It is appreciated if you can keep correspondance on the public list. Thanks.
Well in general I would have to take an example sql view and execute it
against my sql server... and determine what the metadata is that the jdbc
driver is returning back, with each version of the driver we support. Sadly
I have little time for community bug these days but you could help out.
Basically the metadata that is looked up by the datastore when doing the
column to type mappings is the following:
ResultSetMetaData metadata = rs.getMetaData();
>
> for(int i = 1; i < metadata.getColumnCount() + 1; i++) {
>
> ColumnMetadata column = new ColumnMetadata();
>
> column.name = metadata.getColumnName(i);
>
> column.typeName = metadata.getColumnTypeName(i);
>
> column.sqlType = metadata.getColumnType(i);
>
>
>
So if we knew what the driver returns in those cases it would help us narrow
it down? Any chance you can whip up a little jdbc program that does that?
On Tue, Aug 9, 2011 at 1:26 AM, Bisland, Kenneth
<[email protected]>wrote:
> Hi Justin,
>
> Andrea suggested that as you closed GEOS-4448 you may have guidance on
> getting SQL server views to work. Any guidance on how to fix the SQL problem
> in GEOS-4448?
>
> Regards,
>
> Ken
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of
> Andrea Aime
> Sent: 05 August 2011 13:25
> To: Bisland, Kenneth; Justin Deoliveira
> Cc: [email protected]
> Subject: Re: [Geoserver-users] GEOS-4448 Resolved
>
> On Fri, Aug 5, 2011 at 1:06 PM, Bisland, Kenneth
> <[email protected]> wrote:
> > Hi,
> >
> >
> >
> > I am trying to get a SQLview to work from sql2008 and notice that
> GEOS-4448
> > is marked as resolved. Can someone tell me what I need to do to get
> > SQLviews to work as they still seem to be broken.
>
> As far as I can see Justin solved the issue as "not a bug", but there are
> no
> explanations on why/how.
> My latest comment reported that a similar bug was solved in mysql by
> upgrading the jdbc driver, maybe the same is needed in mssql land?
> Don't know, just trying to guess :)
>
> Cheers
> Andrea
>
>
> --
> -------------------------------------------------------
> Ing. Andrea Aime
> GeoSolutions S.A.S.
> Tech lead
>
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
>
> phone: +39 0584 962313
> fax: +39 0584 962313
>
> http://www.geo-solutions.it
> http://geo-solutions.blogspot.com/
> http://www.youtube.com/user/GeoSolutionsIT
> http://www.linkedin.com/in/andreaaime
> http://twitter.com/geowolf
>
> -------------------------------------------------------
>
> **********************************************************************
> This e-mail from Ultra Electronics Limited and any attachments to it are
> confidential to
> the intended recipient and may also be privileged. If you have received it
> in error please
> notify the sender and delete it from your system. If you are not the
> intended recipient
> you must not copy it or use it for any purpose nor disclose or distribute
> its contents to
> any other person. All communications may be subject to interception or
> monitoring for
> operational and/or security purposes. Please rely on your own virus
> checking as the sender
> cannot accept any liability for any damage arising from any bug or virus
> infection.
> Ultra Electronics Limited is a company registered in England and Wales,
> registration number
> 2830644. The address of its registered office is 417 Bridport Road,
> Greenford, Middlesex, UB6 8UA.
> **********************************************************************
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
