Hi,
i want to use GeoServer and show data from our Sybase Database. Sybase has a
free JDBC Driver. How can i configure my GeoServer to do this?
Greetz
Peesjee
--
View this message in context: http://www.nabble.com/GeoServer-and-Sybase-JDBC-driver-tp21348904p21348904.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Peesjee ha scritto:
Hi,
i want to use GeoServer and show data from our Sybase Database. Sybase has a
free JDBC Driver. How can i configure my GeoServer to do this?
You cannot. One needs also a datastore that is able to read
the geometries as encoded in the sybase format... wasn't
even aware there is a spatial support for sybase actually 
If you're interested in contributing a sybase datastore,
in GeoTools we have a framework for building a new jdbc
based datastore in a matter of days, it factors out
the differences between databases in a dialect class
that you have to extend implementing methods for
reading/encoding geometries, encoding spatial filters
and the like.
If you want to look into it, you'll find it in the
GeoTools 2.5.x branch, look for modules/unsupported/jdbc-ng,
you'll find the core classes and implementations for
h2, db2, oracle, sql server (alpha) and mysql.
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Hi Andrea,
thx for the answer. I'm very new in this exciting technology, so writing a
new class for sybase will be probably out of my league. I want to know if i
have other options. Can't i just connect from my Sybase database to a
PostGis Database, insert my data and use the PostGis database for my spatial
needs?
Greetz
Peesjee
Andrea Aime-4 wrote:
Peesjee ha scritto:
Hi,
i want to use GeoServer and show data from our Sybase Database. Sybase
has a
free JDBC Driver. How can i configure my GeoServer to do this?You cannot. One needs also a datastore that is able to read
the geometries as encoded in the sybase format... wasn't
even aware there is a spatial support for sybase actuallyIf you're interested in contributing a sybase datastore,
in GeoTools we have a framework for building a new jdbc
based datastore in a matter of days, it factors out
the differences between databases in a dialect class
that you have to extend implementing methods for
reading/encoding geometries, encoding spatial filters
and the like.If you want to look into it, you'll find it in the
GeoTools 2.5.x branch, look for modules/unsupported/jdbc-ng,
you'll find the core classes and implementations for
h2, db2, oracle, sql server (alpha) and mysql.Cheers
Andrea--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
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/GeoServer-and-Sybase-JDBC-driver-tp21348904p21349324.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Peesjee ha scritto:
Hi Andrea,
thx for the answer. I'm very new in this exciting technology, so writing a
new class for sybase will be probably out of my league. I want to know if i
have other options. Can't i just connect from my Sybase database to a
PostGis Database, insert my data and use the PostGis database for my spatial
needs?
Hum, I guess you could for normal alphanumeric data, but for
spatial data, I'm not aware of any direct db to db conversion
tool. Spatial data is not standardized, so you cannot even just
link tables and pretend postgis to handle them as if they
were its own native ones.
The low tech solution would be to export your spatial data from sybase
in shapefile format, and then import it into postgis.
If this does not work or if you really need live connection to your
data (as opposed to manual data replication), you can explore the
commercial support options and ask someone to develop a sybase connector
for you, see here:
http://geoserver.org/display/GEOS/Commercial+Support
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Hi Andrea,
i'm evaluating GeoServer aswell as MapServer. In Mapserver, i see a topic
"Virtual Spatial Data"
i quote from the mapserver site:
This is an OGR extension to MapServer. It allows you to connect to databases
that do not explicitly hold spatial data, as well as flat text files. Your
data must have an X and a Y column, and the data may be accessed through an
ODBC connection or a direct pointer to a text file.
Does GeoServer has something like this?
Greetz
Peesjee
Andrea Aime-4 wrote:
Peesjee ha scritto:
Hi Andrea,
thx for the answer. I'm very new in this exciting technology, so writing
a
new class for sybase will be probably out of my league. I want to know if
i
have other options. Can't i just connect from my Sybase database to a
PostGis Database, insert my data and use the PostGis database for my
spatial
needs?Hum, I guess you could for normal alphanumeric data, but for
spatial data, I'm not aware of any direct db to db conversion
tool. Spatial data is not standardized, so you cannot even just
link tables and pretend postgis to handle them as if they
were its own native ones.The low tech solution would be to export your spatial data from sybase
in shapefile format, and then import it into postgis.If this does not work or if you really need live connection to your
data (as opposed to manual data replication), you can explore the
commercial support options and ask someone to develop a sybase connector
for you, see here:
http://geoserver.org/display/GEOS/Commercial+SupportCheers
Andrea--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
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/GeoServer-and-Sybase-JDBC-driver-tp21348904p21349611.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Peesjee ha scritto:
Hi Andrea,
i'm evaluating GeoServer aswell as MapServer. In Mapserver, i see a topic
"Virtual Spatial Data"i quote from the mapserver site:
This is an OGR extension to MapServer. It allows you to connect to databases
that do not explicitly hold spatial data, as well as flat text files. Your
data must have an X and a Y column, and the data may be accessed through an
ODBC connection or a direct pointer to a text file.
Ah, I see, so your data is not spatial.
In GeoTools there is a datastore that could be used for
that, it's called "geometryless", but it has never been
tried out with GeoServer that I know of (hum... maybe Rob did... Rob?)
We also have a task in jira about this, but it has been forgotten
about I see:
http://jira.codehaus.org/browse/GEOS-1383
See also here:
http://docs.codehaus.org/display/GEOTOOLS/Geometryless+Configuration
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.