db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Embretsen <John.Embret...@Sun.COM>
Subject Re: Questions about ij> connect
Date Thu, 28 Jun 2007 11:22:47 GMT
Lance J. Andersen wrote:
> John Embretsen wrote:
>> Also, be aware of default schemas and implicit schema creation, a 
>> common source of confusion. From FAQ 5.3 [1]:
>> "The current schema for any connection defaults to a schema 
>> corresponding to the user name. If no user name is supplied then the 
>> user name (and hence current schema) defaults to APP.
>> However even though the current schema is set to the user name, that 
>> schema may not exist. A schema is only created by CREATE SCHEMA or 
>> creating an object (table etc.) in that schema (this is implicit 
>> schema creation)."
> This point is key as I know until i did a deep dive based on what i saw 
> with the Netbeans explorer, i did not really think about the schema 
> getting created until the object for that user name (when create schema 
> was not used) occurs.
> We should probably open a JIRA to clarify when the schema is created in 
> more explict detail

Yes, feel free to do so; I couldn't find anywhere in the manuals where the 
details of implicit schema creation is explained. I wasn't really aware of these 
details either until I noticed a related NetBeans issue:



View raw message