Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Birt designer throws 'Connection is closed' error while previewing the report
Birt designer throws 'Connection is closed' error while previewing the report [message #919059] Fri, 21 September 2012 12:39 Go to next message
coolguy Missing name is currently offline coolguy Missing name
Messages: 6
Registered: July 2009
Junior Member
I'm trying to design a report using BIRT. I used the all-in-one eclipse designer 2.3.1 using jdk1.6. The database used is a SQL Server 2008. However, it gives me a connection closed error while trying to 'Preview Results' for data set and while previewing the report. The driver used is sqljdbc4.jar. Any help is appreciated.

Exception while previewing the dataset:-

Quote:
A BIRT exception occurred. Plug-in Provider:Eclipse.org Plug-in Name:BIRT Data Engine Plug-in ID:org.eclipse.birt.data
Version:2.3.1.v20080829 Error Code:odaconsumer.CannotGetResultSetMetaData Error Message:Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: The connection is closed.


Exception while previewing the report:-

Quote:
exception.error ( 1 time(s) ) detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:Cannot get the result set metadata.SQL statement does not return a ResultSet object.SQL error #1: The connection is closed. at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1109) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1073) ....... Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.SQL error #1: The connection is closed. ; com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:445) at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingDefaultPolicy(Statement.java:352) at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:294) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:388) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:356) at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:365) ... 74 more

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388) at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(SQLServerStatement.java:978) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:284) at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:441) ... 79 more

Re: Birt designer throws 'Connection is closed' error while previewing the report [message #919091 is a reply to message #919059] Fri, 21 September 2012 13:17 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Any chance you can try a newer version of BIRT. Have you tried different queries or does this matter?

Jason


Jason Weathersby

BIRT Exchange
Re: Birt designer throws 'Connection is closed' error while previewing the report [message #919100 is a reply to message #919091] Fri, 21 September 2012 13:24 Go to previous messageGo to next message
coolguy Missing name is currently offline coolguy Missing name
Messages: 6
Registered: July 2009
Junior Member
I've tried different queries and it gives the same error.

I tried this on newer revisions (eclipse-reporting-juno-win32, birt-report-designer-all-in-one-3_7_2) and it gives errors. The eclipse-reporting-juno-win32 gives the Connection is closed error.(stack trace given below)

Quote:
org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:135)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:97)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:49)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:69)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:336)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: MyDataset
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[
... query...omitted..

]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1:The connection is closed.
;
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:166)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:126)
... 5 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: MyDataset
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[
... query...omitted..

]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1:The connection is closed.
;
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:345)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
... 7 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[
... query...omitted..
]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1:The connection is closed.
;
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:298)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:197)
at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:302)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:281)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
... 12 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1:The connection is closed.
;
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at org.eclipse.birt.report.data.oda.jdbc.Statement.prepare(Statement.java:135)
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.prepare(BidiStatement.java:52)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doPrepare(OdaQuery.java:229)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.prepare(OdaQuery.java:186)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:290)
... 17 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2166)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:1853)
at org.eclipse.birt.report.data.oda.jdbc.Statement.prepare(Statement.java:131)
... 21 more

[Updated on: Fri, 21 September 2012 13:25]

Report message to a moderator

Re: Birt designer throws 'Connection is closed' error while previewing the report [message #919101 is a reply to message #919100] Fri, 21 September 2012 13:27 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I assume you can not post the report? Can you email it to me at jasonweathersby at windstream dot net?

Jason


Jason Weathersby

BIRT Exchange
Re: Birt designer throws 'Connection is closed' error while previewing the report [message #919224 is a reply to message #919101] Fri, 21 September 2012 16:15 Go to previous message
coolguy Missing name is currently offline coolguy Missing name
Messages: 6
Registered: July 2009
Junior Member
I am afraid whether I can send it. The report works on another environment. I will compare the environments to see what I'm my missing. Thanks for your help, Jason. Appreciate it.
Previous Topic:Grouping multiple rows from result into single cell
Next Topic:maximo+birt
Goto Forum:
  


Current Time: Sun Apr 20 02:51:42 EDT 2014

Powered by FUDForum. Page generated in 0.01825 seconds