Hello,
And thanks for your tips. I tried this but failed:
"Could not list layers for this store, an error occurred retrieving them:
Failed to create reader from file://E:\DATA\eodata\demo\sst_SQLserver2 and
hints null"
I'll attach a screenshot, in case it makes a difference. I checked the database
and to me it seemed that the proper table had been created with the appropriate
data in it (fid, the_geom, location, time). So to me it seems the problem
cannot be with database privileges etc. I switched another datastore.properties
-file to the image folder (E:\DATA\eodata\demo\sst_SQLserver2 above) defining a
PostGIS-database and clicked Save again: the datastore was created without
problems. So something does go wrong with SQL Server.
I'll discuss this with my more database-wise colleagues and let you know if we
can figure it out.
Regards,
Samuli
-----Alkuperäinen viesti-----
Lähettäjä: [email protected] [mailto:[email protected]] Puolesta Simone
Giannecchini
Lähetetty: 28. marraskuuta 2014 20:39
Vastaanottaja: Neuvonen Samuli
Kopio: [email protected]
Aihe: Re: [Geoserver-users] ImageMosaic indexes & DBMSs
Ciao,
that list is up-to-date.
This does not mean that SQL Server is known to not work with ImageMosaic, it
simply means it has never been tested.
ImageMosaic uses a standard datastore underneath so generally speaking it
should work with SQL Server. I would suggest doing a test with a
datastore.properties similar to the following:
where you need to customize keys and values according to what is described in
this page:
http://docs.geoserver.org/stable/en/user/data/database/sqlserver.html
SPI=org.geotools.data.sqlserver.SQLServerDataStoreFactory
port=1521
host=localhost
database=dbname
Loose\ bbox=true
Estimated\ extends=false
user=usr
passwd=psw
validate \connections=true
Connection\ timeout=10
The point is that you are telling ImageMosacis to connect and take control over
a DBMS through the SQL Server plugin hence in the datastore.properties you
configure the params to connect to it likewise you do in the UI og GeoServer.
Mind the spaces in the keys'
names.
Let us know how it goes, ideally it should work seamlessly whicle oracle was a
pain due the caseness of the names. If not we'll improve ImageMosaic to handle
this case.
Of course you need to install SQL Server support installed.
Regards,
Simone Giannecchini
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==
Ing. Simone Giannecchini
@simogeo
Founder/Director
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i sono da considerarsi strettamente riservate.
Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per
le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio
senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via
e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal
Vostro sistema.
Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad
altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce
comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the
attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act (Legislative
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in
accord with its purpose, any disclosure, reproduction, copying, distribution,
or either dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the intended
recipient, please contact immediately the sender by telephone, fax or e-mail
and delete the information in this message that has been received in error. The
sender does not give any warranty or accept liability as the content, accuracy
or completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
On Thu, Nov 27, 2014 at 9:51 AM, Neuvonen Samuli <[email protected]>
wrote:
> Hello all,
>
> I found this tutorial on mosaic datastores
>
> http://geoserver.geo-solutions.it/multidim/en/imagemosaic/mosaic_datas
> tore.html
>
> and I was wondering if the list of supported DBMSs is still up-to-date
> i.e. the supported databases are
>
> - Postgis
> - Oracle
> - H2
>
> and SQL Server is not supported? My ICT-people are really reluctant to allow
> the use of anything but the institute standard...
>
> Kind regards,
> Samuli Neuvonen
>
> ----------------------------------------------------------------------
> -------- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT
> Server from Actuate! Instantly Supercharge Your Business Reports and
> Dashboards with Interactivity, Sharing, Native Excel Exports, App
> Integration & more Get technology previously reserved for
> billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.
> clktrk _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
