Re: [sqlite] load database into memory java applet

[Simon Slavin]

On 12 Oct 2011, at 7:35am, Orçun Ertuğrul wrote:

> I am trying to load sqlite database that is placed on the net from an
> applet. When trying to attach http address as source, it gives "Unable to
> open database file" error.

Sorry, but although the syntax of a URL allows you to specify 'http://', the 
driver in SQLite recognises only 'file://'.  If you have your shared filespace 
mapped to a folder then and can specify the file location as 
'file://' then it should work.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] load database into memory java applet

[Orçun Ertuğrul]

 I am trying to load sqlite database that is placed on the net from an
applet. When trying to attach http address as source, it gives "Unable to
open database file" error.


Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite::memory:");
String attachStmt = "ATTACH " + "'
http://localhost:8080/appletOrcun/SertifikaDeposu.svt'" + " AS src";
Statement stt = conn.createStatement();
stt.execute(attachStmt);
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] load database into memory java applet

[Stephan Beal]

On Mon, Oct 10, 2011 at 12:57 PM, wrote:

> Connection conn = DriverManager.getConnection("jdbc:sqlite:memory:");
>

try:

jdbc:sqlite::memory:

note the extra colon. i don't know if that will work, but it is at least
semantically correct (whereas the version you post is providing the name
"memory:", which is not correct).

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] load database into memory java applet

[orcun . ertugrul]

Hi all;
I am new to mailing list. My database file on the net (in a http address)
and i wanna load that file from an applet. I tried the below code and it
gives "The filename, directory name or volume label syntax is incorrect"
error.

Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:memory:");
String attachStmt = "ATTACH " +
"'http://localhost:8080/appletOrcun/SertifikaDeposu.svt'" + " AS src";
Statement stt = conn.createStatement();
stt.execute(attachStmt);


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users