Hi Chris,
No problem, new users welcome :)
The workflow for any database supported by jdbc is essentially the same. The
only thing that changes are the database connection parameters. You can
learn about them in the docs [1]. And the dbtype for sql server is
"sqlserver".
An easy way to find out what the exact params are for the REST call is to
first add the sql server datastore manually, and then grab its configuration
with a REST call like:
curl -G http://.../geoserver/rest/workspaces/foo/stores/mySqlServerStore.xml
And yes, i believe you should be able to do this without a line of java code
:) As long as your .net app can connect to the db and create the new table
which i assume it can.
-Justin
[1] http://docs.geoserver.org/stable/en/user/data/sqlserver.html
On Thu, Sep 9, 2010 at 4:47 PM, Jones, Christopher <
[email protected]> wrote:
> Thanks again, and sorry again!
>
>
>
> The example you provided seems to explain how to add a PostGIS database and
> database, is this the same then for MS SQL Server databases? I thought
> there was a need to use the JDBC driver… Also, having now downloaded cURL, I
> getting myself confused with intergrating all this with the Eclipse version
> of Geoserver. Have I massively over complicated this and all I need to do
> is stick with the 'out of the box' Geoserver, sending the command line calls
> via .NET?
>
>
>
> Its probably obvious this is new territory for me!
>
>
>
> Im using .NET to communicate with the server to create spatial tables, its
> just then connecting them with Geoserver. I kind of expected to have to
> pick up some Java, but if its not needed then all the better at this stage!
>
>
>
>
>
>
>
> *From:* Justin Deoliveira [mailto:[email protected]]
> *Sent:* 09 September 2010 13:28
>
> *To:* Jones, Christopher
> *Cc:* [email protected]
> *Subject:* Re: [Geoserver-users] SQL 2008 - Eclipse
>
>
>
> Hi Chris,
>
>
>
> Nope, not complicated at all, good questions :)
>
>
>
> Unfortunately creating new feature types on the fly is something we would
> really like to do soon, but have not gotten around to. But in the case of
> databases, if a table already exists in the database you can add it to
> geoserver using the restconfig api [1].
>
>
>
> So essentially you would have to find some way to create the table and then
> once created make the REST call. And then configure the OL map to load up
> the new layer.
>
>
>
> Hope that helps.
>
>
>
> [1]
> http://docs.geoserver.org/stable/en/user/extensions/rest/rest-config-examples-curl.html#adding-a-postgis-table
>
> On Thu, Sep 9, 2010 at 12:37 PM, Jones, Christopher <
> [email protected]> wrote:
>
> Hi Justin
>
>
>
> Thanks for your quick response.
>
>
>
> I have already connected Geoserver to SQL 2008 and successfully created WMS
> layers. My aim is now to create WMS layers based on data that changes
> regularly and for this reason, rightly or wrongly, I thought I would have to
> go down the Maven/Eclipse route.
>
>
>
> Ideally what I am after is for a user to say, hit a button which creates a
> layer/table in SQL 2008, which is then displayed via Geoserver and
> Openlayers as a WMS layer.
>
>
>
> What I am unsure about is how to or where to add the functionality to
> Eclipse to connect to SQL Server 2008 (Geoserver patch and JDBC driver), and
> then adding the datasource/layers/styles.
>
>
>
> I'm sorry if this is quite complicated, I just couldn’t seem to extract how
> to do this from the various bits of documentation.
>
>
>
> Again, thanks for any help here!
>
>
>
> Chris
>
>
>
> *From:* Justin Deoliveira [mailto:[email protected]]
> *Sent:* 09 September 2010 11:29
> *To:* Jones, Christopher
> *Cc:* [email protected]
> *Subject:* Re: [Geoserver-users] SQL 2008 - Eclipse
>
>
>
> Hi Chris,
>
>
>
> So you are looking to patch existing geoserver functionality? If so you
> will probably want to checkout some things in the developer guide:
>
>
>
> http://docs.geoserver.org/stable/en/developer/quickstart/index.html
>
> http://docs.geoserver.org/stable/en/developer/maven-guide/index.html
>
> http://docs.geoserver.org/stable/en/developer/eclipse-guide/index.html
>
>
>
> If you are just looking to connect geoserver to sql server you can do that
> pretty much out of the box. You just need to download the sql server
> extension [1] and then install the jdbc driver from microsoft. As for
> creating thematic maps with geoserver that is also available out the box and
> documented [2].
>
>
>
> Hope that helps.
>
>
>
> -Justin
>
>
>
> [1] http://docs.geoserver.org/stable/en/user/data/sqlserver.html
>
> [2] http://docs.geoserver.org/stable/en/user/styling/index.html
>
>
>
> On Thu, Sep 9, 2010 at 11:29 AM, Jones, Christopher <
> [email protected]> wrote:
>
> Hi all,
>
>
>
> I'm pretty new to geoserver, although what I've seen so far is impressive,
> however, I'm not sure I have bitten off more than I can chew here so any
> advice here would be extremely welcome.
>
>
>
> I'm working on an OpenLayers web app, using SQL 2008 to do the more
> complicated spatial calculations and so on. What I have been tasked with
> doing now is adding in thematic WMS layers to show exposure level etc. Now
> so far I have been able to download, install, and create WMS from SQL 2008
> Server, and now I need to make this a more dynamic affair. I have
> downloaded Maven, and Eclipse and successfully install these (which seems to
> have disabled my original instance of Geoserver) and can display the demo
> WMS layers in OpenLayers, but I am almost completely at a loss as to how I:
>
>
>
> a) install the JDBC driver
>
> b) add the SQL patch/module for Geoserver to Eclipse
>
> c) add any custom data to Eclipse
>
>
>
> …and so on.
>
>
>
> Any help what so ever would be extremely welcome! I have been through the
> documentation and it still doesn’t seem at all clear.
>
>
>
> Thank you all in advance
>
>
>
> Chris
>
> IMPORTANT - This email and the information that it contains may be
> confidential, legally privileged and protected by law. Access by the
> intended recipient only is authorised. Any liability (in negligence or
> otherwise) arising from any third party acting, or refraining from acting,
> on any information contained in this email is hereby excluded. If you are
> not the intended recipient, please notify
> [email protected] then delete it and do not disclose
> the contents to any other
> person, use it for any purpose or store or copy the information in any
> medium.
>
> Copyright in this email and attachments created by us belong to Amlin plc
> and/or one or more of its subsidiaries (Amlin Group). The author also
> asserts the right to be identified as such and object to any misuse.
>
>
>
> The Amlin Group prohibits and takes steps to prevent its email systems from
> being used to view, store or transmit offensive, obscene or discriminatory
> material. If this message contains inappropriate material please report it
> immediately to [email protected].
>
> The Amlin Group records, monitors and may inspect messages that use its
> telecoms systems in order to protect its information, interests and
> reputation. Any message sent by you to or within the Amlin Group may
> therefore be viewed and may be acted upon.
>
> Of the companies within the Amlin Group, Amlin Underwriting Limited, Amlin
> Underwriting Services Limited, Amlin UK Limited and Amlin Plus Limited are
> authorised and regulated by the Financial Services Authority.
>
>
>
> This email has been sent by a member of staff of one or more of the
> following Amlin Group companies:
>
> Amlin plc. Registered in England and Wales no. 2854310
> Amlin Underwriting Limited. Registered in England and Wales no. 2323018
> Amlin Underwriting Services Limited. Registered in England and Wales no.
> 422615
> Amlin UK Limited. Registered in England and Wales no. 2739220
> Amlin Plus Limited. Registered in England and Wales no. 4729659
>
> Registered Offices: St Helen's, 1 Undershaft, London EC3A 8ND, United
> Kingdom
>
> Amlin plc switchboard: 020 7746 1000
> Web Site: http://www.amlin.com
>
>
>
> ------------------------------------------------------------------------------
> 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.
>
>
>
> IMPORTANT - This email and the information that it contains may be
> confidential, legally privileged and protected by law. Access by the
> intended recipient only is authorised. Any liability (in negligence or
> otherwise) arising from any third party acting, or refraining from acting,
> on any information contained in this email is hereby excluded. If you are
> not the intended recipient, please notify
> [email protected] then delete it and do not disclose
> the contents to any other
> person, use it for any purpose or store or copy the information in any
> medium.
>
> Copyright in this email and attachments created by us belong to Amlin plc
> and/or one or more of its subsidiaries (Amlin Group). The author also
> asserts the right to be identified as such and object to any misuse.
>
>
>
> The Amlin Group prohibits and takes steps to prevent its email systems from
> being used to view, store or transmit offensive, obscene or discriminatory
> material. If this message contains inappropriate material please report it
> immediately to [email protected].
>
> The Amlin Group records, monitors and may inspect messages that use its
> telecoms systems in order to protect its information, interests and
> reputation. Any message sent by you to or within the Amlin Group may
> therefore be viewed and may be acted upon.
>
> Of the companies within the Amlin Group, Amlin Underwriting Limited, Amlin
> Underwriting Services Limited, Amlin UK Limited and Amlin Plus Limited are
> authorised and regulated by the Financial Services Authority.
>
>
>
> This email has been sent by a member of staff of one or more of the
> following Amlin Group companies:
>
> Amlin plc. Registered in England and Wales no. 2854310
> Amlin Underwriting Limited. Registered in England and Wales no. 2323018
> Amlin Underwriting Services Limited. Registered in England and Wales no.
> 422615
> Amlin UK Limited. Registered in England and Wales no. 2739220
> Amlin Plus Limited. Registered in England and Wales no. 4729659
>
> Registered Offices: St Helen's, 1 Undershaft, London EC3A 8ND, United
> Kingdom
>
> Amlin plc switchboard: 020 7746 1000
> Web Site: http://www.amlin.com
>
>
>
>
> --
> Justin Deoliveira
>
> OpenGeo - http://opengeo.org
>
> Enterprise support for open source geospatial.
>
>
> IMPORTANT - This email and the information that it contains may be
> confidential, legally privileged and protected by law. Access by the
> intended recipient only is authorised. Any liability (in negligence or
> otherwise) arising from any third party acting, or refraining from acting,
> on any information contained in this email is hereby excluded. If you are
> not the intended recipient, please notify
> [email protected] then delete it and do not disclose
> the contents to any other
> person, use it for any purpose or store or copy the information in any
> medium.
>
> Copyright in this email and attachments created by us belong to Amlin plc
> and/or one or more of its subsidiaries (Amlin Group). The author also
> asserts the right to be identified as such and object to any misuse.
> The Amlin Group prohibits and takes steps to prevent its email systems
> from being used to view, store or transmit offensive, obscene or
> discriminatory material. If this message contains inappropriate material
> please report it immediately to [email protected].
>
> The Amlin Group records, monitors and may inspect messages that use its
> telecoms systems in order to protect its information, interests and
> reputation. Any message sent by you to or within the Amlin Group may
> therefore be viewed and may be acted upon.
>
> Of the companies within the Amlin Group, Amlin Underwriting Limited, Amlin
> Underwriting Services Limited, Amlin UK Limited and Amlin Plus Limited are
> authorised and regulated by the Financial Services Authority.
> This email has been sent by a member of staff of one or more of the
> following Amlin Group companies:
>
> Amlin plc. Registered in England and Wales no. 2854310
> Amlin Underwriting Limited. Registered in England and Wales no. 2323018
> Amlin Underwriting Services Limited. Registered in England and Wales no.
> 422615
> Amlin UK Limited. Registered in England and Wales no. 2739220
> Amlin Plus Limited. Registered in England and Wales no. 4729659
>
> Registered Offices: St Helen's, 1 Undershaft, London EC3A 8ND, United
> Kingdom
>
> Amlin plc switchboard: 020 7746 1000
> Web Site: http://www.amlin.com
>
--
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
