Ultimately, I am looking for the steps that I need to take to make sure my swing application communicates with a sqlite db even though they may exist in different directories. I am trying to run my swing application by executing a jar outside the
IDE and be able to access a sqlite db.
Specifics:
I currently have a
java swing application that connects to sqlite db through JDeveloper IDE 11.1.1.4.0. The db resides in the following directory: C:\sqlite\Java_Wrapper\sample.s3db. I can access and update data in the db without a problem as I have added the sqlitejdbc-v056.jar (located:C:\sqlite\Java_Wrapper\sqlitejdbc-v056.jar) to the library class path. However, when I deploy my project files to a Jar file, execute it, a make a call to the db it I get a java.lang.ClassnotFoundException:org.sqlite.JDBC. When I open up the deployed jar file I see no indication that that the sqlite driver jar file was deployed with it. Any direction is appreciated....thanks.