Hello, I'm having a problem with libzdb. I have a connection pool to
sqlite and I get a connection to perform a select query. Now, while
processing the result set I want to update certain tables from the
database. The problem is:
If I get a new connection from the pool I get a "database file is
locked" so I'm gessing that a connection locks the database file while
it's active. The other solution may be to use the same conection to
execute the update, but that messes the result set to when it tries to
get next element I get a Segmentation Fault.
Is there a way to open a "Read only" connection so it doesn't lock the
entire database? If not, is there a way to make a copy of a result set
to execute another query?
--
Saludos.
José Antonio Sánchez
