You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/09/14 01:59:32 UTC

[jira] Created: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
----------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-3074
                 URL: https://issues.apache.org/jira/browse/DERBY-3074
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.3.1.4, 10.2.2.0, 10.4.0.0
            Reporter: Kathey Marsden


SQLNonTransientConnectionException is described as:

 The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 

Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
10.4.0.0 alpha - (1)
Apache Derby
got connection now shutdown
08006:Database 'sampl127' shutdown.
Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
        at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
        at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
        at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
5)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
        ... 13 more
Caused by: ERROR 08006: Database 'sampl127' shutdown.
        at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
        ... 8 more
[C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3074:
----------------------------------

    Attachment: derby-3074_3075_stat.txt
                derby-3074_3075_diff.txt

Attached is a patch for this issue and also DERBY-3075. I change SQLExceptionFactory40 for client and embedded to throw SQLNonTransientConnectionException instead of SQLTransientConnectionException for '08' exceptions. Added test for embedded database shutdown and client connect to server that is not up to ensure that they throw SQLNonTransientConnectionException.

I am running tests now.

> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>         Attachments: derby-3074_3075_diff.txt, derby-3074_3075_stat.txt, DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Resolved: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden resolved DERBY-3074.
-----------------------------------

       Resolution: Fixed
    Fix Version/s: 10.4.0.0
                   10.3.1.5

checked fix into trunk and 10.3

> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>             Fix For: 10.3.1.5, 10.4.0.0
>
>         Attachments: derby-3074_3075_diff.txt, derby-3074_3075_stat.txt, DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527407 ] 

Knut Anders Hatlen commented on DERBY-3074:
-------------------------------------------

SQLExceptionFactory40 (both the embedded version and the client version) has this comment:

            //none of the sqlstate supported by derby belongs to
            //NonTransientConnectionException

My first though when reading this, is that it should have been the other way around - all 08xxx states in Derby are non-transient (that is, a retry won't succeed unless the cause of the failure is corrected), but I haven't checked that it is the case.

> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>         Attachments: DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Updated: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-3074:
----------------------------------

    Attachment: DerbyEmbeddedException.java

repro to show that Transient instead of NonTransient exception is thrown.


> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>         Attachments: DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Assigned: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden reassigned DERBY-3074:
-------------------------------------

    Assignee: Kathey Marsden

> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>         Attachments: DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527510 ] 

Daniel John Debrunner commented on DERBY-3074:
----------------------------------------------

When I looked at the same code last night that was my guess as well, someone just got mixed up between Transient & Not Transient.

> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>         Attachments: DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527658 ] 

Kathey Marsden commented on DERBY-3074:
---------------------------------------

Tests passed except for ErrorCodeTest which failed with the tinderbox run.  Please review.

Thanks

Kathey


> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>         Attachments: derby-3074_3075_diff.txt, derby-3074_3075_stat.txt, DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Issue Comment Edited: (DERBY-3074) Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-3074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527407 ] 

knutanders edited comment on DERBY-3074 at 9/14/07 1:38 AM:
--------------------------------------------------------------------

SQLExceptionFactory40 (both the embedded version and the client version) has this comment:

            //none of the sqlstate supported by derby belongs to
            //NonTransientConnectionException

My first thought when reading this, is that it should have been the other way around - all 08xxx states in Derby are non-transient (that is, a retry won't succeed unless the cause of the failure is corrected), but I haven't checked that it is the case.

      was (Author: knutanders):
    SQLExceptionFactory40 (both the embedded version and the client version) has this comment:

            //none of the sqlstate supported by derby belongs to
            //NonTransientConnectionException

My first though when reading this, is that it should have been the other way around - all 08xxx states in Derby are non-transient (that is, a retry won't succeed unless the cause of the failure is corrected), but I haven't checked that it is the case.
  
> Database shutdown exception 08006 throws SQLTransientConnectionException instead of SQLNonTransientConnectionException
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3074
>                 URL: https://issues.apache.org/jira/browse/DERBY-3074
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Kathey Marsden
>         Attachments: DerbyEmbeddedException.java
>
>
> SQLNonTransientConnectionException is described as:
>  The subclass of SQLException thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.  See repro DerbyEmbeddedException.java 
> Yet, database shutdown which is SQLState 8006 throws an SQLTransientConnectionSQLException
> 10.4.0.0 alpha - (1)
> Apache Derby
> got connection now shutdown
> 08006:Database 'sampl127' shutdown.
> Exception in thread "main" java.sql.SQLTransientConnectionException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1574)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:385)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:54)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:68)
>         at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:211)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:119)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>         at DerbyEmbeddedException.main(DerbyEmbeddedException.java:29)
> Caused by: java.sql.SQLException: Database 'sampl127' shutdown.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:13
> 5)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 13 more
> Caused by: ERROR 08006: Database 'sampl127' shutdown.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.shutdownDatabaseException(TransactionResourceImpl.java:224
> )
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:355)
>         ... 8 more
> [C:/kmarsden/repro/NonTransientException] java or

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.