[birt-dev] Failed to start database: while Previewing report design

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-dev] Failed to start database: while Previewing report design
From: "Rajesh Gheware" <rajesh.gheware@xxxxxxxxx>
Date: Wed, 13 Jul 2005 20:20:42 +0400
Delivered-to: birt-dev@xxxxxxxxxxx
List-archive: <http://eclipse.org/pipermail/birt-dev>
List-help: <mailto:birt-dev-request@eclipse.org?subject=help>
List-subscribe: <https://dev.eclipse.org/mailman/listinfo/birt-dev>, <mailto:birt-dev-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://dev.eclipse.org/mailman/listinfo/birt-dev>, <mailto:birt-dev-request@eclipse.org?subject=unsubscribe>
Thread-index: AcWHxtBgJoxYks8rQO2m8o8YKlE2Bw==
Hello All,

 

I did the Data Set operation, tested the connection also.  It works fine.

 

While editing Data Source, I did preview the results to make sure that data
is fetched from the database and it works great.

 

But when I try preview the reportdesign, it throws error saying:

 

Error0 : odaconsumer.CannotOpenConnection(1 time)


detail: Cannot open the connection for the driver
(org.eclipse.birt.report.data.oda.jdbc).


Failed to get Connection


Failed to start database
'D:\rajesh.gheware\projects\automatedbuild\build\I.TestBuild\Arena\db\networ
kManager', see the next exception for details.


Failed to get Connection


Failed to start database
'D:\rajesh.gheware\projects\automatedbuild\build\I.TestBuild\Arena\db\networ
kManager', see the next exception for details.


Failed to start database
'D:\rajesh.gheware\projects\automatedbuild\build\I.TestBuild\Arena\db\networ
kManager', see the next exception for details.

 

 

 

When I try to peak into
.\eclipse\plugins\org.eclipse.birt.report.viewer_1.0.0\birt\logs directory,
I see the following:

Jul 13, 2005 8:00:00 PM org.eclipse.birt.core.util.BirtTimer logTimeTaken

INFO: Engine startup takes 566 Milliseconds.

Jul 13, 2005 8:00:01 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
<init>

INFO: Data Engine starts up

Jul 13, 2005 8:00:01 PM org.eclipse.birt.data.engine.impl.DataEngineImpl
<init>

INFO: Data Engine starts up

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.engine.content.impl.MasterPageContent
initSimpleMasterPage

INFO: The property HeaderHeight is not set. Use Default 1 cm.

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.engine.content.impl.MasterPageContent
initSimpleMasterPage

INFO: The property FooterHeight is not set. Use default 1 cm.

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions

INFO: Found JDBC driverinfo extension:
driverClass=sun.jdbc.odbc.JdbcOdbcDriver, connectionFactory=null

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadDriverExtensions

INFO: Found JDBC driverinfo extension:
driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver

INFO: Loading JDBC driver class: org.apache.derby.jdbc.EmbeddedDriver

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadAndRegisterDriver

INFO: Loaded JDBC driver class in class path:
org.apache.derby.jdbc.EmbeddedDriver

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection

SEVERE: Cannot open connection.

org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to get
Connection

Failed to start database
'D:\rajesh.gheware\projects\automatedbuild\build\I.TestBuild\Arena\db\networ
kManager', see the next exception for details.

            at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.jav
a:223)

            at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:179)

            at
org.eclipse.birt.data.engine.odaconsumer.manager.OdaConnection.open(OdaConne
ction.java:221)

            at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(Co
nnectionManager.java:89)

            at
org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.ja
va:147)

            at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:140)

            at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSo
urceRuntime.java:137)

            at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.openDataSource(Prep
aredQuery.java:642)

            at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.prepareExecution(Pr
eparedQuery.java:454)

            at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.access$000(Prepared
Query.java:379)

            at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java
:171)

            at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDa
taSourceQuery.java:137)

            at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execute(DteDataEngine.
java:216)

            at
org.eclipse.birt.report.engine.executor.ReportItemExecutor.openResultSet(Rep
ortItemExecutor.java:140)

            at
org.eclipse.birt.report.engine.executor.ListItemExecutor.execute(ListItemExe
cutor.java:79)

            at
org.eclipse.birt.report.engine.executor.ReportExecutorVisitor.visitListItem(
ReportExecutorVisitor.java:256)

            at
org.eclipse.birt.report.engine.ir.ListItemDesign.accept(ListItemDesign.java:
151)

            at
org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecuto
r.java:163)

            at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTas
k.java:152)

            at
org.eclipse.birt.report.viewer.aggregation.layout.EngineFragment.doService(U
nknown Source)

            at
org.eclipse.birt.report.viewer.aggregation.BaseFragment.service(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.internalDoFilter(Application
FilterChain.java:247)

            at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)

            at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

            at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)

            at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

            at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

            at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorRepor
tValve.java:153)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)

            at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)

            at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:700)

            at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)

            at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:683)

            at java.lang.Thread.run(Unknown Source)

Caused by: SQL Exception: Failed to start database
'D:\rajesh.gheware\projects\automatedbuild\build\I.TestBuild\Arena\db\networ
kManager', see the next exception for details.

            at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)

            at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)

            at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)

            at
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.j
ava)

            at
org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java
)

            at
org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)

            at
org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)

            at
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)

            at
org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)

            at org.apache.derby.jdbc.Driver169.connect(Driver169.java)

            at java.sql.DriverManager.getConnection(Unknown Source)

            at java.sql.DriverManager.getConnection(Unknown Source)

            at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriver
Manager.java:146)

            at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDr
iverManager.java:92)

            at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.jav
a:218)

            ... 55 more

Jul 13, 2005 8:00:01 PM
org.eclipse.birt.report.engine.data.dte.DteDataEngine execute

SEVERE: Cannot open the connection for the driver
(org.eclipse.birt.report.data.oda.jdbc).

 

Any ideas, what could be wrong..?

 

By the way, I am using Eclipse 3.1, BIRT 1.0.0 and Hibernate database..

 

 

Thanks in advance.

 

Best Regards,
Rajesh V. Gheware
Java Developer Lead
Sphere Networks

P.O.Box 29500 - Dubai, U.A.E.
Tel: +971-043626206
Fax: +971-043626226
URL http://thecoregroup.ae/sphere.htm
Prev by Date: RE: [birt-dev] How to create a datasource - Thanks
Next by Date: [birt-dev] FW: API Change Request for IFileLocator
Previous by thread: [birt-dev] RE: birt-dev Digest, Vol 4, Issue 4
Next by thread: [birt-dev] FW: API Change Request for IFileLocator
Index(es):
- Date
- Thread
Breadcrumbs
