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

2006-07-31 Thread David Crawshaw
Brannon wrote: It was just a warning. Instructions for MSVC added to the README.

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

2006-07-31 Thread Brannon King
> Thanks for the info. Points 2, 4 and 5 are covered by the > Makefile (DB.h is generated with javah), but I'll patch the > project for the variable declarations and the cast. Though I > have a feeling the cast is unncessesary, did VC throw an > error or warning for that? It was just a

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

2006-07-31 Thread David Crawshaw
Brannon King wrote: To compile the binary with VC71, I had to 1. move a dozen variable declarations to the top of the function 2. download the DB.h file separately from the build tree 3. change the jstrlen to end with "return (int)(s - str) - suppChars" 4. change my sqlite3 lib build to #define

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

2006-07-31 Thread Brannon King
to #define SQLITE_ENABLE_COLUMN_METADATA 5. reference the sqlite3 lib in a dll project containing the DB.c/h > -Original Message- > From: David Crawshaw [mailto:[EMAIL PROTECTED] > Sent: Monday, July 31, 2006 2:03 AM > To: Martin Pfeifle; sqlite-users@sqlite.org > Subject: Re: AW: AW: [sqlite] N

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

2006-07-31 Thread David Crawshaw
Martin Pfeifle wrote: could you please shortly outline the differences between your jdbc driver and the one developed by Christian Werner? I haven't looked too closely at the other driver, but from what I have seen, it is designed to work with the old callback exec() functions, so it supports

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

2006-07-31 Thread Martin Pfeifle
Sonntag, den 30. Juli 2006, 23:37:17 Uhr Betreff: 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 have

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

2006-07-30 Thread David Crawshaw
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

Re: [sqlite] New JDBC driver for SQLite

2006-07-30 Thread Michael Scharf
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

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

2006-07-30 Thread David Crawshaw
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

AW: [sqlite] New JDBC driver for SQLite

2006-07-30 Thread Martin Pfeifle
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 Hel

[sqlite] New JDBC driver for SQLite

2006-07-30 Thread David Crawshaw
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