Здравствуйте, делаю простой отчет, но вываливается "Произошла ошибка"
Код:
<?xml version="1.0" encoding="UTF-8"?>
<report title="Отчет по остаткам IP-телефонии">
<month name="month_from" title="Дата"/>
</report>
Код:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="kernel_ost_change"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<style
name="Center"
isDefault="false"
hAlign="Center"
padding="0"
topPadding="1"
leftPadding="2"
bottomPadding="1"
rightPadding="1"
/>
<style
name="border"
isDefault="false"
border="Thin"
borderColor="#000000"
/>
<style
name="Right"
isDefault="false"
hAlign="Right"
topPadding="1"
leftPadding="1"
bottomPadding="1"
rightPadding="1"
/>
<parameter name="_filter" isForPrompting="false" class="bitel.billing.server.admin.reports.BGReportFilter"/>
<parameter name="_months" isForPrompting="false" class="java.util.Map"/>
<queryString language="bgbs"><![CDATA[import java.sql.*;
import java.util.*;
import java.util.regex.*;
import java.sql.*;
import bitel.billing.server.util.*;
import bitel.billing.server.contract.bean.*;
import bitel.billing.common.*;
import java.math.BigDecimal;
import java.text.DecimalFormat;
public void fillReport( con, filter, result )
{
monthFrom = filter.getCalendarParam( "month_from" );
query = "SELECT contract.title,contract.comment FROM contract LIMIT 0, 30";
res = new ArrayList( 1000 );
ps = con.prepareStatement( query );
rs = ps.executeQuery();
while ( rs.next() )
{
Map map = new HashMap( 2 );
map.put( "title", rs.getString( 1 ) );
map.put( "comment", rs.getString( 2 ) );
res.add( map );
}
result.setDataSource( res );
result.setParams( new HashMap( 1 ) );
}]]></queryString>
<field name="title" class="java.lang.String"/>
<field name="comment" class="java.lang.String"/>
<detail>
<band height="20">
<textField>
<reportElement x="0" y="0" width="50" height="20" />
<textFieldExpression class="java.lang.String">
<![CDATA[$F{title}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="51" y="0" width="200" height="20" />
<textFieldExpression class="java.lang.String">
<![CDATA[$F{comment}]]>
</textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
В логах получаю ошибку:
Код:
04-22/13:15:57 DEBUG [http-8080-1] server - [bitel.billing.server.reports.action.ActionReport] Generate report with id=kernel_ost_change
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - java.lang.NullPointerException
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.common.TimeUtils.getEndMonth(TimeUtils.java:777)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.common.TimeUtils.getEndMonth(TimeUtils.java:767)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at java.lang.reflect.Method.invoke(Method.java:616)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.Reflect.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.Reflect.invokeStaticMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.Name.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BSHMethodInvocation.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BSHPrimaryExpression.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BSHPrimaryExpression.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BSHAssignment.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BSHBlock.evalBlock(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BSHBlock.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BshMethod.invokeImpl(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BshMethod.invoke(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.BshMethod.invoke(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.This.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bsh.This.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.admin.reports.BGReportTemplate.processQuery(BGReportTemplate.java:426)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.admin.reports.BGReportTemplate.processReport(BGReportTemplate.java:396)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:308)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:379)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.reports.Report_Default.fillReportToStream(Report_Default.java:30)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:45)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.Executer.doModule(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.Executer.doPost(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at java.lang.Thread.run(Thread.java:636)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - java.lang.NullPointerException
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:309)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:379)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.reports.Report_Default.fillReportToStream(Report_Default.java:30)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:45)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.Executer.doModule(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.Executer.doPost(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - at java.lang.Thread.run(Thread.java:636)
04-22/13:15:57 DEBUG [http-8080-1] server - executing bitel.billing.server.reports.action.ActionReport; time => 21 ms.