Return-Path: X-Original-To: apmail-cayenne-commits-archive@www.apache.org Delivered-To: apmail-cayenne-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3498511389 for ; Sat, 30 Aug 2014 18:34:53 +0000 (UTC) Received: (qmail 88678 invoked by uid 500); 30 Aug 2014 18:34:53 -0000 Delivered-To: apmail-cayenne-commits-archive@cayenne.apache.org Received: (qmail 88648 invoked by uid 500); 30 Aug 2014 18:34:53 -0000 Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cayenne.apache.org Delivered-To: mailing list commits@cayenne.apache.org Received: (qmail 88629 invoked by uid 99); 30 Aug 2014 18:34:53 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 30 Aug 2014 18:34:53 +0000 Date: Sat, 30 Aug 2014 18:34:52 +0000 (UTC) From: "Andrus Adamchik (JIRA)" To: commits@cayenne.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CAY-1948) Oracle adapter: Quoting sequence names when appropriate MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Andrus Adamchik created CAY-1948: ------------------------------------ Summary: Oracle adapter: Quoting sequence names when appropriate Key: CAY-1948 URL: https://issues.apache.org/jira/browse/CAY-1948 Project: Cayenne Issue Type: Improvement Affects Versions: 3.2M1, 3.1RC1 Reporter: Andrus Adamchik Assignee: Andrus Adamchik Priority: Minor I noticed that when running unit tests against Oracle after a first run, all following runs fail with the error below ("ORA-02289: sequence does not exist"). Essentially we can't "drop pk_test_qualified1". I haven't looked closely yet, but I suspect this is caused by the fact that the sequence was created in lowercase , but when dropping it without quoting the name, Oracle tries to find an uppercase sequence. So we might need to apply appropriate quotation strategy. INFO: DROP SEQUENCE pk_test_qualified1 org.apache.maven.surefire.booter.SurefireExecutionException: org.apache.cayenne.access.trans.BatchQueryBuilderTest; nested exception is java.lang.ExceptionInInitializerError: null; nested exception is org.apache.maven.surefire.testset.TestSetFailedException: org.apache.cayenne.access.trans.BatchQueryBuilderTest; nested exception is java.lang.ExceptionInInitializerError: null org.apache.maven.surefire.testset.TestSetFailedException: org.apache.cayenne.access.trans.BatchQueryBuilderTest; nested exception is java.lang.ExceptionInInitializerError: null java.lang.ExceptionInInitializerError at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at junit.framework.TestSuite.createTest(TestSuite.java:131) at junit.framework.TestSuite.addTestMethod(TestSuite.java:114) at junit.framework.TestSuite.(TestSuite.java:75) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.apache.maven.surefire.junit.JUnitTestSet.constructTestObject(JUnitTestSet.java:151) at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:197) at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115) at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102) at org.apache.maven.surefire.Surefire.run(Surefire.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350) at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021) Caused by: java.lang.RuntimeException: Error rebuilding schema at org.apache.cayenne.unit.di.server.SchemaBuilder.rebuildSchema(SchemaBuilder.java:138) at org.apache.cayenne.unit.di.server.ServerCase.(ServerCase.java:46) ... 22 more Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999) -- This message was sent by Atlassian JIRA (v6.2#6252)