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 previous 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

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:Grouping multiple rows from result into single cell
Next Topic:maximo+birt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 11:57:11 EDT 2013

Powered by FUDForum. Page generated in 0.01741 seconds