Connection Busy for SubReport

[2002 JI Open Discussion]

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

 

Hi,

 

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.

Teodor

 

 

 

 

 

By: Cesar A. Correia - cesarac

RE: Connection Busy for SubReport

2003-02-11 10:22

Thanks!!

 

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

 

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