Jump to content
Changes to the Jaspersoft community edition download ×

Connection Busy for SubReport

Recommended Posts

By: Cesar A. Correia - cesarac

Connection Busy for SubReport

2003-02-11 06:05

Hello, all!


My problem: the subreport try fire a query in a connection, passed by parameter, but occur the folloing error:


Opening connection....


java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt


at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)


at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)


at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3104)


at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214)


at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:89)


at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:365)


at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:132)


at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:363)


at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:380)


at java.lang.Thread.run(Thread.java:536)


Any suggestion?

Thanks in advance!





By: Cesar A. Correia - cesarac

RE: Connection Busy for SubReport

2003-02-11 09:16

in time...


My database target is Microsoft SQL Server. I make a test with Oracle and all fine.


Any suggestion?





By: Teodor Danciu - teodord

RE: Connection Busy for SubReport

2003-02-11 09:38




The problem is that the ODBC-JDBC driver cannot

execute the subreport query before the master

report result set is retrieved or closed.


This means you either change the JDBC driver

or pass a different connection object to be used

only by the subreport.


I hope this helps.







By: Cesar A. Correia - cesarac

RE: Connection Busy for SubReport

2003-02-11 10:22



Using a JDBC driver (native, no JDBC-ODBC bridge) all work!!


It's a strange restriction from JDBC-ODBC bridge...

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...