[OSM-dev] Daily diff's retry

Brett Henderson brett at bretth.com
Sat Oct 13 02:12:35 BST 2007


Thanks for the patch.  It's applied and now in svn.

Jon Bright wrote:
> Hi Brett,
>
> I now got some time to look at this and have fixed it.  The setting of 
> the tile column had been added to the setting of the PreparedStatement 
> variables but not added to the SQL itself (for both the nodes and the 
> current_nodes inserts).  The attached patch fixes this.
>
> ------------------------------------------------------------------------
>
> Index: src/com/bretth/osmosis/core/mysql/v0_5/impl/ChangeWriter.java
> ===================================================================
> --- src/com/bretth/osmosis/core/mysql/v0_5/impl/ChangeWriter.java	(revision 4950)
> +++ src/com/bretth/osmosis/core/mysql/v0_5/impl/ChangeWriter.java	(working copy)
> @@ -28,9 +28,9 @@
>   */
>  public class ChangeWriter {
>  	private static final String INSERT_SQL_NODE =
> -		"INSERT INTO nodes (id, timestamp, latitude, longitude, tags, visible, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)";
> +		"INSERT INTO nodes (id, timestamp, latitude, longitude, tile, tags, visible, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
>  	private static final String INSERT_SQL_NODE_CURRENT =
> -		"INSERT INTO current_nodes (id, timestamp, latitude, longitude, tags, visible, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)";
> +		"INSERT INTO current_nodes (id, timestamp, latitude, longitude, tile, tags, visible, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
>  	private static final String DELETE_SQL_NODE_CURRENT =
>  		"DELETE FROM current_nodes WHERE id = ?";
>  	private static final String INSERT_SQL_WAY =
>   





More information about the dev mailing list