Hello all,
I have created a test enviroment with MySQL and SQL Server 2008 and
PostgreSQL in Windows Server 2008.
I have put a simple table of *points* in all three databases systems.
I have layers working with all the three databases system but I haven't been
able to put a Parametic SQL View working because all them recognize the
point as a byte[].
I have read the other posts where users say there is a workaround. So I have
tried these three solutions:
a) specify the previous version (JDBC 2.0)
b) change the file "featuretype.xml" to
<virtualTable>
<name>test</name>
<sql>SELECT * FROM tbl_code_mercury</sql>
<parameter>
<name>type</name>
<defaultValue>B1C4C032-FFB2-40E4-88FC-2562C7A344E6</defaultValue>
</parameter>
<geometry>
<name>point</name>
<type>MultiPoint</type>
<srid>25832</srid>
</geometry>
</virtualTable>
c) change the Geoserver version, I have tryed from 2.1-RC2 version to
2.1-RC5 ( I have been trying now to make it work for some weeks).
but nothing seems to work!
Any idea if I'm doing anything wrong or it is the same bug persisting in all
versions of 2.1 Geoserver?
Best,
Carlos
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
