From: Ruby Newbie <rubynewbie@...>
Date: 2005-10-25T00:53:47+09:00
Subject: sqlite3 busy_handler

------=_Part_12756_31518440.1130169013684
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Having trouble getting the sqlite3 busy_handler to work. The documentation
at http://sqlite-ruby.rubyforge.org/sqlite3/ lists *busy_handler*( data=3Dn=
il
) {|data, retries| ...} as the public instance method. So far I've tried

Class DbHandler
print "in DbHandler\n"
def busy_handler(*data)
print "in DbHandler.busy_handler\n"
return true;
end
end

and registering using
db =3D SQLite3::Database.new(....)
db.busy_handler(DbHandler)

as well as
handler =3D DbHandler.new
db.busy_handler(handler)

as well as
db.busy_handler(handler.busy_handler(data=3Dnil,retries=3Dnil))

My first attempt with a method named busy_handler outside of a separate
class was no better.

The code compiles and runs, but two separate processes running in parallel
will lock the database - when I would expect them to both run indefinitely
since I am never returning false from the busy_handler method I'm trying to
invoke.

Any ideas?

------=_Part_12756_31518440.1130169013684--