I have a copy of derby distributed with netbeans, and I added a column
to my table, but now I can't drop it.
ALTER TABLE Pages DROP COLUMN Links
Exception in thread "main" java.sql.SQLSyntaxErrorException: Syntax
error: Encountered "DROP" at line 1, column 19.
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.execute(Unknown
Source)
at linkcounter.Main.main(Main.java:14)
Caused by: org.apache.derby.client.am.SqlException: Syntax error:
Encountered "DROP" at line 1, column 19.
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.executeX(Unknown
Source)
... 2 more
Java Result: 1
