java - Creating a sqlite-file within appengine -
im struggeling gae filesystem restrictions. creating tool can export datastructur lot of different output-files (json, xml...) 1 of them sqlite-database-file. have ideas how can done in restricted environment?
i tried creating inmemory database without success:
drivermanager.getconnection("jdbc:sqlite::memory:");
i tried use file-storage bucket:
drivermanager.getconnection("jdbc:sqlite:gs://"+bucketnameü+"/sqllite");
neither of them worked. i'm afraid not possible @ :( dont want start compute engine instance in order create sqllite file.
are there other frameworks out there possible create database file on fly.
here whole code:
connection c = null; try { class.forname("org.sqlite.jdbc"); c = drivermanager.getconnection("jdbc:sqlite:gs://"+bucketnameü+"/sqllite"); statement statement = c.createstatement(); statement.setquerytimeout(30); // set timeout 30 sec. statement.executeupdate("create table person (id integer, name string)"); c.close(); } catch ( exception e ) { system.err.println( e.getclass().getname() + ": " + e.getmessage() ); e.printstacktrace(system.out); }
i found interesting approach in google appengine: use sqlite file uploaded user
i tried sqljet inmemory database without success. gaevfs not idea either.
if still need access file system can create managed vms let avoid of app engine's limitations, particularly access file system.
Comments
Post a Comment