SQLite to load a map

i've been using the SQLite JDBC driver in order to load maps and filenames from an SQLite *.s3db file. locally, it works fine.

as soon as i upload it to my webserver (which is on my local network, controlled by me), it just blanks out and sits there.

java.lang.NoClassDefFoundError

at org.sqlite.Conn.<init>(Conn.java:11)

at org.sqlite.JDBC.connect(JDBC.java:38)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at MapPanel.grabTiles(MapPanel.java:40)

at MapPanel.setup(MapPanel.java:22)

at processing.core.PApplet.handleDisplay(PApplet.java:1281)

at processing.core.PGraphics.requestDisplay (PGraphics.java:564)

at processing.core.PApplet.run(PApplet.java:1450)

at java.lang.Thread.run(Unknown Source)

the particular chunk of code in question is this:

publicvoid grabTiles()

{

try{

String fileName ="curse.s3db";

Class.forName("org.sqlite.JDBC");

Connection conn = DriverManager.getConnection("jdbc:sqlite:"+fileName);

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select * from tiles__map");

...

and the line in particular:

Connection conn = DriverManager.getConnection("jdbc:sqlite:"+fileName);

note - "fileName" is "curse.s3db" .. i have also tried "./curse.s3db" and various urls referencing the db file on the remote server or my local hard drive, depending on the test.

this even happens when i run the applet in an index.html file in my own local hard drive, in the same directory as everything else that should be necessary.

again.. locally, everything works like magic. as soon as i try to embed it, it breaks.

is there some parameter i need to pass to it in the HTML tag that i don't know about in order to tell it where to find everything else?

i've tried signing the applet, though i doubt it should be necessary to load files from the same directory the applet is being run from on the remote server. i'm not touching anything client side.

any help would be greatly appreciated, as i really want to get an SQLite database file working with my game. for what i need to use it for, it is a much better alternative to MySQL or similar packages.

the directory on the remote server is basically like this:

images/

curse.s3db

curse.jar

index.html

..same as it is on my local machine.. and if i were to double-click the .jar on my local machine, it runs fine without any errors. as soon as i try to run it remotely (and load the files remotely rather than from my own pc) it doesn't know where to look for curse.s3db.

[3047 byte] By [haliphaxa] at [2007-11-26 19:42:57]