BIRT Portal not releasing MS Access File Lock

Not sure if this is the appropriate forum for this but I couldn't see which one would be!

Has anyone else had a problem with the BIRT portal not releasing the MS Access locking file (.ldb)?

If I run a report that uses MS Access as the data source, a lock file is created. When I later close down the web-browser, the .ldb file is not deleted.

It is deleted some time later (it may be overnight).

Any advice anyone?

Find more posts tagged with

Comments

rmurphy

If you are using the Actuate BIRT Deployment Kit which offers interacitve capabilities, one of the features of the web application is to reuse connections. The timeframe the connection is held onto can be set in the web.xml See the following: 
<a class='bbc_url' href='http://www.birt-exchange.org/wiki/Configuration/#Connection_Pooling'>Connection Pooling Configuration</a> 
 
If you are using the open source viewer these settings do not apply. 
 
Either way, you are likely using the JDBC-ODBC Bridge which is not considered to be a "production" quality JDBC Driver and is likely the source of your issue. Is MS Access the only DB you have? Can you try with SQL Server? 
 
Rob

AlanC

Thanks for that advice Rob. I found the entry and will have a "play around" with the settings.
As to using SQL Server... Whilst we do utilise SQL Server for the majority of our systems, we do still have a number of smaller Access databases for which there are no plans to replace as yet. To add an overhead of exporting the data to SQL Server will reduce the attraction of BIRT as a reporting tool of choice, so we need to be able to use Access as a data source.

Thanks again