subreport-connection busy

[ktrinad]

By: madhuri - madhuri_ls

subreport-connection busy

2003-10-09 02:58

hi,

 

as you suggested , i am using ireport 0.2.2 . But still my subreport giving same message :

 

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:375) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:400) at java.lang.Thread.run(Thread.java:536) NESTED BY : 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:375) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:400) at java.lang.Thread.run(Thread.java:536) NESTED BY : dori.jasper.engine.JRException: Error executing report query : select VA_City,VA_Country from address where NU_EmpNo=? at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:379) at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423) at dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:400) at java.lang.Thread.run(Thread.java:536) Caused by: 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:375) ... 4 more Print not filled. Try to use an EmptyDataSource..

 

 

Even i was tryig jTds , But it's giving message : Driver not found . i have copied jar file in lib folder .

 

 

Please help

 

 

 

 

By: madhuri - madhuri_ls

RE: subreport-connection busy

2003-10-10 01:47

with jTds it's working.

 

 

 

 

By: Giulio Toffoli - gt78

RE: subreport-connection busy

2003-10-10 04:10

Try to upgrade to JasperReports 0.5.0.

 

You can find this bug in JasperReports bug history.

 

Giulio