Jasper error: Caused by SQLServerException: Transaction (Process ID 58) was deadlocked on thread | c

Posted by Saky on Stack Overflow See other posts from Stack Overflow or by Saky
Published on 2010-05-05T08:55:18Z Indexed on 2010/05/05 8:58 UTC
Read the original article Hit count: 321

Filed under:

jasper

|

jasper-reports

|

sql

I got the above error in my jasper report mail. The query that is used in the report is quite complicated (for me). Reading different posts I conclude that to solve this the I have to change the query to

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
GO
BEGIN TRANSACTION
... my query ...
COMMIT TRANSACTION

? I wonder if this is the correct way to solve the error and that if it has any side effects? Has it happened to anyone in the Jasper reports? Does anyone know if there is a better solution exist to the problem?

(Although that I have not yet tested the above solution, if anyone can give any insight on this will be helpful.)

© Stack Overflow or respective owner

Related posts about jasper

Displaying Multiple Tables in a Page in Jasper Reports using ireports/Jasper Assistant

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a report to be printed / exported to PDF format. for that i am using jasper reports. I have 8 individual pages to be exported. so i prepared 8 separate design files. In that 6 pages are having more static text and mere direct mapping and remaining two pages consists of table like… >>> More
Java error starting with "log4j:WARN No appenders could be found for logger" in ZuckerReports SugarC

as seen on Server Fault - Search for 'Server Fault'
Greetings all. I apologise for posting this problem here, but I do so in desperation after receiving no response on the SugarCRM forums. Even if a reader is unfamiliar with ZuckerReports or SugarCRM some general advice on Java may be of use to me. I have installed ZuckerReports v1.12 in SugarCRM… >>> More
IDEA modular problem (jsp)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have project in with 2 separate modules(frontend and backend, first depends on second). When I'm trying to access backend code from frontend code, things going fine. Things turn for the worse when I do the same from jsp. This is stacktrase for simple accessign bean <jsp:useBean id="mybean"… >>> More
stretch a row to fit the data in jasper reports using iReport

as seen on Stack Overflow - Search for 'Stack Overflow'
How do i stretch a text field to fit the data, If data exceeds the band height the text field doesn't stretch. I have added the text field tag in my jrxml... Example:- >>> More
Jasper report not showing detail section

as seen on Stack Overflow - Search for 'Stack Overflow'
I have designed a report in iReport and now I am using it in my application. The problem is that the report is generated showing all the data except the detail section data. There is no database connectivity problem, as the column header shows data which is coming from database. Only the detail section… >>> More

Related posts about jasper-reports

How to solve this nullPointer Exception in jasper report?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am new to jasper report, I need to create pdf document with BeanDatasource and subreport. I refer the following blog " http://knol.google.com/k/jasper-reports-working-with-beans-and-sub-report# " . I followed all the steps perfectly. While i am running the report using IReport i can get the… >>> More
Applet Loading Error - Jasper Report

as seen on Stack Overflow - Search for 'Stack Overflow'
I encountered very silly error , but any way i can not figure out solution.i am loading java applet which encompass a simple jasper viewer in it. when the applet is loaded it throws following exception. SEVERE: Servlet.service() for servlet JasperReportServlet threw exception java.lang.ClassNotFoundException:… >>> More
How to resolve: 'cmd' is not recognized as an internal or external command?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched other forums to solve this error where it would either end with: 1.) re-install OS 2.) Setting path variable C:/Windows/System32 The latter did not work, and as you can probably imagine, I do not want to have to re-install my OS... I am running the command "mvn jetty:run" and the… >>> More
Error loading the report template:org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid con

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, i'm newer in jasper reports.i've some problem when i call iReport from jsp....some error occurs at run time as like below :- Error loading the report template: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'head'. One of '{"http://jasperreports… >>> More
BIRT vs Jasper Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I goggled for 2 hours to find what shall I use. I found that both are good and have good community. BIRT is supported by IBM, IBM integrated Tivoli reports with it. This proves it is good and will keep growing. Jasper Reports has fairly bid community and (probably) a better report designed… >>> More