Re: [sqlite] Retrieving ROWID value on duplicate conflict

> Naveen, > > There is no way to do what you want directly in SQL. You are looking for an > INSERT OR UPDATE type of functionality, this does not exist in SQL. > > Your program can retrieve the rowid of a conflicting insert by doing a select > before the insert. If there is a conflicting

[sqlite] New JDBC driver for SQLite

Hello all, I have written a new JDBC driver for SQLite. http://java.zentus.com/sqlitejdbc.html It is designed to be easy to read and as thin a layer as possible on top of the C functions. The new _prepare()/_step() API is surprisingly similar to the JDBC API, making it efficient code. SQLite

[sqlite] Way to "Bind" Columns in Prepare

Of course. Thanks.

AW: [sqlite] New JDBC driver for SQLite

Does the jdbc driver also provide the direct reading and writing of BLOBs? Best Matin - Ursprüngliche Mail Von: David Crawshaw <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Gesendet: Sonntag, den 30. Juli 2006, 14:56:18 Uhr Betreff: [sqlite] New JDBC driver for SQLite Hello all,

Re: AW: [sqlite] New JDBC driver for SQLite

Martin Pfeifle <[EMAIL PROTECTED]> wrote: Does the jdbc driver also provide the direct reading and writing of BLOBs? Yes, through PreparedStatement.setBytes() and ResultSet.getBytes(). I haven't added support yet for the java.sql.Blob type, because I am funadmentally opposed to the idea of SQL

Re: [sqlite] New JDBC driver for SQLite

Hi David, I quickly looked at the code -- it's amazingly small! I really like that. I have to do some performance tests to see if it fits my needs.. Michael I have written a new JDBC driver for SQLite. http://java.zentus.com/sqlitejdbc.html It is designed to be easy to read and as thin a

Re: Re: [sqlite] New JDBC driver for SQLite

Michael Scharf wrote: I quickly looked at the code -- it's amazingly small! I really like that. I have to do some performance tests to see if it fits my needs.. Thanks. I think you will find the JNI is not a problem, I tested it on its own and the overhead is non-existent. The problem you

[sqlite] Files required to be changed to handle different file system

Hi, I am porting SQLite to DVD, I am using the harddisk which uses our own file system. Can I know which are the files and API's to be changed for reading and writeing the database on to the disk. Thanx in advance, Regards, Vivek R