[Geoserver-devel] MSSQL Spatial data source

I tried to send you all my mssql data source as you can see below - but the mailing list refused the zip file.

If anybody wants it then send me an email and I'll send you a copy.

Richard Shaw

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤

Richard Shaw
Technical Design Authority - Information Solutions Consultancy
Intelligent Transport Systems

Atkins Highways and Transportation
Woodcote Grove, Ashley Road, Epsom, Surrey, KT18 5BW

Tel: +44 (0) 1372 756407
Fax: +44 (0) 1372 740055
Mob: 07740 817586
E-mail: richard.shaw@anonymised.com

www.atkinsglobal.com/its

-----Original Message-----
From: Shaw, Richard A
Sent: 13 November 2006 10:44
To: geoserver-devel@lists.sourceforge.net
Subject: RE: [Geoserver-devel] MSSQL Spatial data source

My company doesn't want to commit to maintaining the data source beyond creating a version to work with the current version of Geoserver, and I personally don't have the time.

So here is what I have done for what it is worth to you all.

Don't forget it is dependent upon mssqlspatial from codeplex.

It is also dependent upon sqljdbc.jar from Microsoft, I have added a maven repository dependency to the pom.xml file however it doesn't exisit in any of the repositories so I have included the jar file in a lib director and a batch file for doing a manual install of it into your local repository.

Richard Shaw

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤

Richard Shaw
Technical Design Authority - Information Solutions Consultancy Intelligent Transport Systems

Atkins Highways and Transportation
Woodcote Grove, Ashley Road, Epsom, Surrey, KT18 5BW

Tel: +44 (0) 1372 756407
Fax: +44 (0) 1372 740055
Mob: 07740 817586
E-mail: richard.shaw@anonymised.com

www.atkinsglobal.com/its

-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: 10 November 2006 17:25
To: Shaw, Richard A
Cc: geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] MSSQL Spatial data source

Shaw, Richard A ha scritto:

I've created an SQLServer Spatial data source for the codeplex
mssqlspatial extensions.

I created this by modifying the DB2 version.

I have updated the unit tests as well as the code and it seems to work
fine.

Could somebody tell me what the procedure is to donate this ?

First of all, thank you for you contribution :slight_smile:

As for sharing the code, you should address the geotools project, since it's there that datastores are kept. I guess you've developed it against the db2 code found in geotools 2.2.1 or something similar.

Now, usually a developer steps in and provides a module and also becomes its mantainer. Being a mantainer means fixing bugs that users do find, and making the module elvolve along with geotools.

It also means porting the module to the current geotools trunk, which has a different API for feature management.
So, all in all, it's quite a bit of work and requires commitment.

If you're not wishing to bear that work, I guess we'll have to find a way to put your code somewhere waiting for someone interested to pick it and mantaining it, but we shall accept it in any case.

Let me know what you intend to do.
Cheers
Andrea

PS: btw, another user was interested in a spatial datastore for mssql datastore on the users mailing list, thought I don't know if he's using the MsSqlSpatial extension or not...

This message has been scanned for viruses by MailControl - (see http://bluepages.wsatkins.co.uk/?4318150)

This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.

Hi Richard,
Would it be possible to get a copy of your mssql data source please?
Bets regards
Oliver

Shaw, Richard A wrote:

I tried to send you all my mssql data source as you can see below - but
the mailing list refused the zip file.

If anybody wants it then send me an email and I'll send you a copy.

Richard Shaw

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤

Richard Shaw
Technical Design Authority - Information Solutions Consultancy
Intelligent Transport Systems

Atkins Highways and Transportation
Woodcote Grove, Ashley Road, Epsom, Surrey, KT18 5BW

Tel: +44 (0) 1372 756407
Fax: +44 (0) 1372 740055
Mob: 07740 817586
E-mail: richard.shaw@anonymised.com

www.atkinsglobal.com/its

-----Original Message-----
From: Shaw, Richard A
Sent: 13 November 2006 10:44
To: geoserver-devel@lists.sourceforge.net
Subject: RE: [Geoserver-devel] MSSQL Spatial data source

My company doesn't want to commit to maintaining the data source beyond
creating a version to work with the current version of Geoserver, and I
personally don't have the time.

So here is what I have done for what it is worth to you all.

Don't forget it is dependent upon mssqlspatial from codeplex.

It is also dependent upon sqljdbc.jar from Microsoft, I have added a maven
repository dependency to the pom.xml file however it doesn't exisit in any
of the repositories so I have included the jar file in a lib director and
a batch file for doing a manual install of it into your local repository.

Richard Shaw

¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤

Richard Shaw
Technical Design Authority - Information Solutions Consultancy Intelligent
Transport Systems

Atkins Highways and Transportation
Woodcote Grove, Ashley Road, Epsom, Surrey, KT18 5BW

Tel: +44 (0) 1372 756407
Fax: +44 (0) 1372 740055
Mob: 07740 817586
E-mail: richard.shaw@anonymised.com

www.atkinsglobal.com/its

-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: 10 November 2006 17:25
To: Shaw, Richard A
Cc: geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] MSSQL Spatial data source

Shaw, Richard A ha scritto:

I've created an SQLServer Spatial data source for the codeplex
mssqlspatial extensions.

I created this by modifying the DB2 version.

I have updated the unit tests as well as the code and it seems to work
fine.

Could somebody tell me what the procedure is to donate this ?

First of all, thank you for you contribution :slight_smile:

As for sharing the code, you should address the geotools project, since
it's there that datastores are kept. I guess you've developed it against
the db2 code found in geotools 2.2.1 or something similar.

Now, usually a developer steps in and provides a module and also becomes
its mantainer. Being a mantainer means fixing bugs that users do find, and
making the module elvolve along with geotools.

It also means porting the module to the current geotools trunk, which has
a different API for feature management.
So, all in all, it's quite a bit of work and requires commitment.

If you're not wishing to bear that work, I guess we'll have to find a way
to put your code somewhere waiting for someone interested to pick it and
mantaining it, but we shall accept it in any case.

Let me know what you intend to do.
Cheers
Andrea

PS: btw, another user was interested in a spatial datastore for mssql
datastore on the users mailing list, thought I don't know if he's using
the MsSqlSpatial extension or not...

This message has been scanned for viruses by MailControl - (see
http://bluepages.wsatkins.co.uk/?4318150)

This email and any attached files are confidential and copyright
protected. If you are not the addressee, any dissemination of this
communication is strictly prohibited. Unless otherwise expressly agreed in
writing, nothing stated in this communication shall be legally binding.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
View this message in context: http://www.nabble.com/MSSQL-Spatial-data-source-tf2606721.html#a13910927
Sent from the GeoServer - Dev mailing list archive at Nabble.com.