<< Next Blog | print | Previous Blog >>

SQLite3 Last Row Inserted ID Equal 0



Picture of IrvinWhen working with SQLite3, I had an issue recently where sqlite3_last_insert_rowid(database) was returning 0. This normally means that there have been no inserts performance against the database. In my case, I had just done an insert that came back as OK.

It turns out that the problem was that I had too many databases open at one time. In the interest of data partitioning for performance, I had created 6 databases. I guess the libsqlite3.dylib will not allow that many different databases to be open at one time. Things seem OK when I have 3 open. I will try to figure out how many databases can be open at one time and report back. Or if I find it in the SQLite documentation I will come back and edit this post to report it.



Recent Blogs
Installing ColdFusion MX 7, and the Apache Connector on Leopard Server (10.5.5) - 11:53:20 12/09/2008

More Info from Yahoo!

What Does a Sun Bankruptcy do to Enterprise? - 11:26:11 12/05/2008

More Info from Yahoo!

Setting Up VirtualBox Headless on Ubuntu 8.10 - 03:22:18 11/16/2008

More Info from Yahoo!

Bold Predictions About Rails - 01:31:56 10/29/2008

More Info from Yahoo!

iPhone SDK NDA Lifted Really? - 08:52:51 10/04/2008

More Info from Yahoo!

An Open Android Will Kill a Closed iPhone? - 08:32:01 10/04/2008

More Info from Yahoo!

Ads in iPhone Native Apps - 02:08:46 09/11/2008

More Info from Yahoo!

SQLite3 Last Row Inserted ID Equal 0 - 09:55:57 09/05/2008

More Info from Yahoo!

64-bit, NSXMLDocument, and XCode - 09:52:58 09/04/2008

More Info from Yahoo!

Mides and No Remote FTP - 10:36:36 08/27/2008

More Info from Yahoo!

More...