db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajesh Kartha (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2375) jdbcapi/users2.sql and jdbcapi/secureUsers.sql fails on IBM weme 6.1
Date Sat, 24 Feb 2007 00:55:05 GMT
jdbcapi/users2.sql and jdbcapi/secureUsers.sql fails on IBM weme 6.1
--------------------------------------------------------------------

                 Key: DERBY-2375
                 URL: https://issues.apache.org/jira/browse/DERBY-2375
             Project: Derby
          Issue Type: Bug
          Components: Test
    Affects Versions: 10.3.0.0
         Environment: Windows
            Reporter: Rajesh Kartha
             Fix For: 10.3.0.0


With :  10.3.0.0 alpha - (510766) I noticed the jdbcapi/users2.sql and jdbcapi/secureUsers.sql
fails on IBM weme 6.1. The following are the diffs:

*** Start: secureUsers jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:21:01
***
204a205,221
> ERROR 08006: Database 'derbySchemeDB' shutdown.
> ij> show connections;
> No connections available.
> ij> -- Database shutdown - check user - should succeed
> connect 'guestSchemeDB;user=kreg;password=IwasBornReady;shutdown=true';
> ERROR 08006: Database 'guestSchemeDB' shutdown.
> ij> -- Database shutdown - authenticated, so must use owner
> connect 'wombat;user=system;password=manager;shutdown=true';
> ERROR 08006: Database 'wombat' shutdown.
> ij> connect 'derbySchemeDB;user=system;password=manager;shutdown=true';
> ERROR XJ004: Database 'derbySchemeDB' not found.
> ij> connect 'simpleSchemeDB;user=system;password=manager;shutdown=true';
> ERROR 08006: Database 'simpleSchemeDB' shutdown.
> ij> show connections;
> No connections available.
> ij> -- Derby system shutdown - check user - should fail
> connect ';user=jamie;password=LetMeIn;shutdown=true';
206,222d222
< ij> show connections;
< No connections available.
< ij> -- Database shutdown - check user - should succeed
< connect 'guestSchemeDB;user=kreg;password=IwasBornReady;shutdown=true';
< ERROR 08006: Database 'guestSchemeDB' shutdown.
< ij> -- Database shutdown - authenticated, so must use owner
< connect 'wombat;user=system;password=manager;shutdown=true';
< ERROR 08006: Database 'wombat' shutdown.
< ij> connect 'derbySchemeDB;user=system;password=manager;shutdown=true';
< ERROR 08006: Database 'derbySchemeDB' shutdown.
< ij> connect 'simpleSchemeDB;user=system;password=manager;shutdown=true';
< ERROR 08006: Database 'simpleSchemeDB' shutdown.
< ij> show connections;
< No connections available.
< ij> -- Derby system shutdown - check user - should fail
< connect ';user=jamie;password=LetMeIn;shutdown=true';
< ERROR 08004: Connection refused : Invalid authentication.
Test Failed.
*** End:   secureUsers jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:21:28
***

*** Start: users2 jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:20:46
***
205a206
> ij> connect 'wombat;user=badUser1;password=YeeHa!';
207,208d207
< ij> connect 'wombat;user=badUser1;password=YeeHa!';
< ERROR 08004: Connection refused : Invalid authentication.
223 del
< ij> -- users only defined at system level; not allowed:
223a222
> ij(CONNECTION1)> -- users only defined at system level; not allowed:
226 del
< ij> connect 'wombat;user=mickey;password=mouse';
226a225
> ij(CONNECTION1)> connect 'wombat;user=mickey;password=mouse';
227a227,245
> ij(CONNECTION1)> show connections;
> CONNECTION0
> CONNECTION1*
> * = current connection
> ij(CONNECTION1)> connect 'wombat;user=francois;password=paceesalute';
> ij(CONNECTION2)> connect 'myDB;user=jerry;password=SacreBleu';
> ij(CONNECTION3)> -- Database shutdown - check user - should fail
> connect 'myDB;shutdown=true';
> ERROR 08006: Database 'myDB' shutdown.
> ij(CONNECTION3)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
> ERROR XJ004: Database 'myDB' not found.
> ij(CONNECTION3)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
> ERROR 08004: Connection refused : Invalid authentication.
> ij(CONNECTION3)> show connections;
> CONNECTION0
> CONNECTION1
> CONNECTION2
> No current connection
> ij> disconnect all;
229,246d246
< CONNECTION0*
< * = current connection
< ij> connect 'wombat;user=francois;password=paceesalute';
< ij(CONNECTION1)> connect 'myDB;user=jerry;password=SacreBleu';
< ij(CONNECTION2)> -- Database shutdown - check user - should fail
< connect 'myDB;shutdown=true';
< ERROR 08004: Connection refused : Invalid authentication.
< ij(CONNECTION2)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
< ERROR 08004: Connection refused : Invalid authentication.
< ij(CONNECTION2)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
< ERROR 08004: Connection refused : Invalid authentication.
< ij(CONNECTION2)> show connections;
< CONNECTION0
< CONNECTION1
< CONNECTION2*
< * = current connection
< ij(CONNECTION2)> disconnect all;
< ij> show connections;
258 del
< ERROR 2850H: User 'JERRY' cannot shut down database 'myDB'. Only the database owner can
perform this operation.
258a258
> ERROR XJ004: Database 'myDB' not found.
261 del
< ERROR 08006: Database 'myDB' shutdown.
261a261
> ERROR XJ004: Database 'myDB' not found.
Test Failed.
*** End:   users2 jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:21:00
***

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


Mime
View raw message