Problem with Timestamp on Sybase

ericpias

I am using the BIRT report designer UI version 2.2.1 going against Sybase ASA 10.0.1 using the Sybase JConnect JDBC driver (jconn3).

I am building a very simple report that is attempting to chart an integer value (y-axis) against a timestamp value (x-axis). The viewer inside the designer UI seems to be able to chart this okay. When I run the report in the BIRT report viewer inside my web app in Apache Tomcat, the chart fails to show and I get the exceptions listed below. Anybody have any ideas on what I can do different?

Thanks,
Eric

Mar 18, 2008 2:55:57 PM org.eclipse.birt.chart.internal.datafeed.ResultSetWrappe
r initializeMeta
WARNING: Unable to determine data types from resultset
Mar 18, 2008 2:55:58 PM org.eclipse.birt.chart.exception.ChartException logThis
WARNING: Exception
org.eclipse.birt.chart.exception.ChartException: Unable to use a non-datetime da
ta to render a datetime axis.
at org.eclipse.birt.chart.computation.withaxes.PlotWithAxes.getTypedData
Set(PlotWithAxes.java:667)
at org.eclipse.birt.chart.computation.withaxes.PlotWithAxes.getTypedData
Set(PlotWithAxes.java:634)
at org.eclipse.birt.chart.computation.withaxes.PlotWith2DAxes.compute(Pl
otWith2DAxes.java:670)
at org.eclipse.birt.chart.factory.Generator.build(Generator.java:1021)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationImpl.onR
owSets(ChartReportItemPresentationImpl.java:523)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.p
rocessExtendedContent(LocalizedContentVisitor.java:772)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.v
isitForeign(LocalizedContentVisitor.java:414)
at org.eclipse.birt.report.engine.content.impl.ForeignContent.accept(For
eignContent.java:59)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.l
ocalize(LocalizedContentVisitor.java:145)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReport
ItemExecutor.execute(LocalizedReportItemExecutor.java:36)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPage
LM.java:85)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.lay
out(HTMLReportLayoutEngine.java:106)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.re
nder(RenderTask.java:583)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.
java:267)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unkn
own Source)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unkn
own Source)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(Unkno
wn Source)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHa
ndler.doExecution(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHa
ndler.__execute(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandl
er.execute(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProc
essor.__executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentPro
cessor.executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.ha
ndleGetPage(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentPro
cessor.process(Unknown Source)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUp
datedObjects(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.j
ava:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider
.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:
323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrateg
y.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453
)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:69
9)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPo
st(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBas
e.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
at java.lang.Thread.run(Thread.java:595)