Re: Are connectEventListeners supported with 10.3? [DERBY-3172]

[Stanley Bradbury <St...@gmail.com>]

FYI - opened JIRA issue *DERBY-3172 
<https://issues.apache.org/jira/browse/DERBY-3172> - 
connectionEventListeners* are in the test harness so I assume they are 
supported and should be working.  Problem also appears to happen when 
using the EmbeddedDatasource

Stanley Bradbury wrote:
> Is it true that the javax.sql.ConnectionEventListener is not supported 
> by the ClientConnectionPoolDatasource?  The attached program does not 
> display the event messages when the network server is shutdown during 
> the application run.  To view the problem:
> 1) start network server (I specified -noSecurityManager to eliminate 
> that added complexity)
> 2) run the program AND
>    when the following message is displayed, stop the Network Server 
> within 15 seconds:
>         * now kill the NS while I sleep for 15 secs*
> The program will continue with the message:  now try to use the 
> connection after you killed the nS
> Only an exception is displayed:
> Exception in thread "main" java.sql.SQLException: A network protocol 
> error was encountered and the connection has been terminated: the 
> requested command encountered an unarchitected and implementation
> -specific condition for which there was no architected message
>        at 
> org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>        at 
> org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
>        at 
> org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
>        at 
> org.apache.derby.client.am.LogicalConnection.prepareStatement(Unknown 
> Source)
>        at DerbyNotification.main(DerbyNotification.java:61)
>
> Derby-941 lists the specifcation for both ConnectionEventListener  and 
> StatementEventListener but it appears that only StatementEventListener 
> was implemented.  If this is true are there plans to support 
> ConnectionEventListeners?
>
> I hope I have just made a dumb error setting this up and someone can 
> correct me.  Any assistance will be greatly appreciated.
>
> Thank you,  Stan
>
>