Exception in Jasper while executing SQL statement

[raggy_mama]

Hi everyone,

I'm facing this exception while trying to open my JasperReport from my Java application

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Unnamed

Can somebody tell me why this is occuring and how can I resolve it?? When I try to run this report from iReport tool, I didn't face any issue and the output was as expected

 

[szaharia]

Hi,

Could you post the entire stacktrace here, in order to see the root cause of this error?

Thank you,

sanda

[raggy_mama]

2010-09-14 15:46:26,071 ERROR [net.sf.jasperreports.engine.fill.JRFillSubreport] Fill 727446533: exception
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Unnamed
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(Unknown Source)
    at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:440000009f.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1458)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4016)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1414)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:176)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:151)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
    at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
    ... 10 more

 

This is the error that I get on my JBoss...Thanks for the help /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

[szaharia]

So, it is caused by a tranzaction failure on MS SQLServer. Maybe this article could be useful in this case.

Hope this helps,

sanda