Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: domain of gcaddd-derby-dev@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: derby-dev@db.apache.org
From: Peter Nabbefeld <Peter.Nabbefeld@gmx.de>
Subject: Re: 10.1 branch created / please review open 10.1 JIRA issues
Date: Sat, 11 Jun 2005 23:27:02 +0200
Lines: 48
Message-ID: <d8fk56$ncl$1@sea.gmane.org>
References: <155E5416-F701-4485-BB21-290405E0A261@gmail.com>
 <d8blp4$d5v$1@sea.gmane.org> <22B2C628-2138-42D2-81E9-3881E0CABAE0@gmail.com>
 <d8e6k4$b21$1@sea.gmane.org> <42AAFACD.8080705@debrunners.com>
 <d8f7kq$knu$1@sea.gmane.org> <x1o3mzpwbthq.fsf@atum10.Norway.Sun.COM>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT;
 rv:1.7.3) Gecko/20040910
In-Reply-To: <x1o3mzpwbthq.fsf@atum10.Norway.Sun.COM>
Sender: news <news@sea.gmane.org>

Dyre.Tjeldvoll@Sun.COM schrieb:

> Peter Nabbefeld <Peter.Nabbefeld@gmx.de> writes:
> 
> [snip]
> 
> 
>>Is the default schema the owner of the trigger then? Or why is the
>>default schema needed, if I set a trigger on a table in a non-default
>>schema?
> 
> 
> Creating a trigger reequires a "compile schema". And the default
> schema is used. (Even if you write something like CREATE TRIGGER
> schemaX.t1...) 
> 
> 
>>>A schema that is being used but does not exist (has not been
>>>created persistently) has a null UUID.
>>>JDBC Connection's don't have a UUID that represents the identity of
>>>the
>>>owner. Derby's engine code is centered around the
>>>LanguageConnectionContext (LCC) and not the JDBC Connection object. The
>>>JDBC object could be seen as just a wrapper on top of LCC. Thus most of
>>>the connection's state that is relevant to the SQL language layer is
>>>held in the LCC.
>>
>>I cannot find any UUID getter methods neither in LLC nor its
>>superclass, while from my point of view there should exist some ...
> 
> 
> LCC->SchemaDescriptor->getUUId()
> 
> http://incubator.apache.org/derby/javadoc/engine/org/apache/derby/iapi/sql/conn/LanguageConnectionContext.html
> 
> http://incubator.apache.org/derby/javadoc/engine/org/apache/derby/iapi/sql/dictionary/SchemaDescriptor.html
> 
I've looked at it. As I've seen, LLC supports only to get the default 
schema (so it seems to be difficult to get a non-default schema for 
compilation; probably "getSchema(String name)" should be added to LLC). 
However, if there is no default user schema, default schema should be 
"APP", not null (if I've understood the comment for "protected 
SchemaDescriptor initDefaultSchemaDescriptor() ..." in 
GenericLanguageConnectionContext correct).

Kind regards

Peter