"-DSQLITE_ENABLE_LOCKING_STYLE=1" I personally found that this is not as simple as just turning on this compiler flag. When I turned on this flag (set it to 1) I could then not get the latest version of SQLite to compile, and my queries here as to why it wouldn't compile went unanswered.
On Tue, May 27, 2008 at 12:01 AM, BareFeet <[EMAIL PROTECTED]> wrote: > Hi all, > > As you may know, I posted a comparison of various SQLite management > tools (mainly for Mac OS X) at: > http://www.tandb.com.au/sqlite/compare/?ml > One of the features I compare is whether each tool can open a database > file on a remote volume. Several of the applications there require a > JDBC plug in, for which I've been using the Zentus sqlitejdbc. That > plug in (and therefore those applications) fail to open files on a > remote volume. > > On a separate discussion forum, about the Zentus sqlitejdbc, I > suggested that they enable their implementation of SQLite to open > files on shared Mac OS volumes (ie via AppleShare). As I understand > it, the default release of SQLite source code still does not > facilitate this, but requires a small compile time change: > > -DSQLITE_ENABLE_LOCKING_STYLE=1 > > I believe that this is enabled in the SQLite that's distributed in Mac > OS X, and was due to be included in the SQLite source code, but I > haven't seen it appear yet. > > Two questions: > > 1. Will this be enabled by default in the SQLite source code soon? > > 2. The author (I believe) of the Zentus SQLiteJDBC comments below. > What can I tell him? > > Thanks, > Tom > BareFeet > > ---- > From: "David Crawshaw" <[EMAIL PROTECTED]> > Date: 4 May 2008 4:02:02 PM > To: [EMAIL PROTECTED] > Subject: [sqlitejdbc] Re: Opening SQLite database file on Mac OS X > AppleShare volume > Reply-To: [EMAIL PROTECTED] > > Is this turned on the SQLite binaries for Mac OS X? If so, I'm willing > to add it to the SQLiteJDBC binary, but not until then. Yes, it's a > terrible bug on Apple's part, yes, SQLite needs to work around it, but > this driver's binary releases should remain as similar as possible to > the main binary releases. > > Compiling your own version with this is easy. > > d. > > ---- > Date: 2008/4/26 > From: BareFeet > > Here's a quote from the author of SQLite, Dr Richard Hipp: > http://www.mail-archive.com/sqlite-users@sqlite.org/msg22772.html > > > -DSQLITE_ENABLE_LOCKING_STYLE=1 > > > > We are working toward turning on this patch by default, but we are > > not quite there yet. > --~--~---------~--~----~------------~-------~--~----~ > Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en > To unsubscribe, send email to [EMAIL PROTECTED] > -~----------~----~----~----~------~----~------~--~--- > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
