[SOLVED] Re: Alter table fails with Derby 10.10.2.0

[Peter Nabbefeld <pe...@gmx.de>]

Hi,

found somewhere a hint to "SYSCS_UTIL.SYSCS_COMPRESS_TABLE", which I 
could use to fix my table.

Regards
P.


Am 19.01.2017 um 06:49 schrieb Peter Nabbefeld:
>
> Hello,
>
> I'm using Derby 10.10.2.0 - (1582446). ALTER TABLE fails with following
> message (I've copied the Hibernate part, too, but tried also manual):
>
>
> INFO
> [org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl]:
> HHH000115: Hibernate connection pool size: 20 (min=1)
> INFO
> [org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl]:
> HHH000115: Hibernate connection pool size: 20 (min=1)
> INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate]: HHH000228: Running
> hbm2ddl schema update
> INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate]: HHH000228: Running
> hbm2ddl schema update
> SEVERE [org.openide.util.Exceptions]
> org.apache.derby.client.am.SqlException: In einer Basistabelle wich die
> Anzahl der angeforderten Spalten 28 von der maximalen Spaltenanzahl 29 ab.
>     at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
> [...]
>
> For the essage in German, the meaning is:
> In a base table the number of requested columns 28 differs from the
> maximum number of columns 29.
>
> It seems, the number of columns has been upgraded, but the new column
> has not been added - how can I repair that manually?
>
> Kind regards
> Peter
>
>