Can JasperFillManager.fillReport(report, parameters, conn) lock my database?

[marie_1]

 

Hi,

 

We've encountered a situation where JasperFillManager.fillReport(report, parameters, conn) seems to be locking the database, even when passed a read-only connection.  Is this possible?  We have users running multiple large reports encountering the database locking.

 

Also, we use a home grown java program to run reports created and compiled in iReports.  Is it possible to have 2 or more JasperFillManager.fillReport calls running against the same database without locking each other out?

 

Here's a code snippet showing the fillManager call:

 

    Connection conn = null;

    SQLiteConfig config = new SQLiteConfig();

    config.setReadOnly(true);

 

    conn = DriverManager.getConnection(connectionStatement, config.toProperties());

    conn.setAutoCommit(false);

 

    System.out.println("Is connection ready only:   " + conn.isReadOnly());

 

    JasperPrint print = JasperFillManager.fillReport(report, parameters, conn);

    conn.close();

    

Any help on the issue of ensuring that the connection is readonly would be appreciated. 

 

Marie