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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2011/03/02 18:23:36 UTC

[jira] Updated: (DERBY-5085) After specifying deregister=false on the engine shutdown URL, Derby forgets that the default behavior is deregister=true

     [ https://issues.apache.org/jira/browse/DERBY-5085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-5085:
---------------------------------

    Attachment: y.java

Attaching y.java, a repro for this problem. Here is the output from this program:

java y true
Connection is a org.apache.derby.impl.jdbc.EmbedConnection40
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true;deregister=false
Connection is a org.apache.derby.impl.jdbc.EmbedConnection40
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true;deregister=true
As expected, could not get a connection after an ordinary orderly shutdown.
Connection is a org.apache.derby.impl.jdbc.EmbedConnection40
Success!

java y false
Connection is a org.apache.derby.impl.jdbc.EmbedConnection40
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true;deregister=false
Connection is a org.apache.derby.impl.jdbc.EmbedConnection40
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true
Connection is a org.apache.derby.impl.jdbc.EmbedConnection40
Oops! Did not expect to be able to get a connection!

The above tests were run on Java 6. Note that you can also run this test on JDK 1.4 and see the same behavior there:

java -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver y true
Connection is a org.apache.derby.impl.jdbc.EmbedConnection30
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true;deregister=false
Connection is a org.apache.derby.impl.jdbc.EmbedConnection30
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true;deregister=true
As expected, could not get a connection after an ordinary orderly shutdown.
Connection is a org.apache.derby.impl.jdbc.EmbedConnection30
Success!

java -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver y false
Connection is a org.apache.derby.impl.jdbc.EmbedConnection30
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true;deregister=false
Connection is a org.apache.derby.impl.jdbc.EmbedConnection30
Saw SQLState XJ015 after trying to shutdown with this url: jdbc:derby:;shutdown=true
Connection is a org.apache.derby.impl.jdbc.EmbedConnection30
Oops! Did not expect to be able to get a connection!


> After specifying deregister=false on the engine shutdown URL, Derby forgets that the default behavior is deregister=true
> ------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5085
>                 URL: https://issues.apache.org/jira/browse/DERBY-5085
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.8.0.0
>            Reporter: Rick Hillegas
>         Attachments: y.java
>
>
> If you shutdown the engine specifying deregister=false, then get a new connection, then shutdown the engine again without specifying any value for the deregister attribute, Derby acts as though you specified deregister=false again. I will attach a test program which shows this problem.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira