On Tue, May 31, 2011 at 2:40 PM, Carlos Pinto <cms...@gmail.com> wrote: > Hi Andrea, > > Sorry to take so long to answer. But took me some time to find time to test > it. > > I have now tried the same setup in Linux (Ubuntu) and I get exactly the same > error. > > Now I have GeoServer 2.1-RC5 on TomCat6 in Ubuntu 11.04 and also MySQL 5.1. > Everything is on the same server. > > It recognises the fields when I try to publish a table. > But as soon as I try to publish a Parametric view I get the same as I got in > Windows!!!
Let me repeat my first answer: ------------------------------------------------------------------------------- I believe it's in the same ballpark as this one: http://jira.codehaus.org/browse/GEOS-4528 In fact neither mysql nor sql server implement the unit test for sql views back in Geotools, so not surprised they are not working. ------------------------------------------------------------------------------- Those databases don't have a developer actually using these databases. If you want something that actually works with sql views use PostgreSQL, Oracle or DB2, or else decide to go and modify those stores to work with views properly, or find someone that will do it for you (see commercial support in the home page) 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 ------------------------------------------------------- ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
