[sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-27 Thread Hector Guilarte
Hello everyone, I'm new to SQLite as well as to this list. I'm writing because I was planning on using SQLite for a personal -but public- project that I wanted to make available through Google App Engine. It is basically a SQLite to CSV converter and a SQLite to VCard converter. In other words, I

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread Hector Guilarte
Hello? I'm starting to feel hopeless, No luck in StackOverflow and no luck here :-(... Well, i guess it just can't be done. On Wed, Jun 27, 2012 at 10:13 AM, Hector Guilarte wrote: > Hello everyone, > > I'm new to SQLite as well as to this list. I'm writing because I was > planning on using SQL

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread OBones
If you've got the database in a stream, why can't you save it to a disk file and then use this file with sqlite? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread Hector Guilarte
Because I want it to run on Google App Engine. GAE doesn't allow to write to the FileSystem, so I can't open the JDBC Connection to the SQLite file and therefore I can't read the data to convert to CSV. I upload the file to Google App Engine with a HTML form and that's how I get it in an InputStre

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Hector Guilarte [hector...@gmail.com] Sent: Thursday, June 28, 2012 8:22 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly Because I want it

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread Hector Guilarte
gt; > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of Hector Guilarte [hector...@gmail.com] > Sent: Thursday, June 28, 2012 8:22 AM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] Load S

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread Pavel Ivanov
On Thu, Jun 28, 2012 at 9:54 AM, Hector Guilarte wrote: > I don't think it would. > > Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db", > config.toProperties()); > > is telling to open a connection to the file "sample.db" which is located in > the same folder as the applicatio

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread Sylvain Pointeau
It will not be possible with SQLite but it would be possible using H2. http://www.h2database.com/html/advanced.html#file_system maybe you could convert the sqlite to H2 somewhere in your process? Best regards, Sylvain ___ sqlite-users mailing list sqlit

Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly

2012-06-28 Thread stefanos sofroniou
et me know. > > From: Hector Guilarte >To: sqlite-users@sqlite.org >Sent: Thursday, June 28, 2012 4:08 PM >Subject: Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly > >Hello? > >I'm starting to feel hopeless, No luck in StackOverflow and no luck here