There are errors on the report page [message #95009] |
Mon, 28 November 2005 22:32  |
Eclipse User |
|
|
|
*This was posted to the incorrect list. Reposting here*
I am testing out BIRT as a replacement for Crystal Reports within our
organization and have run into a snag. I am attempting to connect to a
Progress 9.1C database via JDBC and believe I have everything set up
correctly. I was able to create a new report, create a data source (Test
Connection says "Connection Sucessful), and create a data set (Preview
Results shows the data as expected). I then added a table and dropped
three fields into the Detail section. However, when I go to preview the
report I get the following error:
There are errors on the report page:
+ There are error(s) in Table:null
Per another thread on this topic, I looked at the bindings for my table
and it appears to be correctly linked to my data set. Gary Xue had
suggested that I confirm that the JDBC drivers were correctly installed
into this directory:
" eclipse\plugins\org.eclipse.birt.report.viewer_1.0.1\birt\pl ugins\org.e
clipse.birt.report.data.oda.jdbc\drivers"
I will double-check that tomorrow, but I am 99% certain the driver was in
there. Does anybody have any other suggestions for me to try? Here is my
report design (please excuse any word wrapping problems):
‑‑‑
<?xml version="1.0" encoding="UTF‑8"?>
<!‑‑ Written by Eclipse BIRT 1.0 ‑‑>
<report xmlns=" http://www.eclipse.org/birt/2005/design" version="2">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.1
Build<20050729‑0746></property>
<property name="units">in</property>
<data‑sources>
<oda‑data‑source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Vantage 5.0 Data
Source">
<property
name="odaDriverClass">com.progress.sql.jdbc.JdbcProgressDriver </property>
<property
name="odaURL">jdbc:jdbcprogress:T:oc_apps1:2550:vantage</property >
<property name="odaUser">sysprogress</property>
<encrypted‑property name="odaPassword">REMOVED FROM
POST</encrypted‑property>
</oda‑data‑source>
</data‑sources>
<data‑sets>
<oda‑data‑set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Employees">
<property name="dataSource">Vantage 5.0 Data Source</property>
<property name="queryText">select * from pub.empbasic where
company = 'OCW'</property>
</oda‑data‑set>
</data‑sets>
<page‑setup>
<simple‑master‑page name="Simple MasterPage">
<page‑footer>
<text>
<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>
<property name="width">100%</property>
<property name="dataSet">Employees</property>
<column/>
<column/>
<column/>
<header>
<row>
<cell>
<label>
<text‑property
name="text">EmpID</text‑property>
</label>
</cell>
<cell>
<label>
<text‑property
name="text">Name</text‑property>
</label>
</cell>
<cell>
<label>
<text‑property
name="text">JCDept</text‑property>
</label>
</cell>
</row>
</header>
<detail>
<row>
<cell>
<data>
<expression
name="valueExpr">row["EmpID"]</expression>
</data>
</cell>
<cell>
<data>
<expression
name="valueExpr">row["Name"]</expression>
</data>
</cell>
<cell>
<data>
<expression
name="valueExpr">row["JCDept"]</expression>
</data>
</cell>
</row>
</detail>
<footer>
<row>
<cell/>
<cell/>
<cell/>
</row>
</footer>
</table>
</body>
</report>
‑‑‑
Thanks in advance,
Adam
|
|
|
|
|
|
Re: There are errors on the report page [message #95206 is a reply to message #95164] |
Tue, 29 November 2005 10:34   |
Eclipse User |
|
|
|
Sure - here is the full error:
There are errors on the report page:
- There are error(s) in Table:null
Error0 : odaconsumer.CannotOpenConnection(1 time)
detail: Cannot open the connection for the driver
(org.eclipse.birt.report.data.oda.jdbc).
Failed to get Connection
No suitable driver
Failed to get Connection
No suitable driver
No suitable driver
And here is the output from my ReportEngine_2005_11_29_10_29_51.log:
Nov 29, 2005 10:29:52 AM org.eclipse.birt.core.util.BirtTimer logTimeTaken
INFO: Engine startup takes 703 Milliseconds.
Nov 29, 2005 10:29:53 AM org.eclipse.birt.data.engine.impl.DataEngineImpl
<init>
INFO: Data Engine starts up
Nov 29, 2005 10:29:54 AM org.eclipse.birt.data.engine.impl.DataEngineImpl
<init>
INFO: Data Engine starts up
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.engine.content.impl.MasterPageConten t
initSimpleMasterPage
INFO: The property HeaderHeight is not set. Use Default 1 cm.
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.engine.content.impl.MasterPageConten t
initSimpleMasterPage
INFO: The property FooterHeight is not set. Use default 1 cm.
Nov 29, 2005 10:29:54 AM org.eclipse.birt.data.engine.odaconsumer.Driver
setLogConfiguration
INFO: ODA driver does not have valid trace logging defined in the plug-in
options or plugin.xml file.
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=sun.jdbc.odbc.JdbcOdbcDriver, connectionFactory=null
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension:
driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver
INFO: Loading JDBC driver class: com.progress.sql.jdbc.JdbcProgressDriver
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$Driv erClassLoader
refreshURLs
INFO: JDBCDriverManager: found JAR file /drivers/jdbc.jar.
URL=file:/c:/Program
Files/eclipse/plugins/org.eclipse.birt.report.viewer_1.0.1/b irt/plugins/org.eclipse.birt.report.data.oda.jdbc/drivers/jd bc.jar
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Cannot open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to get
Connection
No suitable driver
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:223)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:179)
at
org.eclipse.birt.data.engine.odaconsumer.manager.OdaConnecti on.open(OdaConnection.java:221)
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:96)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:147)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:140)
at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:137)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.ope nDataSource(PreparedQuery.java:649)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:461)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:386)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:171)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:216)
at
org.eclipse.birt.report.engine.executor.ReportItemExecutor.o penResultSet(ReportItemExecutor.java:140)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:139)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:360)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:72)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:162)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:159)
at
org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown
Source)
at
org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
Source)
at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doPost (Unknown
Source)
at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doGet( Unknown
Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:148)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:94)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:218)
... 55 more
Nov 29, 2005 10:29:54 AM
org.eclipse.birt.report.engine.data.dte.DteDataEngine execute
SEVERE: Cannot open the connection for the driver
(org.eclipse.birt.report.data.oda.jdbc).
Failed to get Connection
No suitable driver
org.eclipse.birt.data.engine.core.DataException: Cannot open the
connection for the driver (org.eclipse.birt.report.data.oda.jdbc).
Failed to get Connection
No suitable driver
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:108)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:147)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:140)
at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:137)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.ope nDataSource(PreparedQuery.java:649)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:461)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:386)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:171)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:216)
at
org.eclipse.birt.report.engine.executor.ReportItemExecutor.o penResultSet(ReportItemExecutor.java:140)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:139)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:360)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:72)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:162)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:159)
at
org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown
Source)
at
org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
Source)
at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doPost (Unknown
Source)
at org.eclipse.birt.report.viewer.servlets.ViewerServlet.doGet( Unknown
Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to
get Connection
No suitable driver
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:223)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:179)
at
org.eclipse.birt.data.engine.odaconsumer.manager.OdaConnecti on.open(OdaConnection.java:221)
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:96)
... 52 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:148)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:94)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:218)
... 55 more
Nov 29, 2005 10:29:55 AM org.eclipse.birt.data.engine.impl.DataEngineImpl
shutdown
INFO: Data engine shuts down
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04395 seconds