[ http://issues.apache.org/jira/browse/DERBY-1706?page=comments#action_12435075 ] Suresh Thalamati commented on DERBY-1706: -----------------------------------------
Hi Mamta, just a general 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 ? Thanks -suresh > 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 > 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