Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Derby

19 views
Skip to first unread message

Chase Preuninger

unread,
Mar 6, 2008, 6:47:15 AM3/6/08
to
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...@gmail.com

unread,
Mar 13, 2008, 11:47:51 AM3/13/08
to
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

unread,
Mar 13, 2008, 8:10:05 PM3/13/08
to
Alex.From...@gmail.com wrote:
> 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.cloudscape.doc/rrefsql9241891.html>

--
Lew

0 new messages