[Geoserver-users] Connection to SQL Server 2008 Spatial

GeoServer GeoServer User
1

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(JDBCDataStoreFactory.java:115)
at org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFactory.java:45)
at org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.java:75)
at org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils.java:59)
at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:135)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: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

--
Sensationsangebot nur bis 30.11: GMX FreeDSL - Telefonanschluss + DSL
für nur 16,37 Euro/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a

2

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(JDBCDataStoreFactory.java:115)
at org.geotools.jdbc.JDBCDataStoreFactory.createDataStore(JDBCDataStoreFactory.java:45)
at org.vfny.geoserver.util.DataStoreUtils.getDataStore(DataStoreUtils.java:75)
at org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils.java:59)
at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:135)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: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.