Re: [sqlite] Sqlite Java blob

I really think your simply missing a ps.close(); before your connection.commit() Ulric ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

Having the complete stack trace of the exception would help a lot. Here are some thoughts: 1- You did not explicitly close the preparedstatement before calling commit. 2- You are trying to commit without having started a transaction. I don't think the problem is related to the setBytes() as I hav

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 > Subject: Re:

Re: [sqlite] Sqlite Java blob

sqlite.org] On Behalf Of Peter Kelly Sent: November 24, 2009 12:51 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite Java blob Thanks, I've tried that, but to no avail. Maybe a bit of background, our applaiction generates its froms from the database layout, this is so it can be use

Re: [sqlite] Sqlite Java blob

Thanks, I've tried that, but to no avail. Maybe a bit of background, our applaiction generates its froms from the database layout, this is so it can be used for a variety tasks. It talks to mysql and sqlite, so I was trying to keep the code as generic as possibe. I have a procedure - prepareStatem

Re: [sqlite] Sqlite Java blob

Thanks, I've tried that, but to no avail. Maybe a bit of background, our applaiction generates its froms from the database layout, this is so it can be used for a variety tasks. It talks to mysql and sqlite, so I was trying to keep the code as generic as possibe. I have a procedure - prepareStatem

Re: [sqlite] Sqlite Java blob

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 Peter Kelly Sent: November 23, 2009 10:47 PM To: sqlite-users@sqlite.org Subject: [sqlite] Sqlite Java