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] <mailto:[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]
<mailto:[email protected]>> wrote:
On Thu, Jul 7, 2011 at 11:19 PM, youngblood
<[email protected] <mailto:[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 <tel:%2B39%200584%20962313>
fax: +39 0584 962313 <tel:%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 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
