You are running an ANCIENT version of h2. I removed that limitation in 2009!

On 5 May 2018 at 02:59, <[email protected]> wrote:

> Hello,
>
> I hope someone can help me. I have a NUXEO application and It creates
> fields from schemas when the application is initialized. I have created
> some views to improve performance, but when I boot the system this error
> occurs.
> 2018-04-25 16:01:37,539 ERROR [localhost-startStop-1] [org.apache.geronimo.
> connector.outbound.MCFConnectionInterceptor] Error occurred creating
> ManagedConnection for handle: nullManagedConnectionInfo:
> org.apache.geronimo.connector.outbound.ManagedConnectionInfo@76bfa49b.
> mc: null]
> org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Error
> adding column: ALTER TABLE "SCH_TRAMITE" ADD COLUMN "DESTINODN" VARCHAR :
> Operation not supported for table SCH_TRAMITE when there are views on the
> table: VW_ASSINATURA_LOTE; SQL statement:
> ALTER TABLE "SCH_TRAMITE" ADD COLUMN "DESTINODN" VARCHAR [90122-114]
> Does anyone know a way to initialize the application without the need to
> delete the views and re-create?
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to