Hi Farouk,
I think you just have to remove the ";" after the statement.
-Justin
On Thu, Sep 9, 2010 at 8:44 AM, farouk alhassan <[email protected]>wrote:
> Hi,
> I am trying to enter the following sql into the new SQL View Editor.
>
> SELECT
> "Regions"."gid" as rgid,
> "Regions"."name" as rname,
> district_borough_unitary_region.gid,
> district_borough_unitary_region."name",
> district_borough_unitary_region.area_code,
> district_borough_unitary_region.descriptio,
> district_borough_unitary_region.file_name,
> district_borough_unitary_region."number",
> district_borough_unitary_region.number0,
> district_borough_unitary_region.unit_id,
> district_borough_unitary_region.polygon_id,
> district_borough_unitary_region.code,
> district_borough_unitary_region.hectares,
> district_borough_unitary_region.area,
> district_borough_unitary_region.type_code,
> district_borough_unitary_region.descript0,
> district_borough_unitary_region.type_cod0,
> district_borough_unitary_region.descript1,
> district_borough_unitary_region.the_geom
> FROM
> public."Regions" INNER JOIN
> public.district_borough_unitary_region
> ON
> ST_Intersects("Regions".the_geom,district_borough_unitary_region.the_geom)
> where "Regions"."gid" = 1;
>
> When I run it I get this error
>
> Failed to create SQL view: ERROR: syntax error at or near ";" Position:
> 1027
>
> but the same sql works perfectly well in pgAdmin III.
>
> Getting rid of the where clause fixes the problem but I really need to
> filter the results since the dataset is too large.
>
> Any Ideas what I may be doing wrong?
>
> Thanks
> Farouk A
>
>
> --- On *Thu, 9/9/10, farouk alhassan <[email protected]>* wrote:
>
>
> From: farouk alhassan <[email protected]>
>
> Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a
> new SQL view
> To: [email protected]
> Date: Thursday, 9 September, 2010, 4:16
>
>
>
> Hi Justin,
> Thanks for the tip. I deleted my whole tomcat installation and installed a
> new version and deployed new version of the geoserver war file and the links
> now appear.
>
> May have been caused by traces of my previous geoserver war still being
> held on to by tomcat.
>
> Thanks for the help. Very much appreciated
>
> Regards
> Farouk A
> --- On *Wed, 8/9/10, Justin Deoliveira <[email protected]>* wrote:
>
>
> From: Justin Deoliveira <[email protected]>
> Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a
> new SQL view
> To: [email protected]
> Date: Wednesday, 8 September, 2010, 23:41
>
> Hi Farouk,
>
> It is appreciated if you can keep all correspondance on the public list.
> Thanks.
>
> So this seems strange. If you have a postgis store setup and are not seeing
> the links when you add a new layer it leads me to believe there is an issue
> with the installation. Perhaps some old versions of the geoserver jars
> around.
>
> Can you navigate to the WEB-INF/lib directory of the geoserver installation
> and verify that only 2.1-beta jars are present. What type of setup are you
> running? Windows installer? platform independent binary?
>
> On Wed, Sep 8, 2010 at 7:55 PM, farouk alhassan <[email protected]>wrote:
>
> Hi
> I'm trying with PostGIS.
>
> Regards
> Farouk A
>
> --- On *Wed, 8/9/10, Justin Deoliveira <[email protected]>* wrote:
>
>
> From: Justin Deoliveira <[email protected]>
> Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a
> new SQL view
> To: "farouk alhassan" <[email protected]>
> Cc: [email protected]
> Date: Wednesday, 8 September, 2010, 9:31
>
>
> Hi Farouk,
>
> Are you trying with arcsde? Or another database?
>
> On Wed, Sep 8, 2010 at 7:06 AM, farouk alhassan
> <[email protected]<http://mc/[email protected]>
> > wrote:
>
>
> Hi
> I am also trying to do the same thing but could not find any of the links
> mentioned in the article.
>
> I'm using this document as a guide
>
> http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html
>
> Let me know if you make any progress on it.
>
> Regards
>
> Farouk A
>
> --- On *Wed, 8/9/10,
> [email protected]<http://mc/[email protected]>
> <[email protected]<http://mc/[email protected]>
> >* wrote:
>
>
> From:
> [email protected]<http://mc/[email protected]><
> [email protected]<http://mc/[email protected]>
> >
> Subject: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
> SQL view
> To:
> [email protected]<http://mc/[email protected]>
> Date: Wednesday, 8 September, 2010, 3:16
>
>
>
> Hi All,
>
> I have installed GeoServer 2.1-beta1 onto my local PC to try out the new
> SQL views.
>
> When I go to add new ArcSDE layers, at the bottom of the page I have the
> option to create new feature type, but there is nothing to allow me to
> configure a new SQL view.
>
> Is there something I missed when installing, or is this option only
> available to some databases?
>
> Cheers,
>
> Sonya
>
> -----Inline Attachment Follows-----
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> Geoserver-users mailing list
> [email protected]<http://mc/[email protected]>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> Geoserver-users mailing list
> [email protected]<http://mc/[email protected]>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
>
>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
>
> -----Inline Attachment Follows-----
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
> -----Inline Attachment Follows-----
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> Geoserver-users mailing list
> [email protected]<http://mc/[email protected]>
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
