db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: [jira] Created: (DERBY-2375) jdbcapi/users2.sql and jdbcapi/secureUsers.sql fails on IBM weme 6.1
Date Sat, 24 Feb 2007 03:40:31 GMT
"Rajesh Kartha (JIRA)" <jira@apache.org> writes:

This errors probably stem from the changes made for
DERBY-2264-{1,2}. I did no testing on the IBM weme 6.1 platform. Let
me know if you have any issues updating the canons.
I did update the j9_foundation canons, though (no testing).
 
Dag

> 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.
>

-- 
Dag H. Wanvik
Sun Microsystems, Database Technology Group (DBTG)
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101

Mime
View raw message