On Thu, Apr 25, 2013 at 2:52 PM, gabriel <[email protected]> wrote:

> Hi,
>
> im working with monitoring  hibernate extension. Database for output
> informations is set to H2 database. When I try to read the H2 files with
> RazorSQL, it says:
>
> Unsupported database file version or invalid file header in file "Old
> database:
> C:/Program Files (x86)/GeoServer
> 2.3.1/data_dir/monitoring/monitoring.data.db
> - please convert the database to a SQL script
> and re-create it." [90048-166]
>
> The same problem was , when i tried to open the monitoring.data.db file
> with
> OpenOffice or attach it to H2 database.
>
> Did someone have experience with this problem ?
>

Never tried to read the H2 databases with anything other than SquirrelSQL
using the same driver jar GeoServer uses, which of course works, but
we are indeed using a rather old version of H2.

Upgrading it to a more recent version is not exactly an easy task, as we
need to upgrade at the same time GeoTools, GeoWebCache and GeoServer,
plus, hard to get the right version, the db format changed a few times, if
we pick a too recent one those tools might not be able to open it for
the opposite issue (too new of a format)

Cheers
Andrea

-- 
==
GeoServer training in Milan, 6th & 7th June 2013!  Visit
http://geoserver.geo-solutions.it for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to