Make a tile db

[Fabien Carrion]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Valentin,

I run the cmd

java -classpath
.:../osmdroid-android/osmdroid-android-3.0.2.jar:./osmdroid-packager-3.0.1.jar:./lib/sqlitejdbc-v056.jar
org.andnav2.osm.mtp.OSMMapTilePackager -u
http://tile.openstreetmap.org/%d/%d/%d.png -t Mapnik -d
aguascalientes.sql.db -zmax 17 -n 21.987 -s 21.8226 -w -102.4207 -e
- -102.1677

and I get this error

Putting files into db : aguascalientes.sql.db ...java.sql.SQLException:
unable to open database file
at org.sqlite.DB.execute(DB.java:275)
at org.sqlite.DB.executeUpdate(DB.java:281)
at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:77)
at org.andnav2.osm.mtp.util.DbCreator.putFolderToDb(DbCreator.java:37)
at
org.andnav2.osm.mtp.OSMMapTilePackager.runCreateDb(OSMMapTilePackager.java:248)
at org.andnav2.osm.mtp.OSMMapTilePackager.run(OSMMapTilePackager.java:166)
at org.andnav2.osm.mtp.OSMMapTilePackager.main(OSMMapTilePackager.java:143)

Do you know why?

Thanks

- --
Fabien Carrion

() Campagne du ruban ASCII -- Contre les mails en html
/\ contre les pieces-jointes Microsoft
Web: http://fabien.carrion.free.fr/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk0/LzsACgkQTe/bvZWuSM9AyACgvr6cK1OUMxUUCjHeGoBOqios
gdMAn0pwy/sRXBLBNpPUbYm+/3NvRwMp
=f8f4
-----END PGP SIGNATURE-----

[Fabien Carrion]

Valentin,

It is working for me if I create and close connection and statement for
each execution of the statement.

Here is the patch I used.

Do you think we can apply it?

Thanks

On 01/25/2011 02:14 PM, Fabien Carrion wrote:
> Valentin,
>
> I run the cmd
>
> java -classpath
> .:../osmdroid-android/osmdroid-android-3.0.2.jar:./osmdroid-packager-3.0.1.jar:./lib/sqlitejdbc-v056.jar
> org.andnav2.osm.mtp.OSMMapTilePackager -u
> http://tile.openstreetmap.org/%d/%d/%d.png -t Mapnik -d
> aguascalientes.sql.db -zmax 17 -n 21.987 -s 21.8226 -w -102.4207 -e

> -102.1677
>
>
> and I get this error
>
> Putting files into db : aguascalientes.sql.db ...java.sql.SQLException:
> unable to open database file
> at org.sqlite.DB.execute(DB.java:275)
> at org.sqlite.DB.executeUpdate(DB.java:281)
> at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:77)
> at org.andnav2.osm.mtp.util.DbCreator.putFolderToDb(DbCreator.java:37)
> at
> org.andnav2.osm.mtp.OSMMapTilePackager.runCreateDb(OSMMapTilePackager.java:248)
> at org.andnav2.osm.mtp.OSMMapTilePackager.run(OSMMapTilePackager.java:166)
> at org.andnav2.osm.mtp.OSMMapTilePackager.main(OSMMapTilePackager.java:143)
>
>
> Do you know why?
>
> Thanks
>

--

[valentin.blot0]

Hi,

I don't think it's a good idea to close a connection, create a
prepared statement and reopen the connection at each iteration, since
the goal of a prepared statement is to make fast updates. I'm looking
at it now, and I let you know.

On Jan 27, 12:08 am, Fabien Carrion <fabien.carr...@gmail.com> wrote:
> Valentin,
>
> It is working for me if I create and close connection and statement for
> each execution of the statement.
>
> Here is the patch I used.
>
> Do you think we can apply it?
>
> Thanks
>
> On 01/25/2011 02:14 PM, Fabien Carrion wrote:
>
>
>
> > Valentin,
>
> > I run the cmd
>
> > java -classpath
> > .:../osmdroid-android/osmdroid-android-3.0.2.jar:./osmdroid-packager-3.0.1.jar:./lib/sqlitejdbc-v056.jar
> > org.andnav2.osm.mtp.OSMMapTilePackager -u

> >http://tile.openstreetmap.org/%d/%d/%d.png-t Mapnik -d

> > aguascalientes.sql.db -zmax 17 -n 21.987 -s 21.8226 -w -102.4207 -e
> > -102.1677
>
> > and I get this error
>
> > Putting files into db : aguascalientes.sql.db ...java.sql.SQLException:
> > unable to open database file
> >    at org.sqlite.DB.execute(DB.java:275)
> >    at org.sqlite.DB.executeUpdate(DB.java:281)
> >    at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:77)
> >    at org.andnav2.osm.mtp.util.DbCreator.putFolderToDb(DbCreator.java:37)
> >    at
> > org.andnav2.osm.mtp.OSMMapTilePackager.runCreateDb(OSMMapTilePackager.java:248)
> >    at org.andnav2.osm.mtp.OSMMapTilePackager.run(OSMMapTilePackager.java:166)
> >    at org.andnav2.osm.mtp.OSMMapTilePackager.main(OSMMapTilePackager.java:143)
>
> > Do you know why?
>
> > Thanks
>
> --
> Fabien Carrion
>
> ()  Campagne du ruban ASCII -- Contre les mails en html
> /\  contre les pieces-jointes Microsoft
> Web:http://fabien.carrion.free.fr/
>

>  sql.patch
> 1KViewDownload
>
>  signature.asc
> < 1KViewDownload

[valentin.blot0]

BTW the db tile packager has also been included in Mobile Atlas
Creator, in the latest alpha release, and I encourage you to use MOBAC
instead of MapTilePackager.

On Jan 27, 1:31 pm, "valentin.blot0" <valentin.bl...@gmail.com> wrote:
> Hi,
>
> I don't think it's a good idea to close a connection, create a
> prepared statement and reopen the connection at each iteration, since
> the goal of a prepared statement is to make fast updates. I'm looking
> at it now, and I let you know.
>
> On Jan 27, 12:08 am, Fabien Carrion <fabien.carr...@gmail.com> wrote:
>
> > Valentin,
>
> > It is working for me if I create and close connection and statement for
> > each execution of the statement.
>
> > Here is the patch I used.
>
> > Do you think we can apply it?
>
> > Thanks
>
> > On 01/25/2011 02:14 PM, Fabien Carrion wrote:
>
> > > Valentin,
>
> > > I run the cmd
>
> > > java -classpath
> > > .:../osmdroid-android/osmdroid-android-3.0.2.jar:./osmdroid-packager-3.0.1.jar:./lib/sqlitejdbc-v056.jar
> > > org.andnav2.osm.mtp.OSMMapTilePackager -u

> > >http://tile.openstreetmap.org/%d/%d/%d.png-tMapnik -d

[valentin.blot0]

I submitted a patch to osmdroid. The issue was that the inputstream in
the loop was never closed.

[valentin.blot0]

It has been commited in osmdroid.

[longgangbai]

在 2011年1月26日星期三UTC+8上午4时14分56秒，Fabien写道：

hi ,now I want to study hao to make a custom tile db, please! give me a sample ,OK? thanks