Alter table fails with Derby 10.10.2.0

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Alter table fails with Derby 10.10.2.0

P.N.

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

Reply | Threaded
Open this post in threaded view
|

[SOLVED] Re: Alter table fails with Derby 10.10.2.0

P.N.
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
>
>