[Geoserver-users] Is it possible to connect to a non spatial db with a standard jdbc-driver?

GeoServer GeoServer User
1

Hello!
I have a Filemaker database with x and y data.
Is it possible to configure a datasource in geoserver with filemaker´s standard jdbc-driver?
/Anders

2

Hi Anders,

Rob Atkinson has done some work on a geotools datastore which can do
"geometryless" tables, that is like your case tables with just x y data.
However it has not made it into "supported" space yet.

My understanding is that you can use any database which has a jdbc
driver, but I could be wrong.

Rob should be able to provide more information.

-Justin

Anders Larsson wrote:

Hello!
I have a Filemaker database with x and y data.
Is it possible to configure a datasource in geoserver with filemaker´s
standard jdbc-driver?
/Anders

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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:4007,46eacdf7229813668746562!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

3

I’m looking for a way to make a web request to return the nearest feature to a given point along with the distance and direction to the nearest feature? Is there any standard way describing how to do this? Does geoserver support this? Any other ideas?

Thanks, David Robison

4

David Robison ha scritto:

I'm looking for a way to make a web request to return the nearest feature to a given point along with the distance and direction to the nearest feature? Is there any standard way describing how to do this? Does geoserver support this? Any other ideas?

Nope, it's not one of the standard queries that OGC has foreseen
in the filter spec, and btw it's not something you can do with postgis
either as far as I know. It's not even something where spatial
indexes can help you directly.

You would have to code it manually, do a distance query ("find me everything in this tentative search area"), and then sort the results
by distance, find the bearing and so on.

Cheers
Andrea

5

There are examples of using the DWITHIN spatial operator to get features with
a certain distance here:
http://lyceum.massgis.state.ma.us/wiki/doku.php?id=wfs:dwithin
Distance currently has to be expressed in the same units as the datalayer
you're querying (for example, MassGIS data is all in NAD 83 meters, so my
distance is meters).
You could try to find any features within X distance, and if you don't find
any, increase the distance and try again.

DavidRobison wrote:

I'm looking for a way to make a web request to return the nearest feature
to a given point along with the distance and direction to the nearest
feature? Is there any standard way describing how to do this? Does
geoserver support this? Any other ideas?

Thanks, David Robison
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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

--
View this message in context: http://www.nabble.com/Is-it-possible-to-connect-to-a-non-spatial-db-with-a-standard-jdbc-driver--tf4444359.html#a12682766
Sent from the GeoServer - User mailing list archive at Nabble.com.

6

i believe DB2 has spatial functions for this

On 9/14/07, aleda_freeman <Aleda.Freeman@anonymised.com> wrote:

There are examples of using the DWITHIN spatial operator to get features with
a certain distance here:
http://lyceum.massgis.state.ma.us/wiki/doku.php?id=wfs:dwithin
Distance currently has to be expressed in the same units as the datalayer
you’re querying (for example, MassGIS data is all in NAD 83 meters, so my
distance is meters).
You could try to find any features within X distance, and if you don’t find
any, increase the distance and try again.

DavidRobison wrote:

I’m looking for a way to make a web request to return the nearest feature
to a given point along with the distance and direction to the nearest
feature? Is there any standard way describing how to do this? Does
geoserver support this? Any other ideas?

Thanks, David Robison

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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

–
View this message in context: http://www.nabble.com/Is-it-possible-to-connect-to-a-non-spatial-db-with-a-standard-jdbc-driver–tf4444359.html#a12682766
Sent from the GeoServer - User mailing list archive at Nabble.com .

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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

–

Facundo Garat Mayer
facundo@anonymised.com

7

i believe DB2 has spatial functions for this

On 9/14/07, aleda_freeman <Aleda.Freeman@anonymised.com> wrote:

There are examples of using the DWITHIN spatial operator to get features with
a certain distance here:
http://lyceum.massgis.state.ma.us/wiki/doku.php?id=wfs:dwithin
Distance currently has to be expressed in the same units as the datalayer
you’re querying (for example, MassGIS data is all in NAD 83 meters, so my
distance is meters).
You could try to find any features within X distance, and if you don’t find
any, increase the distance and try again.

DavidRobison wrote:

I’m looking for a way to make a web request to return the nearest feature
to a given point along with the distance and direction to the nearest
feature? Is there any standard way describing how to do this? Does
geoserver support this? Any other ideas?

Thanks, David Robison

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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

–
View this message in context: http://www.nabble.com/Is-it-possible-to-connect-to-a-non-spatial-db-with-a-standard-jdbc-driver–tf4444359.html#a12682766
Sent from the GeoServer - User mailing list archive at Nabble.com .

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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

–

Facundo Garat Mayer
facundo@anonymised.com

8

Hi Anders

the geometryless module does exactly this...

mainly I have been using it for "real world" data where I map existing database schemas to target GML schemas (i.e. introspection of a database table to create some random XML schema isnt much use for a real WFS service in general) - so have really been maintaining it only against the "community schema support" activity - it has a dependency on a community schema module as well, which we need to get rid of. It runs on Geotools 2.4 and 2.5 (trunk).

That said, its not a million miles away from being supportable, and it could probably be back ported to Geotools 2.3 if necessary, and hence made available to Geoserver 1.5. I dont have plans to do this.

I havent tested it directly against filemaker, but in theory you just have to supply a JDBC driver class name and drop the right jar file in.

If you need something that works without effort you may have to wait a bit, but I'd like to get this bundled into Geoserver 1.6.

Rob Atkinson

Justin Deoliveira wrote:

Hi Anders,
  Rob Atkinson has done some work on a geotools datastore which can do
"geometryless" tables, that is like your case tables with just x y data.
However it has not made it into "supported" space yet.

My understanding is that you can use any database which has a jdbc
driver, but I could be wrong.

Rob should be able to provide more information.

-Justin

Anders Larsson wrote:
  

Hello!
I have a Filemaker database with x and y data.
Is it possible to configure a datasource in geoserver with filemaker´s standard jdbc-driver?
/Anders

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
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:4007,46eacdf7229813668746562!

9

Rob Atkinson ha scritto:

Hi Anders

the geometryless module does exactly this...

mainly I have been using it for "real world" data where I map existing database schemas to target GML schemas (i.e. introspection of a database table to create some random XML schema isnt much use for a real WFS service in general) - so have really been maintaining it only against the "community schema support" activity - it has a dependency on a community schema module as well, which we need to get rid of. It runs on Geotools 2.4 and 2.5 (trunk).

That said, its not a million miles away from being supportable, and it could probably be back ported to Geotools 2.3 if necessary, and hence made available to Geoserver 1.5. I dont have plans to do this.

I havent tested it directly against filemaker, but in theory you just have to supply a JDBC driver class name and drop the right jar file in.

If you need something that works without effort you may have to wait a bit, but I'd like to get this bundled into Geoserver 1.6.

Hem, Rob, this is new to me. Care to write a simple page explaining
how to use the datastore? Say I have a plain dbf file, or an excel
file or sorts, and I want to publish it with GeoServer. What
are the steps to do so?

Once we have that, and at least one other developer has confirmed
it works, I have nothing against adding the datastore as an extension
one. Bundling it may be a little premature, but we can discuss that
during GeoServer meetings or here in the mailing list.

Cheers
Andrea

10

Over the past week I have been struggling with the best way to use a single web request to return the nearest feature to a given point. I considered implementing the OpenSL standard, but that was way more work than I was interested in. What I ended up with was writing a WFS request “plugin”. The plugin is a single JAR file that, when copied into geoserver’s lib directory, creates a new WFS requests named GetNearest. This request takes 1) a point, 2) the maximum search range, and 3) the units for the search range. A sample request looks like:

[http://localhost:8080/geoserver/wfs?request=getNearest&service=wfs&version=1.0.0&typename=tiger:pl&PropertyName=tiger:name,lsad_trans&POINT=-77.51761,37.02235&MAXRANGE=50&UNITS=mi](http://localhost:8080/geoserver/wfs?request=getNearest&service=wfs&version=1.0.0&typename=tiger:pl&PropertyName=tiger:name,lsad_trans&POINT=-77.51761,37.02235&MAXRANGE=50&UNITS=mi)

In this case I am searching a TIGER places layer for the nearest named place. The resulting output is:

<wfs:FeatureCollection xsi:schemaLocation=“http://www.census.gov http://localhost:8080/geoserver/wfs/DescribeFeatureType?typeName=tiger:pl http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd”>

gml:boundedBy
<gml:Box srsName=“http://www.opengis.net/gml/srs/epsg.xml#4326”>
<gml:coordinates decimal=“.” cs=“,” ts=" ">
-77.406378,36.940298 -77.391313,36.956486
</gml:coordinates>
</gml:Box>
</gml:boundedBy>
gml:featureMember
<tiger:pl fid=“pl.302”>
tiger:nameStony Creek</tiger:name>
tiger:lsad_transtown</tiger:lsad_trans>
tiger:nearest_distance7.760402085851028</tiger:nearest_distance>
tiger:nearest_bearing228.81705674288395</tiger:nearest_bearing>
</tiger:pl>
</gml:featureMember>
</wfs:FeatureCollection>

Notice that the last two attributes are added by the request and are the nearest distance between the point and the feature and the bearing from the point to the feature.

What I was very impressed with is how easy it was to extend the WFS service. I thought others in the community might be interested, so… if anyone is interested in the GetNearest request or how I wrote the plugin, I could post or provide you with the code.

··· 
-- 

David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: [drrobison@anonymised.com](mailto:drrobison@anonymised.com)
web: [http://openroadsconsulting.com](http://openroadsconsulting.com)
blog: [http://therobe.blogspot.com](http://therobe.blogspot.com)
book: [http://www.xulonpress.com/book_detail.php?id=2579](http://www.xulonpress.com/book_detail.php?id=2579)
11

This looks like really great work. Would you consider releasing it as a 'community' module, hosted on GeoServer's SVN? We have too few examples of how to extend the current services, and I think that this is a great one, and shows off something really useful that others would be able to take advantage of.

best regards,

Chris

David R Robison wrote:

Over the past week I have been struggling with the best way to use a single web request to return the nearest feature to a given point. I considered implementing the OpenSL standard, but that was way more work than I was interested in. What I ended up with was writing a WFS request "plugin". The plugin is a single JAR file that, when copied into geoserver's lib directory, creates a new WFS requests named GetNearest. This request takes 1) a point, 2) the maximum search range, and 3) the units for the search range. A sample request looks like:

http://localhost:8080/geoserver/wfs?request=getNearest&service=wfs&version=1.0.0&typename=tiger:pl&PropertyName=tiger:name,lsad_trans&POINT=-77.51761,37.02235&MAXRANGE=50&UNITS=mi

In this case I am searching a TIGER places layer for the nearest named place. The resulting output is:

<wfs:FeatureCollection xsi:schemaLocation="http://www.census.gov http://localhost:8080/geoserver/wfs/DescribeFeatureType?typeName=tiger:pl http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd&quot;&gt;

  <gml:boundedBy>
    <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326&quot;&gt;
      <gml:coordinates decimal="." cs="," ts=" ">
        -77.406378,36.940298 -77.391313,36.956486
      </gml:coordinates>
    </gml:Box>
  </gml:boundedBy>
  <gml:featureMember>
    <tiger:pl fid="pl.302">
      <tiger:name>Stony Creek</tiger:name>
      <tiger:lsad_trans>town</tiger:lsad_trans>
      <tiger:nearest_distance>7.760402085851028</tiger:nearest_distance>
      <tiger:nearest_bearing>228.81705674288395</tiger:nearest_bearing>
    </tiger:pl>
  </gml:featureMember>
</wfs:FeatureCollection>

Notice that the last two attributes are added by the request and are the nearest distance between the point and the feature and the bearing from the point to the feature.

What I was very impressed with is how easy it was to extend the WFS service. I thought others in the community might be interested, so... if anyone is interested in the GetNearest request or how I wrote the plugin, I could post or provide you with the code.

--

David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: drrobison@anonymised.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/book_detail.php?id=2579

!DSPAM:4005,46eedfcd282293668746562!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4005,46eedfcd282293668746562!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46eedfcd282293668746562!

12

I would be happy to, let me know how I can go about doing it. One caveat, I have only done limited testing for my specific application, but it others might find it useful, I'd be happy to contribute. David

Chris Holmes wrote:

This looks like really great work. Would you consider releasing it as a 'community' module, hosted on GeoServer's SVN? We have too few examples of how to extend the current services, and I think that this is a great one, and shows off something really useful that others would be able to take advantage of.

best regards,

Chris

David R Robison wrote:

Over the past week I have been struggling with the best way to use a single web request to return the nearest feature to a given point. I considered implementing the OpenSL standard, but that was way more work than I was interested in. What I ended up with was writing a WFS request "plugin". The plugin is a single JAR file that, when copied into geoserver's lib directory, creates a new WFS requests named GetNearest. This request takes 1) a point, 2) the maximum search range, and 3) the units for the search range. A sample request looks like:

http://localhost:8080/geoserver/wfs?request=getNearest&service=wfs&version=1.0.0&typename=tiger:pl&PropertyName=tiger:name,lsad_trans&POINT=-77.51761,37.02235&MAXRANGE=50&UNITS=mi

In this case I am searching a TIGER places layer for the nearest named place. The resulting output is:

<wfs:FeatureCollection xsi:schemaLocation="http://www.census.gov http://localhost:8080/geoserver/wfs/DescribeFeatureType?typeName=tiger:pl http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd&quot;&gt;

  <gml:boundedBy>
    <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326&quot;&gt;
      <gml:coordinates decimal="." cs="," ts=" ">
        -77.406378,36.940298 -77.391313,36.956486
      </gml:coordinates>
    </gml:Box>
  </gml:boundedBy>
  <gml:featureMember>
    <tiger:pl fid="pl.302">
      <tiger:name>Stony Creek</tiger:name>
      <tiger:lsad_trans>town</tiger:lsad_trans>
      <tiger:nearest_distance>7.760402085851028</tiger:nearest_distance>
      <tiger:nearest_bearing>228.81705674288395</tiger:nearest_bearing>
    </tiger:pl>
  </gml:featureMember>
</wfs:FeatureCollection>

Notice that the last two attributes are added by the request and are the nearest distance between the point and the feature and the bearing from the point to the feature.

What I was very impressed with is how easy it was to extend the WFS service. I thought others in the community might be interested, so... if anyone is interested in the GetNearest request or how I wrote the plugin, I could post or provide you with the code.

--

David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: drrobison@anonymised.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/book_detail.php?id=2579

!DSPAM:4005,46eedfcd282293668746562!

------------------------------------------------------------------------

-------------------------------------------------------------------------

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4005,46eedfcd282293668746562!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46eedfcd282293668746562!

--

David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: drrobison@anonymised.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/book_detail.php?id=2579

13

There's a few instructions here - http://docs.codehaus.org/display/GEOSDOC/Community

It's not much, just make a wiki page explaining it, and then I think we have to get you some svn access. Testing is not really needed in the community section, if people were interested in having it be supported as part of the official distribution then we'd raise the bar on a number of things. But if it's working code then it should be fine for the community section now.

Chris

David R Robison wrote:

I would be happy to, let me know how I can go about doing it. One caveat, I have only done limited testing for my specific application, but it others might find it useful, I'd be happy to contribute. David

Chris Holmes wrote:

This looks like really great work. Would you consider releasing it as a 'community' module, hosted on GeoServer's SVN? We have too few examples of how to extend the current services, and I think that this is a great one, and shows off something really useful that others would be able to take advantage of.

best regards,

Chris

David R Robison wrote:

Over the past week I have been struggling with the best way to use a single web request to return the nearest feature to a given point. I considered implementing the OpenSL standard, but that was way more work than I was interested in. What I ended up with was writing a WFS request "plugin". The plugin is a single JAR file that, when copied into geoserver's lib directory, creates a new WFS requests named GetNearest. This request takes 1) a point, 2) the maximum search range, and 3) the units for the search range. A sample request looks like:

http://localhost:8080/geoserver/wfs?request=getNearest&service=wfs&version=1.0.0&typename=tiger:pl&PropertyName=tiger:name,lsad_trans&POINT=-77.51761,37.02235&MAXRANGE=50&UNITS=mi

In this case I am searching a TIGER places layer for the nearest named place. The resulting output is:

<wfs:FeatureCollection xsi:schemaLocation="http://www.census.gov http://localhost:8080/geoserver/wfs/DescribeFeatureType?typeName=tiger:pl http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-basic.xsd&quot;&gt;

  <gml:boundedBy>
    <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#4326&quot;&gt;
      <gml:coordinates decimal="." cs="," ts=" ">
        -77.406378,36.940298 -77.391313,36.956486
      </gml:coordinates>
    </gml:Box>
  </gml:boundedBy>
  <gml:featureMember>
    <tiger:pl fid="pl.302">
      <tiger:name>Stony Creek</tiger:name>
      <tiger:lsad_trans>town</tiger:lsad_trans>
      <tiger:nearest_distance>7.760402085851028</tiger:nearest_distance>
      <tiger:nearest_bearing>228.81705674288395</tiger:nearest_bearing>
    </tiger:pl>
  </gml:featureMember>
</wfs:FeatureCollection>

Notice that the last two attributes are added by the request and are the nearest distance between the point and the feature and the bearing from the point to the feature.

What I was very impressed with is how easy it was to extend the WFS service. I thought others in the community might be interested, so... if anyone is interested in the GetNearest request or how I wrote the plugin, I could post or provide you with the code.

--

David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: drrobison@anonymised.com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/book_detail.php?id=2579

------------------------------------------------------------------------

-------------------------------------------------------------------------

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4005,46eedfcd282293668746562!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4005,46eedfcd282293668746562!

14

David R Robison ha scritto:

I would be happy to, let me know how I can go about doing it. One caveat, I have only done limited testing for my specific application, but it others might find it useful, I'd be happy to contribute. David

David, quick question. Have you been working against GeoServer trunk
or GeoServer 1.5.x?

Cheers
Andrea

15

GeoServer 1.5.3. David

From: Andrea Aime [mailto:aaime@anonymised.com]
To: David R Robison [mailto:drrobison@anonymised.com]
Cc: Chris Holmes [mailto:cholmes@anonymised.com1…], geoserver-users@lists.sourceforge.net
Sent: Mon, 17 Sep 2007 18:00:36 -0400
Subject: Re: [Geoserver-users] Custom WFS Request: GetNearest

David R Robison ha scritto:

I would be happy to, let me know how I can go about doing it. One
caveat, I have only done limited testing for my specific application,
but it others might find it useful, I’d be happy to contribute. David

David, quick question. Have you been working against GeoServer trunk
or GeoServer 1.5.x?

Cheers
Andrea

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

16

Hi Andrea,

page on wiki already,

http://docs.codehaus.org/display/GEOTOOLS/Geometryless+Configuration

it uses your JDBC connection pool work, so you just have to have a JDBC driver for whatever format you choose. Excel may require you to use a JDBC/ODBC bridge for example. I havent tested all possibilities, but you should have a fair idea of what will work with the connection pool interface.

Q - will DataSource stuff work? Perhaps you could edit the page to point to any documentation you have re the connection pooling capabilities.

(BTW only dependency on SQLView stuff between here and supported I hope, using the connection pooling removed dependencies on external JDBC jars to compile wrappers)

Rob

On 9/17/07, Andrea Aime <aaime@anonymised.com> wrote:

Rob Atkinson ha scritto:

Hi Anders

the geometryless module does exactly this…

mainly I have been using it for “real world” data where I map existing
database schemas to target GML schemas ( i.e. introspection of a database
table to create some random XML schema isnt much use for a real WFS
service in general) - so have really been maintaining it only against
the “community schema support” activity - it has a dependency on a
community schema module as well, which we need to get rid of. It runs
on Geotools 2.4 and 2.5 (trunk).

That said, its not a million miles away from being supportable, and it
could probably be back ported to Geotools 2.3 if necessary, and hence
made available to Geoserver 1.5. I dont have plans to do this.

I havent tested it directly against filemaker, but in theory you just
have to supply a JDBC driver class name and drop the right jar file in.

If you need something that works without effort you may have to wait a
bit, but I’d like to get this bundled into Geoserver 1.6.

Hem, Rob, this is new to me. Care to write a simple page explaining
how to use the datastore? Say I have a plain dbf file, or an excel
file or sorts, and I want to publish it with GeoServer. What
are the steps to do so?

Once we have that, and at least one other developer has confirmed
it works, I have nothing against adding the datastore as an extension
one. Bundling it may be a little premature, but we can discuss that
during GeoServer meetings or here in the mailing list.

Cheers
Andrea