db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1706) NullPointerException occurs when trying to create a table in schema SESSION
Date Tue, 19 Sep 2006 06:53:25 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1706?page=comments#action_12435704 ] 
            
Mamta A. Satoor commented on DERBY-1706:
----------------------------------------

Suresh, to answer your question "Why is it necessary to allow users to create a non-temporary
tables in the "session" schema , when the schema is not created explicitly ? "

I think it may have to do with the usability.

Let me take the following generic eg 
connect 'jdbc:derby:c:/dellater/dbmaintest2;create=true' user 'mamta1' as mamta1;
select * from sys.syschemas; -- this will not show *mamta1* as one of the schemas
create table t1(c11 int); -- the creation of first user-defined object will implicitly create
the schema *mamta1*
select * from sys.syschemas; -- this will *now* show *mamta1* as one of the schemas

I think to avoid the confusion with the usability in case of temporary table and non-temporary
tables, Derby chose to provide the same behavior for the 2 table types in "session" schema
ie you can create either of the table types in "session" schema w/o first having to manually
create the "session" schema. This behavior also matches the generic eg given above
So, extending the eg above for session schema to show Derby's current behavior
connect 'jdbc:derby:c:/dellater/dbmaintest2;create=true' user 'mamta1' as mamta1;
select * from sys.syschemas; -- this will not show *session* schema as one of the schemas
set schema session;
select * from sys.syschemas; -- still will not show *session* schema as one of the schemas
create table t1(c11 int); -- the creation of first user-defined table will implicitly create
the schema *session*
select * from sys.syschemas; -- this will *now* show *session* as one of the schemas


> NullPointerException occurs when trying to create a table in schema SESSION
> ---------------------------------------------------------------------------
>
>                 Key: DERBY-1706
>                 URL: http://issues.apache.org/jira/browse/DERBY-1706
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.2.1.0
>         Environment: Sun JDK 1.4.2
>            Reporter: Yip Ng
>         Assigned To: Mamta A. Satoor
>            Priority: Minor
>             Fix For: 10.2.1.0, 10.3.0.0
>
>         Attachments: DERBY1706NPEwithSessionSchemaV1diff.txt, DERBY1706NPEwithSessionSchemaV2diff.txt,
DERBY1706NPEwithSessionSchemaV3diff.txt
>
>
> NPE occurs when attempting to create a table in schema session:
> ij version 10.2
> ij> connect 'jdbc:derby:wombat;create=true' user 'user1';
> WARNING 01J14: SQL authorization is being used without first enabling authentica
> tion.
> ij> set schema session;
> 0 rows inserted/updated/deleted
> ij> create table t1 (i int);
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> derby.log:
> ----------------------------------------------------------------
> 2006-08-16 20:49:02.765 GMT:
>  Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.1.0 beta
- (430903): instance c013800d-010d-18be-88cf-00000013f010
> on database directory C:\work3\derby\tests\derby-10.2.1.0\lib\wombat  
> Database Class Loader started - derby.database.classpath=''
> 2006-08-16 20:49:17.312 GMT Thread[main,5,main] (XID = 122), (SESSIONID = 0), (DATABASE
= wombat), (DRDAID = null), Cleanup action starting
> 2006-08-16 20:49:17.312 GMT Thread[main,5,main] (XID = 122), (SESSIONID = 0), (DATABASE
= wombat), (DRDAID = null), Failed Statement is: create table t1 (i int)
> java.lang.NullPointerException
> 	at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
> 	at org.apache.derby.impl.sql.compile.DDLStatementNode.getSchemaDescriptor(Unknown Source)
> 	at org.apache.derby.impl.sql.compile.DDLStatementNode.getSchemaDescriptor(Unknown Source)
> 	at org.apache.derby.impl.sql.compile.CreateTableNode.referencesSessionSchema(Unknown
Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.referencesSessionSchema(Unknown
Source)
> 	at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> 	at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> 	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
> 	at org.apache.derby.tools.ij.main(Unknown Source)
> Cleanup action completed
> 2006-08-16 20:49:55.312 GMT:
> Shutting down instance c013800d-010d-18be-88cf-00000013f010
> ----------------------------------------------------------------
> sysinfo:
> ------------------ Java Information ------------------
> Java Version:    1.4.2_12
> Java Vendor:     Sun Microsystems Inc.
> Java home:       C:\Program Files\Java\j2re1.4.2_12
> Java classpath:  derby.jar;derbytools.jar;.
> OS name:         Windows XP
> OS architecture: x86
> OS version:      5.1
> Java user name:  Yip
> Java user home:  C:\Documents and Settings\Yip
> Java user dir:   C:\work3\derby\tests\derby-10.2.1.0\lib
> java.specification.name: Java Platform API Specification
> java.specification.version: 1.4
> --------- Derby Information --------
> JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
> [C:\work3\derby\tests\derby-10.2.1.0\lib\derby.jar] 10.2.1.0 beta - (430903)
> [C:\work3\derby\tests\derby-10.2.1.0\lib\derbytools.jar] 10.2.1.0 beta - (430903
> )
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> Current Locale :  [English/United States [en_US]]
> Found support for locale: [de_DE]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [es]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [fr]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [it]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [ja_JP]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [ko_KR]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [pt_BR]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [zh_CN]
>          version: 10.2.1.0 - (430903)
> Found support for locale: [zh_TW]
>          version: 10.2.1.0 - (430903)
> ------------------------------------------------------

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message