Hi,
I've developed a custom application which uses the Travelling Salesman
libraries
to do some custom routing. I've got it working fine when I use .osm files, but
am running into a problem when using the H2 database.
I imported a .osm file into an H2 database using the actual Travelling Salesman
GUI application, then connect to it from my app, from what I gather, the
following is correct:
H2DataSet map = new H2DataSet (new File("/home/nick/qs/db/LOD0"));
where the H2 database is inside the "db" directory - which is a copy of
~/.openstreetmap/map.
(I also tried without the LOD0, but that couldn't find the database at all)
However, the following line produces an exception:
Iterator<Way> parks = map.getWaysByTag("leisure","park");
specifically:
06-Aug-2010 17:51:42 org.openstreetmap.osm.data.h2.H2DataSet getWaysByTag
SEVERE: Cannot get way by id
org.h2.jdbc.JdbcSQLException: Column "version" not found [42122-126]
at org.h2.message.Message.getSQLException(Message.java:110)
at org.h2.message.Message.getSQLException(Message.java:121)
at org.h2.message.Message.getSQLException(Message.java:74)
at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:2987)
at org.h2.jdbc.JdbcResultSet.get(JdbcResultSet.java:3038)
at org.h2.jdbc.JdbcResultSet.getInt(JdbcResultSet.java:314)
at
org.openstreetmap.osm.data.h2.H2DataSet.getWaysFromQuery(H2DataSet.java:1722)
at org.openstreetmap.osm.data.h2.H2DataSet.getWaysByTag(H2DataSet.java:1774)
at Test.main(Test.java:46)
Am I using the H2 database correctly? I'm not sure what relevance the "version"
column has. Note that Travelling Salesman itself reloads the DB correctly but
has more complex code to connect, as it has to be more flexible, and I'd like
to
keep things as simple as possible.
Thanks,
Nick
_______________________________________________
Routing mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/routing
