#266 Loading of sqlite library failed in 1.9.16

[Sarah King]

disclaimer: brand new to osx

I created some maps in Windows but they didn't open when I put them into Xcode so thought I'd run the program on the mac instead.

Went to turn start.sh into an executable and got the pop up message instead so did the step that increases the memory. The output looks like this...

setups-mbp:Programs setup$ cd "Mobile Atlas Creator 1.9.16"
setups-mbp:Mobile Atlas Creator 1.9.16 setup$ chmod u+x start.sh
setups-mbp:Mobile Atlas Creator 1.9.16 setup$ java -Xms64m -Xmx1024M -jar Mobile_Atlas_Creator.jar
INFO - log4.xml not found - enabling default error log to console
INFO - Version: Mobile Atlas Creator (MOBAC) 1.9.16
INFO - Platform: Mac OS X (10.9.4)
INFO - Java VM: Java HotSpot(TM) 64-Bit Server VM (1.6.0_65-b14-462-11M4609)
INFO - Directories:
currentDir: /Volumes/Data/Programs/Mobile Atlas Creator 1.9.16
programDir: /Volumes/Data/Programs/Mobile Atlas Creator 1.9.16
tempDir: /var/folders/qy/g4p7t_sd03b4tl46mczmhxbc0000gn/T
userHomeDir: /Users/setup
userSettingsDir: /Volumes/Data/Programs/Mobile Atlas Creator 1.9.16
atlasProfilesDir: /Volumes/Data/Programs/Mobile Atlas Creator 1.9.16
userAppDataDir: /Users/setup/.mobac
INFO - System console available: true
INFO - Startup arguments (count=0):
INFO - Applying proxy configuration: host= port=
INFO - Total available memory to MOBAC: 1015.69 MiB
INFO - Map layer changed to: OpenStreetMap MapQuest
ERROR - Loading of SQLite library failed (SQLite.JDBCDriver): SQLite.JDBCDriver
INFO - Applying proxy configuration: host= port=
INFO - Applying proxy configuration: host= port=
INFO - Starting creation of MBTiles SQLite atlas "Unnamed atlas"
INFO - Altas creation finished
INFO - Starting creation of MBTiles SQLite atlas "Unnamed atlas"
INFO - Altas creation finished

• Volumes/Data is a secondary disk
• the default user is called setup

What do I need to do to get past this error?

thanks

[r_x]

Please make sure Mobile_Atlas_Creator.jar and sqlite-jdbc-3.7.15-M1.jar are located within the same directory.

[Sarah King]

Hi r_x, yes they're in the same directory.
Does it matter that they're on a secondary drive? Should I move onto the system drive?
https://www.evernote.com/shard/s271/sh/4c68c837-a435-4f74-b2b4-a12bd8cf55b1/cc24c4ddf3af610218461aed46ffc1e1/deep/0/Mobile-Atlas-Creator-1.9.16-and-MapView.png
screenshot:

[Sarah King]

I added the xml file and I've shorted the folder name (for my convenience and the version info is given in the terminal output anyway.

setups-mbp:MobAC setup$ java -Xms64m -Xmx1024M -jar Mobile_Atlas_Creator.jar
10:40:36,518 INFO [main] LogSystem: Logging configured by "/Volumes/Data/Programs/MobAC/log4j.xml"
10:40:36,524 INFO [main] SysInfo: Version: Mobile Atlas Creator (MOBAC) 1.9.16
10:40:36,529 INFO [main] SysInfo: Platform: Mac OS X (10.9.4)
10:40:36,529 INFO [main] SysInfo: Java VM: Java HotSpot(TM) 64-Bit Server VM (1.6.0_65-b14-462-11M4609)
10:40:36,529 INFO [main] SysInfo: Directories:
currentDir: /Volumes/Data/Programs/MobAC
programDir: /Volumes/Data/Programs/MobAC
tempDir: /var/folders/qy/g4p7t_sd03b4tl46mczmhxbc0000gn/T
userHomeDir: /Users/setup
userSettingsDir: /Volumes/Data/Programs/MobAC
atlasProfilesDir: /Volumes/Data/Programs/MobAC
userAppDataDir: /Users/setup/.mobac
10:40:36,533 INFO [main] SysInfo: System console available: true
10:40:36,533 INFO [main] SysInfo: Startup arguments (count=0):
10:40:36,537 DEBUG [main] SysInfo: Detected operating system: MacOsX (Mac OS X)
10:40:36,537 DEBUG [main] SysInfo: Desktop support: true
10:40:36,539 DEBUG [main] SysInfo: Desktop action OPEN supported: true
10:40:36,539 DEBUG [main] SysInfo: Desktop action EDIT supported: true
10:40:36,539 DEBUG [main] SysInfo: Desktop action PRINT supported: true
10:40:36,539 DEBUG [main] SysInfo: Desktop action MAIL supported: true
10:40:36,540 DEBUG [main] SysInfo: Desktop action BROWSE supported: true
10:40:37,167 INFO [main] Settings: Applying proxy configuration: host= port=
10:40:37,173 INFO [main] EnvironmentSetup: Total available memory to MOBAC: 1015.69 MiB
10:40:37,360 DEBUG [main] BerkeleyDbTileStore: Tile store path: /Volumes/Data/Programs/MobAC/tilestore
10:40:37,383 DEBUG [AWT-EventQueue-2] MAC: Starting GUI
10:40:37,420 INFO [AWT-EventQueue-2] JMapViewer: Map layer changed to: OpenStreetMap MapQuest
10:40:37,760 DEBUG [AWT-EventQueue-2] JAtlasTree: Loading profile
10:40:38,276 DEBUG [AWT-EventQueue-2] MainGUI: Selected grid zoom combo box item has changed: -1
10:40:38,695 DEBUG [Map preview thread 1] BerkeleyDbTileStore: Opening tile store db: "/Volumes/Data/Programs/MobAC/tilestore/db-MapQuest"
10:40:39,089 DEBUG [Map preview thread 5] MapQuest: Map source has been initialized
10:40:45,523 ERROR [AWT-EventQueue-2] SQLiteLoader: Loading of SQLite library failed (SQLite.JDBCDriver): SQLite.JDBCDriver
10:40:45,526 DEBUG [AWT-EventQueue-2] SQLiteLoader: SQLite library loaded. Driver class name: org.sqlite.JDBC
10:40:45,647 DEBUG [DBShutdown] BerkeleyDbTileStore: Closing all tile databases...
10:40:45,648 DEBUG [DBShutdown] BerkeleyDbTileStore: Closing tile store db "MapQuest"
10:40:45,653 DEBUG [DBShutdown] BerkeleyDbTileStore: All tile databases has been closed
10:40:45,653 INFO [AtlasThread 1] AtlasThread: Starting creation of MBTiles SQLite atlas "Unnamed atlas"
10:40:47,526 INFO [AtlasThread 1] AtlasThread: Altas creation finished
10:40:50,349 DEBUG [DBShutdown] BerkeleyDbTileStore: Closing all tile databases...
10:40:50,349 DEBUG [DBShutdown] BerkeleyDbTileStore: All tile databases has been closed

[r_x]

I don't have any personal experience with OSX and where to store what. You could try to replace the included sqlite library with the latest one from https://bitbucket.org/xerial/sqlite-jdbc/downloads

Because you use Java 6 you have to add it to the classpath manually:

java -Xms64m -Xmx1024M -cp sqlite-jdbc-3.8.5-pre1.jar -jar Mobile_Atlas_Creator.jar