[Geoserver-users] Connection to SQL Server 2008 Spatial

GeoServer GeoServer User
1

Hi,

I'am running GeoServer Version 1.7.0 Stable in a war install in tomcat 6.0.16.
As well I'am using the latest ms-jdbc driver an the geoserver-1.7.1-SNAPSHOT as plugin.

@Justin: Thank you for putting me on the list!

Best regards
Sven

-----Ursprüngliche Nachricht-----
Von: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Gesendet: Freitag, 28. November 2008 01:18
An: Sven Axt
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Connection to SQL Server 2008 Spatial

Hi Sven,

A couple of questions. Which version of GeoServer are you running? Also how are you running GeoSever? Via war install? or standalone?

Thanks,

-Justin

Sven Axt wrote:

Hello,

I'am really looking foreward to working with the sql server spatial driver. Connection via oledb (using win xp) works fine:
Provider=SQLOLEDB.1;Password=pass;Persist Security Info=True;User
ID=user;Initial Catalog=mydb;Data Source=127.0.0.1\SQLEXPRESS,1433

Installation was no problem. I'am able to choose Microsoft SQL-Server when creating a datastore. I tried various ways, but connecting to the sql server instance is not successful:

form connection params { schema="dbo", port=1433, passwd="pass",
dbtype="sqlserver", host="127.0.0.1\SQLEXPRESS:1433", max
connections=10, user="user", database="mydb", min connections=1}
25 Nov 09:55:15 WARN [geoserver.action] - Unable to fetch a list of FeatureType names from datastore.
java.lang.VerifyError: org/geotools/jdbc/JDBCDataStore at
org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFa
ctory.java:115) at
org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFa
ctory.java:45) at
org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.jav
a:75) at
org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils
.java:59) at
org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(Data
DataStoresEditorAction.java:135) at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at
org.apache.struts.action.RequestProcessor.processActionPerform(Request
Processor.java:431) at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav
a:236) at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196
) at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

Any ideas whats wrong?

Thank you and best regards
Sven

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

2

Hi Sven,

I looked into this and I can reproduce the problem. I believe the problem is version mismatches... since 1.7.0 some things have changed which are causing the sql server extension to be unusable.

I am currently traveling at the moment but I plan to look into this and post a working version of the extension as soon as i can. By Monday a working version should be posted.

-Justin

Axt, Sven wrote:

Hi,

I'am running GeoServer Version 1.7.0 Stable in a war install in tomcat 6.0.16. As well I'am using the latest ms-jdbc driver an the geoserver-1.7.1-SNAPSHOT as plugin.

@Justin: Thank you for putting me on the list!

Best regards
Sven

-----Ursprüngliche Nachricht-----
Von: Justin Deoliveira [mailto:jdeolive@anonymised.com] Gesendet: Freitag, 28. November 2008 01:18
An: Sven Axt
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Connection to SQL Server 2008 Spatial

Hi Sven,

A couple of questions. Which version of GeoServer are you running? Also how are you running GeoSever? Via war install? or standalone?

Thanks,

-Justin

Sven Axt wrote:

Hello,
I'am really looking foreward to working with the sql server spatial driver. Connection via oledb (using win xp) works fine: Provider=SQLOLEDB.1;Password=pass;Persist Security Info=True;User ID=user;Initial Catalog=mydb;Data Source=127.0.0.1\SQLEXPRESS,1433
Installation was no problem. I'am able to choose Microsoft SQL-Server when creating a datastore. I tried various ways, but connecting to the sql server instance is not successful:
form connection params { schema="dbo", port=1433, passwd="pass", dbtype="sqlserver", host="127.0.0.1\SQLEXPRESS:1433", max connections=10, user="user", database="mydb", min connections=1}
25 Nov 09:55:15 WARN [geoserver.action] - Unable to fetch a list of FeatureType names from datastore.
java.lang.VerifyError: org/geotools/jdbc/JDBCDataStore at org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFa
ctory.java:115) at org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFa
ctory.java:45) at org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.jav
a:75) at org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils
.java:59) at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(Data
DataStoresEditorAction.java:135) at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at org.apache.struts.action.RequestProcessor.processActionPerform(Request
Processor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav
a:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196
) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
Any ideas whats wrong?
Thank you and best regards
Sven

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

3

Hi Sven,

I believed I have fixed the problem. Due to changes between versions you will need to grab a recent 1.7.1 SNAPSHOT geoserver install. I also fixed an issue in the extension so you will need the latest version of that. You can grab them from:

http://gridlock.openplans.org/geoserver/1.7.x/geoserver-1.7.x-latest-war.zip
http://gridlock.openplans.org/geoserver/1.7.x/ext-latest/geoserver-1.7.1-SNAPSHOT-sqlserver-plugin.zip

That hopefully works for you. Try it out and let me know if you have any more problems.

-Justin

Axt, Sven wrote:

Hi,

I'am running GeoServer Version 1.7.0 Stable in a war install in tomcat 6.0.16. As well I'am using the latest ms-jdbc driver an the geoserver-1.7.1-SNAPSHOT as plugin.

@Justin: Thank you for putting me on the list!

Best regards
Sven

-----Ursprüngliche Nachricht-----
Von: Justin Deoliveira [mailto:jdeolive@anonymised.com] Gesendet: Freitag, 28. November 2008 01:18
An: Sven Axt
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] Connection to SQL Server 2008 Spatial

Hi Sven,

A couple of questions. Which version of GeoServer are you running? Also how are you running GeoSever? Via war install? or standalone?

Thanks,

-Justin

Sven Axt wrote:

Hello,
I'am really looking foreward to working with the sql server spatial driver. Connection via oledb (using win xp) works fine: Provider=SQLOLEDB.1;Password=pass;Persist Security Info=True;User ID=user;Initial Catalog=mydb;Data Source=127.0.0.1\SQLEXPRESS,1433
Installation was no problem. I'am able to choose Microsoft SQL-Server when creating a datastore. I tried various ways, but connecting to the sql server instance is not successful:
form connection params { schema="dbo", port=1433, passwd="pass", dbtype="sqlserver", host="127.0.0.1\SQLEXPRESS:1433", max connections=10, user="user", database="mydb", min connections=1}
25 Nov 09:55:15 WARN [geoserver.action] - Unable to fetch a list of FeatureType names from datastore.
java.lang.VerifyError: org/geotools/jdbc/JDBCDataStore at org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFa
ctory.java:115) at org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFa
ctory.java:45) at org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.jav
a:75) at org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils
.java:59) at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(Data
DataStoresEditorAction.java:135) at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at org.apache.struts.action.RequestProcessor.processActionPerform(Request
Processor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav
a:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196
) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
Any ideas whats wrong?
Thank you and best regards
Sven

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.