Hi,
I was wondering if there is still a JDBCDataStore available that can
be used with GeoServer 1.6.
The requirement would be to use a table with x and y columns from MS
SQL Server as data store. Can that be done with GeoServer 1.6?
Thanks!
Andreas.
JDBCDataStore is an abstract class that all jdbc datastores extend. What you're probably wanting is the 'geometryless' datastore, see http://svn.geotools.org/geotools/trunk/gt/modules/unsupported/geometryless/
It's in unsupported, but I think Rob Atkinson continues work on it. Might take a bit of tweaking, but you can probably get it to work for you.
Chris
Andreas Hocevar wrote:
Hi,
I was wondering if there is still a JDBCDataStore available that can
be used with GeoServer 1.6.The requirement would be to use a table with x and y columns from MS
SQL Server as data store. Can that be done with GeoServer 1.6?Thanks!
Andreas.-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:4005,47e13ffa132108992556831!
Hi,
we do have thius working on the 1.6 branch - it has a few
dependencies, and is not in the standard build yet, because I havent
had time to work through getting it into supported status. My goal was
to have it supported on the trunk for the next major build.
to use it, you should just compile it and its dependency:
unsupported/community-schemas/sql-datastore which extends jdbc
datastores to allow us to insert a SQL join statement, instead of
blindly assuming a table contains the data of interest, all the data,
nothing but the data.
This is tested with the JTDS JDBC driver (and works for oracle,
ms-sql, postgres also) - you just need to bundle the jars.
If the doco system was working well enough I should be able to
resurrect my account and publish pre-built versions of the
geometryless jars - but I've lost visibility of the process to be
honest. I can publish these somewhere else if you dont want to build
them.
Rob
On Thu, Mar 20, 2008 at 4:32 AM, Chris Holmes <cholmes@anonymised.com> wrote:
JDBCDataStore is an abstract class that all jdbc datastores extend.
What you're probably wanting is the 'geometryless' datastore, see
http://svn.geotools.org/geotools/trunk/gt/modules/unsupported/geometryless/It's in unsupported, but I think Rob Atkinson continues work on it.
Might take a bit of tweaking, but you can probably get it to work for you.Chris
Andreas Hocevar wrote:
> Hi,
>
> I was wondering if there is still a JDBCDataStore available that can
> be used with GeoServer 1.6.
>
> The requirement would be to use a table with x and y columns from MS
> SQL Server as data store. Can that be done with GeoServer 1.6?
>
> Thanks!
> Andreas.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
> !DSPAM:4005,47e13ffa132108992556831!
>
Rob, Chris,
thanks for your efforts. I'll try to compile it myself. If I fail to
do so, I'll contact you again.
Thank you!
Andreas.
On Thu, Mar 20, 2008 at 12:18 AM, Rob Atkinson <robatkinson101@anonymised.com> wrote:
Hi,
we do have thius working on the 1.6 branch - it has a few
dependencies, and is not in the standard build yet, because I havent
had time to work through getting it into supported status. My goal was
to have it supported on the trunk for the next major build.to use it, you should just compile it and its dependency:
unsupported/community-schemas/sql-datastore which extends jdbc
datastores to allow us to insert a SQL join statement, instead of
blindly assuming a table contains the data of interest, all the data,
nothing but the data.This is tested with the JTDS JDBC driver (and works for oracle,
ms-sql, postgres also) - you just need to bundle the jars.If the doco system was working well enough I should be able to
resurrect my account and publish pre-built versions of the
geometryless jars - but I've lost visibility of the process to be
honest. I can publish these somewhere else if you dont want to build
them.Rob
On Thu, Mar 20, 2008 at 4:32 AM, Chris Holmes <cholmes@anonymised.com> wrote:
> JDBCDataStore is an abstract class that all jdbc datastores extend.
> What you're probably wanting is the 'geometryless' datastore, see
> http://svn.geotools.org/geotools/trunk/gt/modules/unsupported/geometryless/
>
> It's in unsupported, but I think Rob Atkinson continues work on it.
> Might take a bit of tweaking, but you can probably get it to work for you.
>
> Chris
>
> Andreas Hocevar wrote:
> > Hi,
> >
> > I was wondering if there is still a JDBCDataStore available that can
> > be used with GeoServer 1.6.
> >
> > The requirement would be to use a table with x and y columns from MS
> > SQL Server as data store. Can that be done with GeoServer 1.6?
> >
> > Thanks!
> > Andreas.
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > Geoserver-users mailing list
> > Geoserver-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
> > !DSPAM:4005,47e13ffa132108992556831!
> >
>