4) testMetaDataQueryRunInSYScompilationSchema(org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4)java.sql.SQLException: Failed to create database 'singleUse/oneuse2d', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Ljava/lang/String;Ljava/lang/String;Ljava/sql/SQLException;ILjava/lang/Throwable;[Ljava/lang/Object;)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Ljava/lang/String;[Ljava/lang/Object;Ljava/sql/SQLException;ILjava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Ljava/lang/String;[Ljava/lang/Object;Ljava/sql/SQLException;)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Ljava/lang/String;Ljava/util/Properties;)Lorg/apache/derby/iapi/db/Database;(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Lorg/apache/derby/jdbc/InternalDriver;Ljava/lang/String;Ljava/util/Properties;)V(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Lorg/apache/derby/jdbc/InternalDriver;Ljava/lang/String;Ljava/util/Properties;)V(Unknown Source)
at org.apache.derby.jdbc.Driver169.getNewEmbedConnection(Ljava/lang/String;Ljava/util/Properties;)Lorg/apache/derby/impl/jdbc/EmbedConnection;(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection;(Unknown Source)
at org.apache.derby.jdbc.EmbeddedSimpleDataSource.getConnection(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;(Unknown Source)
at org.apache.derby.jdbc.EmbeddedSimpleDataSource.getConnection()Ljava/sql/Connection;(Unknown Source)
at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_4.testMetaDataQueryRunInSYScompilationSchema()V(Changes10_4.java:113)
at org.apache.derbyTesting.junit.BaseTestCase.runBare()V(BaseTestCase.java:105)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(Ljunit/framework/TestResult;)V(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(Ljunit/framework/TestResult;)V(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect()V(TestSetup.java:21)
at junit.extensions.TestSetup.run(Ljunit/framework/TestResult;)V(TestSetup.java:25)
at sun.misc.CVM.runMain()V(CVM.java:514)
Caused by: java.sql.SQLException: Collator support not available from the JVM for the database's locale 'no'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Ljava/lang/String;Ljava/lang/String;Ljava/sql/SQLException;ILjava/lang/Throwable;[Ljava/lang/Object;)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Lorg/apache/derby/iapi/error/StandardException;)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Ljava/lang/Throwable;ZZ)Ljava/sql/SQLException;(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Ljava/lang/Throwable;)Ljava/sql/SQLException;(Unknown Source)
... 99 more
Caused by: ERROR XBM04: Collator support not available from the JVM for the database's locale 'no'.
at org.apache.derby.iapi.error.StandardException.newException(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;(Unknown Source)
at org.apache.derby.iapi.types.DataValueFactoryImpl.verifyCollatorSupport()Ljava/text/RuleBasedCollator;(Unknown Source)
at org.apache.derby.iapi.types.DataValueFactoryImpl.boot(ZLjava/util/Properties;)V(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Ljava/lang/Object;ZLjava/util/Properties;)V(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(ZLjava/lang/Object;Lorg/apache/derby/impl/services/monitor/ProtocolKey;Ljava/util/Properties;)Ljava/lang/Object;(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(ZLjava/lang/Object;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;)Ljava/lang/Object;(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(ZLjava/lang/Object;Ljava/lang/String;Ljava/util/Properties;)Ljava/lang/Object;(Unknown Source)
at org.apache.derby.impl.db.BasicDatabase.boot(ZLjava/util/Properties;)V(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Ljava/lang/Object;ZLjava/util/Properties;)V(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(ZLjava/lang/Object;Lorg/apache/derby/impl/services/monitor/ProtocolKey;Ljava/util/Properties;)Ljava/lang/Object;(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Lorg/apache/derby/iapi/services/monitor/PersistentService;Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;Z)Ljava/lang/Object;(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;)Ljava/lang/Object;(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Ljava/lang/String;Ljava/lang/String;Ljava/util/Properties;)Ljava/lang/Object;(Unknown Source)
... 99 more

Dag H. Wanvik
added a comment - 30/Oct/08 23:10 The VM seems to not find collator support for the "no" locale.. Is this an issue with the test's environment, perhaps?
Is this test intended to work only with en_US?

DERBY-3925_1.diff.txt changes
testMetaDataQueryRunInSYScompilationSchema
to use 'territory=en' instead of 'territory=no' if the 'no' locale is not available.
This is e.g. the case on phoneME.

A comment in the test states that
"This test is for databases with territory based collation."
so I think 'territory=en' should be OK?
Territory based collation is specified with 'collation=TERRITORY_BASED' (vs. default 'UCS_BASIC').

Ole Solberg
added a comment - 09/Oct/09 09:25 DERBY-3925 _1.diff.txt changes
testMetaDataQueryRunInSYScompilationSchema
to use 'territory=en' instead of 'territory=no' if the 'no' locale is not available.
This is e.g. the case on phoneME.
A comment in the test states that
"This test is for databases with territory based collation."
so I think 'territory=en' should be OK?
Territory based collation is specified with 'collation=TERRITORY_BASED' (vs. default 'UCS_BASIC').
org.apache.derbyTesting.functionTests.tests.upgradeTests._Suite ran OK on phoneME and jvm1.6.
Running suites.All.

Knut Anders Hatlen
added a comment - 09/Oct/09 11:33 I agree that territory=en should be fine, since it's still using territory based collation. +1 to commit.
(Minor nit: Perhaps break out of the loop as soon as the requested locale is found?)