Re: [sqlite] Sqlite Java blob

Thanks for taking the time Ulric, I'm using sqlitejdbc-v054 from http://files.zentus.com/sqlitejdbc/, I notice they are up to v056, so I'll give that a go. The stack trace ERROR 53:13 [DB.prepareStatement() 697]: Error in sql: INSERT INTO delay_forms (t2_access_wp_action_required, t2_access_key,

Re: [sqlite] Sqlite Java blob

line that is failing 695 connection.commit(); Thanks for help so far. > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Peter Kelly > Sent: November 24, 2009 12:51 AM > To: sqlite-users@sqlite.org >

Re: [sqlite] Sqlite Java blob

e wrong. Any ideas greatly appreciated :) Ulric Auger wrote: > Use PreparedStatement setBytes method. > No need to convert to base64. > > Ulric > > -Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pet

Re: [sqlite] Sqlite Java blob

e wrong. Any ideas greatly appreciated :) Ulric Auger wrote: > Use PreparedStatement setBytes method. > No need to convert to base64. > > Ulric > > -Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pet

[sqlite] Sqlite Java blob

Hi, I've been tearining my hair out trying to figure out how store my image data in sqlite using Java. I think the best way to go is just store the base64 encoded string in the column, but I can for the life of me get a prepared statement for that to work. Can anybody show me how they are storing