You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Peter Nabbefeld <pe...@gmx.de> on 2017/01/19 05:49:37 UTC
Alter table fails with Derby 10.10.2.0
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
[SOLVED] Re: Alter table fails with Derby 10.10.2.0
Posted by 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
>
>