The following error message is obtained:
ALTER TABLE T_RES_FILESYSTEM ALTER COLUMN GROUP_ID DEFAULT -1
org.apache.derby.client.am.SqlException: Syntax error: Encountered
"DEFAULT" at line 1, column 53.
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)
at org.apache.derby.client.am.Statement.executeUpdate(Unknown
Source))
at org.eclipse.aperi.install.SilentDatabaseInstall.executeSql(
SilentDatabaseInstall.java:453)
at org.eclipse.aperi.install.SilentDatabaseInstall.executeSql(
SilentDatabaseInstall.java:468)
at org.eclipse.aperi.install.SilentDatabaseInstall.createTables(
SilentDatabaseInstall.java:778)
at org.eclipse.aperi.install.SilentDatabaseInstall.doInstall(
SilentDatabaseInstall.java:717)
at org.eclipse.aperi.install.SilentDatabaseInstall.main(
SilentDatabaseInstall.java:975)
at
org.eclipse.aperi.configure.ConfigureAperi.runSilentDatabaseInstall(
ConfigureAperi.java:1427)
at org.eclipse.aperi.configure.ConfigureAperi.schema(
ConfigureAperi.java:1360)
at org.eclipse.aperi.configure.ConfigureAperi.configure(
ConfigureAperi.java:309)
at org.eclipse.aperi.configure.ConfigureAperi.configureAperi(
ConfigureAperi.java:157)
at org.eclipse.aperi.configure.ConfigureAperiIDE.main(
ConfigureAperiIDE.java:55)
Bryan Pendleton
<[EMAIL PROTECTED]
point.com> To
Derby Discussion
10/16/2007 11:15 <derby-user@db.apache.org>
AM cc
Subject
Please respond to Re: Q: alter table to set default
"Derby column values..
Discussion"
<[EMAIL PROTECTED]
ache.org>
> ALTER TABLE T_RES_FILESYSTEM ALTER COLUMN GROUP_ID DEFAULT -1 ;
>
> It appears that this is not working.
What is the problem that you encounter? Do you get an error message?
thanks,
bryan
