Eclipse Community Forums: BIRT » Cannot close connection

Home » Archived » BIRT » Cannot close connection

Cannot close connection [message #125340]

Tue, 07 February 2006 07:33

Eclipse User

Originally posted by: jan.tanis.coas.com

Hi,

I get the following in my stacktrace after generating a report:

7-feb-2006 13:25:36 org.eclipse.birt.core.util.BirtTimer logTimeTaken
INFO: Engine startup takes 0 Milliseconds.
Parameter format not found in the report.
7-feb-2006 13:25:36 org.eclipse.birt.data.engine.impl.DataEngineImpl <init>
INFO: Data Engine starts up
7-feb-2006 13:25:36 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.
7-feb-2006 13:25:38
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: memoryCacheRowCount is 20000
7-feb-2006 13:25:38
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: MemoryCache is used
7-feb-2006 13:25:38
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: Time consumed by cache is: 0 second
7-feb-2006 13:25:38
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: memoryCacheRowCount is 20000
7-feb-2006 13:25:38
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: MemoryCache is used
7-feb-2006 13:25:38
org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
INFO: Time consumed by cache is: 0 second
7-feb-2006 13:25:40 org.eclipse.birt.data.engine.odaconsumer.Connection
close
SEVERE: Cannot close connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to close the
connection.
I/O-uitzondering: Socket closed
at
org.eclipse.birt.report.data.oda.jdbc.Connection.close(Conne ction.java:286)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.close(OdaConnection.java:327)
at
org.eclipse.birt.data.engine.odaconsumer.Connection.close(Co nnection.java:177)
at
org.eclipse.birt.data.engine.executor.DataSource.close(DataS ource.java:263)
at
org.eclipse.birt.data.engine.executor.DataSource.finalize(Da taSource.java:288)
at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
at java.lang.ref.Finalizer.runFinalizer(Unknown Source)
at java.lang.ref.Finalizer.access$100(Unknown Source)
at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
Caused by: java.sql.SQLException: I/O-uitzondering: Socket closed
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 333)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.j ava:1442)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.close(Conne ction.java:282)
... 8 more

The reports are fine, but I like a clean console;)
Is this a bug or something?

Regards, Jan.

Re: Cannot close connection [message #126552 is a reply to message #125340]

Wed, 08 February 2006 19:19

Eclipse User

It looks like BIRT may be trying to close the jdbc connection twice. It
would be a bug if that's the case, albeit a minor one since it should affect
your report execution.
Can you file a bugzilla report and attach your report design?

thanks,

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"Jan Tanis" <jan.tanis@coas.com> wrote in message
news:dsa43c$17d$1@utils.eclipse.org...
> Hi,
>
> I get the following in my stacktrace after generating a report:
>
> 7-feb-2006 13:25:36 org.eclipse.birt.core.util.BirtTimer logTimeTaken
> INFO: Engine startup takes 0 Milliseconds.
> Parameter format not found in the report.
> 7-feb-2006 13:25:36 org.eclipse.birt.data.engine.impl.DataEngineImpl
<init>
> INFO: Data Engine starts up
> 7-feb-2006 13:25:36 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.
> 7-feb-2006 13:25:38
> org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
> INFO: memoryCacheRowCount is 20000
> 7-feb-2006 13:25:38
> org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
> INFO: MemoryCache is used
> 7-feb-2006 13:25:38
> org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
> INFO: Time consumed by cache is: 0 second
> 7-feb-2006 13:25:38
> org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
> INFO: memoryCacheRowCount is 20000
> 7-feb-2006 13:25:38
> org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
> INFO: MemoryCache is used
> 7-feb-2006 13:25:38
> org.eclipse.birt.data.engine.executor.cache.SmartCache populateData
> INFO: Time consumed by cache is: 0 second
> 7-feb-2006 13:25:40 org.eclipse.birt.data.engine.odaconsumer.Connection
> close
> SEVERE: Cannot close connection.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to close the
> connection.
> I/O-uitzondering: Socket closed
> at
>
org.eclipse.birt.report.data.oda.jdbc.Connection.close(Conne ction.java:286)
> at
>
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.close(O
daConnection.java:327)
> at
>
org.eclipse.birt.data.engine.odaconsumer.Connection.close(Co nnection.java:17
7)
> at
>
org.eclipse.birt.data.engine.executor.DataSource.close(DataS ource.java:263)
> at
>
org.eclipse.birt.data.engine.executor.DataSource.finalize(Da taSource.java:28
8)
> at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
> at java.lang.ref.Finalizer.runFinalizer(Unknown Source)
> at java.lang.ref.Finalizer.access$100(Unknown Source)
> at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
> Caused by: java.sql.SQLException: I/O-uitzondering: Socket closed
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 179)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 333)
> at oracle.jdbc.driver.OracleConnection.close(OracleConnection.j ava:1442)
> at
>
org.eclipse.birt.report.data.oda.jdbc.Connection.close(Conne ction.java:282)
> ... 8 more
>
>
> The reports are fine, but I like a clean console;)
> Is this a bug or something?
>
> Regards, Jan.

Re: Cannot close connection [message #126860 is a reply to message #126552]

Thu, 09 February 2006 04:20

Eclipse User

Originally posted by: jan.tanis.coas.com

Have allready filed it without my report design.

I will attach it as you wish.

Gary Xue wrote:
> It looks like BIRT may be trying to close the jdbc connection twice. It
> would be a bug if that's the case, albeit a minor one since it should affect
> your report execution.
> Can you file a bugzilla report and attach your report design?
>
> thanks,
>

Previous Topic:	Can i use birt in my project?
Next Topic:	how to specify bar width (riser)

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Oct 17 12:41:56 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter