db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prasenjit Sarkar <psar...@almaden.ibm.com>
Subject Re: Q: alter table to set default column values..
Date Wed, 17 Oct 2007 14:59:10 GMT
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                                               
             <bpendleton@amber                                             
             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"                                                
             <derby-user@db.ap                                             
                 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




Mime
View raw message