raggy_mama
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by raggy_mama
-
-
Hi everyone,
I'm facing this exception while trying to open my JasperReport from my Java applicationnet.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
Exception in Jasper while executing SQL statement
in Products
Posted
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