diff --git a/src/ImportGML_FUEL_update.sh b/src/ImportGML_FUEL_update.sh index d730440..4cfbc95 100644 --- a/src/ImportGML_FUEL_update.sh +++ b/src/ImportGML_FUEL_update.sh @@ -4,3 +4,10 @@ java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.DbExist java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.Fuel java -cp .:osmCoverage.jar:hayashi_0225.jar:hsqldb_2.2.9.jar:postgresql-9.4.1212.jar osm.jp.coverage.fuel.ToPostgis + +# java -cp hsqldb_2.2.9.jar org.hsqldb.util.DatabaseManager +# db_driver=org.hsqldb.jdbcDriver +# db_url=jdbc:hsqldb:file:./database/db +# db_user=sa +# db_passwd= +# \ No newline at end of file diff --git a/src/osm/jp/coverage/fuel/DbFuel.java b/src/osm/jp/coverage/fuel/DbFuel.java index c6cd703..23984ac 100644 --- a/src/osm/jp/coverage/fuel/DbFuel.java +++ b/src/osm/jp/coverage/fuel/DbFuel.java @@ -228,7 +228,7 @@ } } - try (PreparedStatement ps = con.prepareStatement("INSERT INTO "+ TABLE_NAME +"(gid,lat,lon,fixed,idref,area,up) VALUES(0,?,?,?,?,?,2)")) { + try (PreparedStatement ps = con.prepareStatement("INSERT INTO "+ TABLE_NAME +"(gid,lat,lon,fixed,idref,area,up,fixed1) VALUES(0,?,?,?,?,?,2,0)")) { double lat = Double.parseDouble(latStr); double lon = Double.parseDouble(lonStr); ps.setDouble(1, lat); @@ -236,7 +236,7 @@ ps.setInt(3, 0); ps.setString(4, idStr); ps.setInt(5, areacode); - System.out.println("INSERT INTO "+ TABLE_NAME +"("+ idStr +", lat="+ lat +", lon="+ lon +", fixed=0, area="+ areacode +", up=2)"); + System.out.println("INSERT INTO "+ TABLE_NAME +"("+ idStr +", lat="+ lat +", lon="+ lon +", fixed=0, area="+ areacode +", up=2, fixed1=0)"); ps.executeUpdate(); } }