Make web app open SQLite db on server

arturhoo

Make web app open SQLite db on server

in Contributed Library Questions • 2 years ago

Hi there!

I am working on a project that uses the awesome SQLibrary by Florian Jenett to connect to a SQLite database. The command is as follows:

db = new SQLite(this, "data/twitter.db");

The problem is, when I export the app, and try to run it on the browser, it always try to find the file in the user "workspace", not in the server's.

Is there anything I can do?

Thank you in advance!

Replies(3)

PhiLho

Re: Make web app open SQLite db on server

2 years ago

Give the address of the server instead of using a relative path.

arturhoo

Re: Make web app open SQLite db on server

2 years ago

phi.lho, thank you for your response!

The path, from the server pov is /www/users/grad/ccomp/08/artur/poc/data/twitter.db - tried that with no luck, the java console gives me:

Sorry can't find any file named /www/users/grad/ccomp/08/artur/poc/data/twitter.db make sure it exists and the path is correct.

I believe the java on the client side is trying to access the path quoted above, not the applet on the server side.

Also tried giving the http:// address but the library doesn't seem to understand that.

PhiLho

Re: Make web app open SQLite db on server

2 years ago

The address /www/xxx cannot work, as the client will look in the local computer.
Indeed, I was thinking of a http:// address, although I don't know if they can work with SQLite databases, since usually we give the path to a database file, not to a gateway.
You should search how to access a SQLite database remotely.

Top Reply