• Post Reply Bookmark Topic Watch Topic
  • New Topic

Running Java App with SQLite on Ubuntu  RSS feed

 
Don Joe
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First off, I dabble with Java and I dabble with Linux by no means am I a pro!

I have built a Java app that uses SQLite (sqlite-jdbc-3.8.7.jar). Running the jar file on windows works as expected however, trying to run it on Ubuntu Server 14.04 has turned into quite a task!

I put together a brand new machine in VirtualBox for testing. I installed Java (sudo apt-get install default-jre) and have installed SQLite (sudo apt-get install cl-sql-sqlite3 sqlitebrowser). I created a new sub-directory within my home directory and copied over the jar file. From terminal, I then run the command: sudo java -jar ProductionView.jar and I receive a java.lang.unsatisfiedlinkerror. For troubleshooting, within the app, before making a connection to the db, I have printed out the location of where the db is to be created and it is correct (see attached pic). Is there more that needs to be configured before I can run this app on Ubuntu? I have posted the relevant code below (AppDatabasePath() is what is printed in the image...). Any help would be appreciated!

pv.png
[Thumbnail for pv.png]
 
Jacob Anawalt
Ranch Hand
Posts: 64
Linux Netbeans IDE Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
UnsatisfiedLinkError sounds like it's not finding the native binary to do SQLite.

I don't know offhand what version of SQLite you get on Ubuntu Server 14.04, but I'd double check that it's compatible with 3.8.7 that you're trying to use. It's too bad the error message doesn't mention what shared object (.so) it's trying to load.

You may have better luck with the SQLite JDBC source and Ubuntu people if something doesn't turn up here.
 
Don Joe
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the response Jacob. I have posted the question on the Xerial forum however, this forum does not seem to be too active. Can you recommend any active forums that will better suit this issue?
 
Jacob Anawalt
Ranch Hand
Posts: 64
Linux Netbeans IDE Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd give Ask Ubuntu, the Ubuntu Forums and their IRC channel a go while looking around or checking other versions of the driver jar.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!