Database lock problem.

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?