Works for me as well.
On Mon, Jul 11, 2011 at 6:08 AM, nyem <[email protected]> wrote:
> I can confirm that upgrading mysql jdbc driver solves the sql view
> creation problem.
>
>
> On 2011-07-10 23:07, brian youngblood wrote:
>
> Just saw the ticket update that you found a known bug in the jdbc driver,
> and it needed upgrading. That's great news. I'll give it a go and post some
> feedback. Thank Andrea. -brian
>
>
> https://jira.codehaus.org/browse/GEOS-4528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=272805<https://jira.codehaus.org/browse/GEOS-4528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=272805#comment-272805>
>
> On Sat, Jul 9, 2011 at 4:38 PM, brian youngblood <
> [email protected]> wrote:
>
>> Gotcha. I'm sure the percentage of users for MySQL is small, but they're
>> out there. A good portion of web developers use MySQL and would likely find
>> this feature useful when considering GeoServer. Not high priority like you
>> said, but worth a shot to see if someone has tackled this issue yet.
>>
>> Thanks again,
>>
>> Brian
>>
>> On Fri, Jul 8, 2011 at 1:16 AM, Andrea Aime <[email protected]
>> > wrote:
>>
>>>
>>> On Thu, Jul 7, 2011 at 11:19 PM, youngblood
>>> <[email protected]>wrote:
>>>
>>>> Was just doing some leg work on this, and filed a bug a while back, but
>>>> wanted to see if anyone was able to solve it on the mailing list. Looks
>>>> like
>>>> a old discussion on the mailing list about it.
>>>>
>>>> I can use MySQL datastore in version 2.1, but cannot create a SQL View.
>>>> Geoserver detects geometry column as byte[]
>>>>
>>>>
>>>> Ideas?
>>>
>>>
>>> The response I added to your jira still applies for both databases that
>>> show this
>>> behavior, MySQL and MSSQL:
>>> http://jira.codehaus.org/browse/GEOS-4528
>>>
>>> Fixing a jdbc sql dialect is not that hard, any proficient java
>>> developer with the
>>> databases installed should be able to do it (for issues related to lack
>>> of
>>> knowledge of the GeoTools API we can help, providing full blown support
>>> for databases that current devs do not use personally and do not drive
>>> business is
>>> another story, unlikely to happen).
>>>
>>> Cheers
>>> Andrea
>>>
>>> --
>>> -------------------------------------------------------
>>> Ing. Andrea Aime
>>> GeoSolutions S.A.S.
>>> Tech lead
>>>
>>> Via Poggio alle Viti 1187
>>> 55054 Massarosa (LU)
>>> Italy
>>>
>>> phone: +39 0584 962313 <%2B39%200584%20962313>
>>> fax: +39 0584 962313 <%2B39%200584%20962313>
>>>
>>> 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
>>>
>>> -------------------------------------------------------
>>>
>>
>>
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.http://p.sf.net/sfu/splunk-d2d-c2
>
>
>
> _______________________________________________
> Geoserver-users mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
