Re: [sqlite] SQLite Java Store Files in database

2010-04-04 Thread Erin Drummond
If you want to store files in a database using Java, you're better off not using SQLite None of the Sqlite JDBC drivers support streaming bytes to and from the database. You have to load the entire file into memory and store it in the database using setBytes(), and retrieve it using getBytes()

Re: [sqlite] SQLite Java Store Files in database

2010-04-04 Thread Simon Slavin
On 4 Apr 2010, at 9:47pm, Andreas Henningsson wrote: > So my question is. How do I store files in the database from Java? Is > it possible. I hope so. I don't want to change database. > Is there some other way to do this that work? I don't know if your Java method of using SQLite allows this,

[sqlite] SQLite Java Store Files in database

2010-04-04 Thread Andreas Henningsson
Hi I use SQLite in a project of mine. I want to strore files in the database. I tried to do it something like this. See Code section below. I get an error that say it is not implementet. See Message section below. I use this driver Class.forName("org.sqlite.JDBC"); The Jar files name is