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
Alex.From.Ohio.Java@gmail.com - 13 Mar 2008 16:47 GMT
Your exception says clearly: Syntax
error: Encountered "DROP" at line 1, column 19.
You can't drop column.
See syntax here:
http://db.apache.org/derby/docs/10.1/ref/
Alex.
http://www.myjavaserver.com/~alexfromohio/
Lew - 14 Mar 2008 01:10 GMT
> Your exception says clearly: Syntax
> error: Encountered "DROP" at line 1, column 19.
>
> You can't drop column.
> See syntax here:
> http://db.apache.org/derby/docs/10.1/ref/
My, that is a significant variance from the SQL standard.
I found a more complete comparison of Derby syntax with SQL 92 at
<http://publib.boulder.ibm.com/infocenter/cscv/v10r1/index.jsp?topic=/com.ibm.clo
udscape.doc/rrefsql9241891.html>

Signature
Lew