Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Date: Tue, 05 Jun 2007 20:05:05 +0200
From: Dag.Wanvik@Sun.COM (Dag H. Wanvik)
Subject: Re: Can't upgrade from 10.1 to 10.3
In-reply-to: <4664D52D.9020909@gmail.com>
Sender: Dag.Wanvik@Sun.COM
To: derby-dev@db.apache.org
Message-id: <x1ox4plmffam.fsf@sun.com>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
References: <4660BEFC.9090606@gmail.com> <x1oxy7iztyb7.fsf@sun.com>
 <4664D52D.9020909@gmail.com>
User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.0.50 (usg-unix-v)


Thanks for trying this out, Stan! I really appreciate it.

Stanley Bradbury <Stan.Bradbury@gmail.com> writes:

> ========   SNIP   =======
>
> Making APP a valid user did not work for me either.  Prior to version
> 10.2 I am not aware of there being a DBO but I understand the system
> tables were owned by DBA so I created such a user and it appears to
> have worked but since there is no schema called DBA any SQL causes
> errors.  Is there anyway for an end-user to tell whom the code expects
> the DBO to be? 

Not sure, I guess

select AUTHORIZATIONID from sys.sysschemas where schemaname = 'SYS';

would not be permissible unless necessary permissions were granted? 

>
> C:\Stan\L3\10.3\DBO>java org.apache.derby.tools.ij
> ij version 10.3
> ij> connect 'jdbc:derby:noUserDB;upgrade=true;user=DBA;password=DBA';
> ij> select columnnumber, columnname from sys.syscolumns where
> referenceid in (select tableid from sys.systables where ta
> blename = 'SYSTABLES') order by columnnumber;
> ERROR 42Y07: Schema 'DBA' does not exist

I tried to recreate this, but I could not. Can you show me exactly how
you did this?  Please also see my reply to Dan's mail; I did some more
experiments.

Thanks,
Dag


> ij> set schema app;
> 0 rows inserted/updated/deleted
> ij> select columnnumber, columnname from sys.syscolumns where
> referenceid in (select tableid from sys.systables where tablename =
> SYSTABLES') order by columnnumber;
> COLUMNNUMB&|COLUMNNAME
>
> ------------------------------------------------------------------------------------------------------------------------
> --------------------
> 1          |TABLEID
>
> 2          |TABLENAME
>
> 3          |TABLETYPE
>
> 4          |SCHEMAID
>
> 5          |LOCKGRANULARITY
>
>
> 5 rows selected
> ij> exit;
>
>
>
>   %%%  Attempts w/APP   %%%%%%%%%%%
> ij version 10.3
> ij> connect 'jdbc:derby:tstDB;upgrade=true;user=APP;password=APP';
> ERROR 08004: User 'APP' cannot hard upgrade database 'tstDB'. Only the
> database owner can perform this operation.
>
>
>
>

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