#200 RMaps SQLite MapCreationException when SQLite db file > 2GB

[Stefan Grewe]

When trying to create an RMaps SQLite atlas > 2GB, the following exception occurs repeatably:

Version: Mobile Atlas Creator (MOBAC) 1.9.3
Platform: Windows 7 (6.1) (windows)
Java VM: Java HotSpot(TM) 64-Bit Server VM (1.6.0_30-b12)
CPU cores: 4

Thread: AtlasThread 8
Map
name=Layer name 08 (2)
mapSource=Google Hybrid local
zoom=8
maxTileCoordinate=65023/32511
minTileCoordinate=32512/0
parameters=null
Map type: XML
Map implementation: Google Hybrid local.xml
Map revision: null

Error hierarchy:
MapCreationException: java.sql.SQLException: disk I/O error
SQLException: disk I/O error

mobac.exceptions.MapCreationException: java.sql.SQLException: disk I/O error
at mobac.program.atlascreators.RMapsSQLite.createTiles(RMapsSQLite.java:205)
at mobac.program.atlascreators.RMapsSQLite.createMap(RMapsSQLite.java:113)
at mobac.program.AtlasThread.createMap(AtlasThread.java:351)
at mobac.program.AtlasThread.createAtlas(AtlasThread.java:206)
at mobac.program.AtlasThread.run(AtlasThread.java:131)
Caused by: java.sql.SQLException: disk I/O error
at org.sqlite.DB.throwex(DB.java:288)
at org.sqlite.DB.executeBatch(DB.java:236)
at org.sqlite.PrepStmt.executeBatch(PrepStmt.java:83)
at mobac.program.atlascreators.RMapsSQLite.createTiles(RMapsSQLite.java:197)
... 4 more

[r_x]

Well that seems to be a limitation of the used SqliteJDBC library.

BTW: Do you know that SQLite atlases for RMAPS larger than 2GB don't make any sense because SQLite on Android is limited to databases smaller than 2GB?

[Stefan Grewe]

I have tried to switch the SQLiteJDBC file with the one on www.xerial.org. Unfortunately, it did not work.

I am using the RMAPS format not for RMAPS on Android, but for Galileo on iPhone. Is there a similar limitation?

[r_x]

It seems like the 64bit Windows part of the used SQLite library has problems with databases larger than 2GB - the 32 bit part does not have this problem.

Therefore a workaround would be to start MOBAC using an installed 32 bit JVM.

[r_x]

I have create a preview version with updated SQlite drivers. This version now should be able to create atlases larger than 4GB. Please give it a try:

http://www.datafilehost.com/download-d16fee89.html