Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » TransientConnectionException: No current connection
TransientConnectionException: No current connection [message #56775] Tue, 02 June 2009 13:35 Go to next message
No real name is currently offline No real nameFriend
Messages: 121
Registered: July 2009
Senior Member
Hi,
I obtain a jdbc connection from the ProfileConnectionManager and use it
to successfully import 3700 rows.

Next, I go to the Data Source Explorer and click on the "Schemas" folder
of the database but the folder does not expand. In my Eclipse
development environment, I see the above-mentioned exceptionin the
console. I disconnect and connect the database. Then I can navigate into
the "Schemas" folder again and edit the desired table.

I have attached the stack trace at the very end of this message.

Did I take the one and only connection for this database? If so, can I
return it? I have tried closing the connection, nulling it but I get the
same error. I do not see a method on the ProfileConnectionManager for
returning a connection.

I am using a ganymede birt build from eclipse.org with these versions:
BIRT 2.3.2
DTP 1.6.2
Eclipse 3.4.2
EMF 2.4.2

My db driver is the Derby 10.2 Embedded JDBC driver.

Any suggestions what is wrong?

Thanks,
chris

Stack trace:

java.sql.SQLTransientConnectionException: No current connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.getMetaData(Unkno wn Source)
at
org.eclipse.datatools.connectivity.sqm.internal.core.connect ion.ConnectionAdapter.getMetaData(ConnectionAdapter.java:98)
at
org.eclipse.datatools.connectivity.sqm.loader.JDBCCatalogLoa der.createResultSet(JDBCCatalogLoader.java:175)
at
org.eclipse.datatools.connectivity.sqm.loader.JDBCCatalogLoa der.loadCatalogs(JDBCCatalogLoader.java:108)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDat abase.loadCatalogs(JDBCDatabase.java:101)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDat abase.getCatalogs(JDBCDatabase.java:63)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displayDatabaseChildren(ServerExplorerVNodeC ontentProviderNav.java:366)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 16)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 39)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:85)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.load(ServerExplorerContentProviderNav.java:153)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.loading.LoadingJob.run(LoadingJob.java:43)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: No current connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
Source)
... 18 more
Re: TransientConnectionException: No current connection [message #56802 is a reply to message #56775] Tue, 02 June 2009 17:45 Go to previous message
Eclipse UserFriend
Originally posted by: brianf.sybase.com

Hi Chris...

This definitely seems like a bug to me.

Can you write up a bugzilla with what you have here and we can take a look
at it for 1.7.1?

--Fitz

"Chris Giblin" <cgi@zurich.ibm.com> wrote in message
news:h039rh$ubo$1@build.eclipse.org...
> Hi,
> I obtain a jdbc connection from the ProfileConnectionManager and use it to
> successfully import 3700 rows.
>
> Next, I go to the Data Source Explorer and click on the "Schemas" folder
> of the database but the folder does not expand. In my Eclipse development
> environment, I see the above-mentioned exceptionin the console. I
> disconnect and connect the database. Then I can navigate into the
> "Schemas" folder again and edit the desired table.
>
> I have attached the stack trace at the very end of this message.
>
> Did I take the one and only connection for this database? If so, can I
> return it? I have tried closing the connection, nulling it but I get the
> same error. I do not see a method on the ProfileConnectionManager for
> returning a connection.
>
> I am using a ganymede birt build from eclipse.org with these versions:
> BIRT 2.3.2
> DTP 1.6.2
> Eclipse 3.4.2
> EMF 2.4.2
>
> My db driver is the Derby 10.2 Embedded JDBC driver.
>
> Any suggestions what is wrong?
>
> Thanks,
> chris
>
> Stack trace:
>
> java.sql.SQLTransientConnectionException: No current connection.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.getMetaData(Unkno wn Source)
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connect ion.ConnectionAdapter.getMetaData(ConnectionAdapter.java:98)
> at
> org.eclipse.datatools.connectivity.sqm.loader.JDBCCatalogLoa der.createResultSet(JDBCCatalogLoader.java:175)
> at
> org.eclipse.datatools.connectivity.sqm.loader.JDBCCatalogLoa der.loadCatalogs(JDBCCatalogLoader.java:108)
> at
> org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDat abase.loadCatalogs(JDBCDatabase.java:101)
> at
> org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDat abase.getCatalogs(JDBCDatabase.java:63)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displayDatabaseChildren(ServerExplorerVNodeC ontentProviderNav.java:366)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 16)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 39)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:85)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.load(ServerExplorerContentProviderNav.java:153)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.loading.LoadingJob.run(LoadingJob.java:43)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.sql.SQLException: No current connection.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 18 more
>
Re: TransientConnectionException: No current connection [message #595909 is a reply to message #56775] Tue, 02 June 2009 17:45 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 500
Registered: July 2009
Senior Member
Hi Chris...

This definitely seems like a bug to me.

Can you write up a bugzilla with what you have here and we can take a look
at it for 1.7.1?

--Fitz

"Chris Giblin" <cgi@zurich.ibm.com> wrote in message
news:h039rh$ubo$1@build.eclipse.org...
> Hi,
> I obtain a jdbc connection from the ProfileConnectionManager and use it to
> successfully import 3700 rows.
>
> Next, I go to the Data Source Explorer and click on the "Schemas" folder
> of the database but the folder does not expand. In my Eclipse development
> environment, I see the above-mentioned exceptionin the console. I
> disconnect and connect the database. Then I can navigate into the
> "Schemas" folder again and edit the desired table.
>
> I have attached the stack trace at the very end of this message.
>
> Did I take the one and only connection for this database? If so, can I
> return it? I have tried closing the connection, nulling it but I get the
> same error. I do not see a method on the ProfileConnectionManager for
> returning a connection.
>
> I am using a ganymede birt build from eclipse.org with these versions:
> BIRT 2.3.2
> DTP 1.6.2
> Eclipse 3.4.2
> EMF 2.4.2
>
> My db driver is the Derby 10.2 Embedded JDBC driver.
>
> Any suggestions what is wrong?
>
> Thanks,
> chris
>
> Stack trace:
>
> java.sql.SQLTransientConnectionException: No current connection.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLExcep tion(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unk nown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.getMetaData(Unkno wn Source)
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connect ion.ConnectionAdapter.getMetaData(ConnectionAdapter.java:98)
> at
> org.eclipse.datatools.connectivity.sqm.loader.JDBCCatalogLoa der.createResultSet(JDBCCatalogLoader.java:175)
> at
> org.eclipse.datatools.connectivity.sqm.loader.JDBCCatalogLoa der.loadCatalogs(JDBCCatalogLoader.java:108)
> at
> org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDat abase.loadCatalogs(JDBCDatabase.java:101)
> at
> org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCDat abase.getCatalogs(JDBCDatabase.java:63)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displayDatabaseChildren(ServerExplorerVNodeC ontentProviderNav.java:366)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 16)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 39)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:85)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.load(ServerExplorerContentProviderNav.java:153)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.loading.LoadingJob.run(LoadingJob.java:43)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.sql.SQLException: No current connection.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLExcepti on(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsFor TransportAcrossDRDA(Unknown
> Source)
> ... 18 more
>
Previous Topic:TransientConnectionException: No current connection
Next Topic:SQLModel doesn't use containment references ?
Goto Forum:
  


Current Time: Thu Apr 25 22:18:09 GMT 2024

Powered by FUDForum. Page generated in 0.03317 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top