[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-10-09 Thread Mamta A. Satoor (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mamta A. Satoor updated DERBY-5567:
---

Fix Version/s: 10.5.3.2

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
>Assignee: Mamta A. Satoor
> Fix For: 10.5.3.2, 10.6.2.3, 10.7.1.4, 10.8.2.3, 10.9.1.0
>
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown 
> Source)
>   at 
> or

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-10-09 Thread Mamta A. Satoor (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mamta A. Satoor updated DERBY-5567:
---

Fix Version/s: 10.6.2.3

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
>Assignee: Mamta A. Satoor
> Fix For: 10.6.2.3, 10.7.1.4, 10.8.2.3, 10.9.1.0
>
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown 
> Source)
>   at 
> org.apache.d

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-10-08 Thread Mamta A. Satoor (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mamta A. Satoor updated DERBY-5567:
---

Fix Version/s: 10.7.1.4

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
>Assignee: Mamta A. Satoor
> Fix For: 10.7.1.4, 10.8.2.3, 10.9.1.0
>
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown 
> Source)
>   at 
> org.apache.derby.impl.

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-02-03 Thread Dag H. Wanvik (Updated) (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dag H. Wanvik updated DERBY-5567:
-

Issue & fix info: Repro attached
   Fix Version/s: 10.8.2.3

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
>Assignee: Dag H. Wanvik
> Fix For: 10.8.2.3, 10.9.0.0
>
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown 
> Source)
>   at

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-02-03 Thread Dag H. Wanvik (Updated) (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dag H. Wanvik updated DERBY-5567:
-

Component/s: (was: Test)
 SQL

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
>Assignee: Dag H. Wanvik
> Fix For: 10.8.2.3, 10.9.0.0
>
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown 
> Source)
>   at 
> org.apache.d

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-02-02 Thread Dag H. Wanvik (Updated) (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dag H. Wanvik updated DERBY-5567:
-

Issue & fix info:   (was: Patch Available)
   Fix Version/s: 10.9.0.0

Thanks for looking at the patch, Rick. I'll backport this to 10.8 branch, then 
close it. It can likely be backported further if anyone is interested, the 
error goes further back.



> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: Test
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
> Fix For: 10.9.0.0
>
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControl

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-01-27 Thread Dag H. Wanvik (Updated) (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dag H. Wanvik updated DERBY-5567:
-

Issue & fix info: Patch Available

As for tests, the only way I know to provoke this error frequently is by 
running AlterTableTest with a fixed ordering, cf the attachment. We probably do 
not want to commit that change, so the patch only includes the change to 
ViewDescriptor. For test driving the patch, I would suggest using the attached 
test since that is likely to pop the error.

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: Test
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consoleProp

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-01-27 Thread Dag H. Wanvik (Updated) (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dag H. Wanvik updated DERBY-5567:
-

Attachment: derby-5567-1.diff

Uploading a patch derby-5567-1, which implements the strategy described above. 
In addition to retaining the original invalidation action when recursing 
through views to their dependents, I added a check in 
ViewDescriptor#makeInvalid to see if the data dictionary entry is already gone 
lest we try to remove it twice. An absence of this test would lead to a NPE in 
the case under consideration (td would be null).

In addition to dropping columns, revoking privileges or dropping roles will 
also lead to dependent views being dropped in the current implementation. The 
bug seen may or may not occur in that case, but the patch makes the code retain 
those invalidation actions also, when recursing invalidation through a view's 
dependents.

Running regressions.


> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: Test
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
> Attachments: AlterTableTest.java, derby-5567-1.diff
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>

[jira] [Updated] (DERBY-5567) AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency

2012-01-24 Thread Dag H. Wanvik (Updated) (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dag H. Wanvik updated DERBY-5567:
-

Attachment: AlterTableTest.java

> AlterTableTest#testDropColumn fails: drop view cannot be performed due to 
> dependency
> 
>
> Key: DERBY-5567
> URL: https://issues.apache.org/jira/browse/DERBY-5567
> Project: Derby
>  Issue Type: Bug
>  Components: Test
>Affects Versions: 10.8.2.2
> Environment: Windows 7 Enterprise SP1, Java 1.7u4 prerelease, -d64
>Reporter: Dag H. Wanvik
> Attachments: AlterTableTest.java
>
>
> Saw this when running suitesAll on 10.8.2.2:
> 1) 
> testDropColumn(org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest)java.sql.SQLException:
>  Operation 'DROP VIEW' cannot be performed on object 'ATDC_VW_5A_1' because 
> VIEW 'ATDC_VW_5A_2' is dependent on that object.
>   at 
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.SqlException.getSQLException(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)
>   at 
> org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testDropColumn(AlterTableTest.java:2465)
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:113)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at 
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
>   at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
>   at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
>   at junit.extensions.TestSetup.run(TestSetup.java:25)
> Caused by: org.apache.derby.client.am.SqlException: Operation 'DROP VIEW' 
> cannot be performed on object 'ATDC_VW_5A_1' because VIEW 'ATDC_VW_5A_2' is 
> dependent on that object.
>   at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
>   at 
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown 
> Source)
>   at 
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
>   at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown 
> Source)
>   at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
>   at org.apache.derby.client.am.Statement.executeUpdateX(Unknown Source)
>   ... 55 more
> Prior to this, though, I saw this on the console, but no error/failure. 
> Probably not related, I believe we have seen this before:
> java.lang.Exception: DRDA_InvalidReplyTooShort.S:Invalid reply from network 
> server: Insufficient data.
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessageWork(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.consolePropertyMessage(Unknown
>  Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.fillReplyBuffer(Unknown 
> Source)
>   at 
> org.apache.derby.impl.drda.NetworkServerControlImpl.readResult(Unknown Source)
>   at 
> org.apache.derby.impl.drda.NetworkSe