HELP ME FOR SUBREPORT

[2006 IR Open Dicussion]

By: Teddy_jasp - teddy_jasp

HELP ME FOR SUBREPORT

2006-01-24 01:51

Sorry for my bad english i'm a newbie!

This is my problem: i have created a primary report and compiling and running it without problems!

Second step i have created subreport and compiling and running it without prolems!After setting the subreport parameter in order to permit the comunication between them i have added the subreport to primary report but when pressing run report using connection button the following error message appears

 

Filling report... Error filling print... java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection busy by an other hstmt at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:773) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) at java.lang.Thread.run(Unknown Source) NESTED BY : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]La connessione è occupata dai risultati di un altro hstmt. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:773) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : passato_due at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:784) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]La connessione è occupata dai risultati di un altro hstmt. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:773) ... 2 more NESTED BY : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]La connessione è occupata dai risultati di un altro hstmt. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:773) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : passato_due at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:784) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]La connessione è occupata dai risultati di un altro hstmt. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:773) ... 2 more NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error executing SQL statement for report : passato_due at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:561) at net.sf.jasperreports.engine.fill.JRFillBand.prepareElements(JRFillBand.java:525) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:446) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:417) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1253) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:586) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:226) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:780) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : passato_due at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:784) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:437) ... 1 more Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]La connessione è occupata dai risultati di un altro hstmt. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:773) ... 2 more Print not filled. Try to use an EmptyDataSource

 

I hope someone will try to help me!

 

Thank you!

 

 

 

 

 

By: Lucian Chirita - lucianc

RE: HELP ME FOR SUBREPORT

2006-01-24 08:37

Are you using $P{REPORT_CONNECTION} as connectionExpression for the subreport? It seems that your JDBC/ODBC/MS SQL driver doesn't support two simultaneous open statements.

 

I think one solution is two use a different connection for the subreport. You'd have to create a new connection parameter and use its value as connectionExpression.

 

HTH,

Lucian