| problem to run rptdesign(version 2.0.1) [message #206941] |
Mon, 18 December 2006 02:50 |
Eclipse User |
|
|
|
Originally posted by: gk_jap.gmail.com
hi
I have a rptdesign using
eclipse-SDK-3.1.1-win32
emf-sdo-xsd-SDK-2.2.0M3
GEF-ALL-3.1.1
birt-report-framework-2_0_1
It run well from eclipse IDE.
Now I want to run this from my context.For this I use birt-runtime-2_1_1.
also i copied driver in
WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jd bc\drivers.
But in run time the given error occured.
***********************error*************************
The following items have errors:
Table (id = 6):
+ Cannot get the type for column: 1
Cannot get column type.
SQL error #1: null
odaconsumer.CannotGetColumnType ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the
type for column: 1
Cannot get column type.
SQL error #1: null
at
org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.d oGetNativeColumnType(ResultSetMetaData.java:210)
at
org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.g etColumnType(ResultSetMetaData.java:153)
at
org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.g etColumnTypeAsJavaClass(ResultSetMetaData.java:224)
at
org.eclipse.birt.data.engine.odaconsumer.ProjectedColumns.<init >(ProjectedColumns.java:55)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oGetProjectedColumns(PreparedStatement.java:400)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:340)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etColumnsProjection(PreparedStatement.java:1028)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:258)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:271)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:226)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:366)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:139)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:122)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:112)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1541)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:187)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(ReportEngineService.java:652)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(ReportEngineService.java:541)
at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(BirtViewerReportService.java:499)
at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(BirtRunAndRenderActionHandler.java :61)
at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:82)
at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(EngineFragment.java:136)
at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(AbstractBaseFragment.java:76)
at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Bi rtEngineServlet.java:106)
at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(BaseReportEngineServlet.java:129)
at
org.eclipse.birt.report.servlet.BaseReportEngineServlet.doPo st(BaseReportEngineServlet.java:153)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal (StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:117)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Sta ndardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapte r.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get
column type.
SQL error #1: null
at
org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData.getC olumnType(ResultSetMetaData.java:157)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaRe sultSetMetaData.getColumnType(OdaResultSetMetaData.java:159)
at
org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.d oGetNativeColumnType(ResultSetMetaData.java:204)
... 59 more
Caused by: org.gjt.mm.mysql.jdbc2.NotImplemented
at
org.gjt.mm.mysql.jdbc2.ResultSetMetaData.getColumnClassName( ResultSetMetaData.java:77)
at
org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData.getC olumnTypeForSpecialJDBCDriver(ResultSetMetaData.java:175)
at
org.eclipse.birt.report.data.oda.jdbc.ResultSetMetaData.getC olumnType(ResultSetMetaData.java:148)
... 61 more
**************************************************
this is my rptdesign file.
******************************************************
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.0.1 Build
<20060222-1204></property>
<property name="units">in</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="4">
<property
name="odaDriverClass">org.gjt.mm.mysql.Driver</property>
<property
name="odaURL">jdbc:mysql://localhost/learnityv5</property>
<property name="odaUser">root</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="5">
<property name="dataSource">Data Source</property>
<property name="queryText">select *
from admin_user</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new
Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="6">
<property name="textAlign">center</property>
<property name="verticalAlign">middle</property>
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<column id="20"/>
<column id="21"/>
<header>
<row id="7">
<property name="backgroundColor">#800040</property>
<property name="fontWeight">bold</property>
<property name="color">#FFFFFF</property>
<cell id="8">
<label id="9">
<text-property
name="text">user_id</text-property>
</label>
</cell>
<cell id="10">
<label id="11">
<text-property
name="text">password</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="12">
<cell id="13">
<data id="14">
<expression
name="valueExpr">row["user_id"]</expression>
</data>
</cell>
<cell id="15">
<data id="16">
<expression
name="valueExpr">row["password"]</expression>
</data>
</cell>
</row>
</detail>
<footer>
<row id="17">
<cell id="18"/>
<cell id="19"/>
</row>
</footer>
</table>
</body>
</report>
************************************************************ **************
what is problem??
plz reply me
jap
|
|
|
Powered by
FUDForum. Page generated in 0.02319 seconds
Home