db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald McLean" <dmclea...@gmail.com>
Subject Re: SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Tue, 27 May 2008 21:08:22 GMT
You can't set the value of an "identity always" column. You have to leave it
out of the inserted values and you have to specify all of the other columns
in the function call.

On Tue, May 27, 2008 at 12:14 PM, Pablo Vázquez Blázquez <
pvazquez@denodo.com> wrote:

> Hello,
>
> I am trying to perform a SYSCS_UTIL.SYSCS_IMPORT_TABLE operation, but I
> recieve the following error:
>
>   [sql] Executing file:
> C:\CVSROOT\scheduler-test\database\script\ImportDerbyDB.sql
>   [sql] [ERROR] Failed to execute:  CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
> (NULL, 'SCHED_PROJECTS', 'database/data/SCHED_PROJECTS.del', null, null,
> 'UTF-8', 0)
>   [sql] [ERROR] java.sql.SQLException: The exception
> 'java.sql.SQLException: Attempt to modify an identity column 'ID'.' was
> thrown while evaluating an expression.
>
> Why do I recieve this error? Isn't it suppossed to be inserting the files
> at SCHED_PROJECTS.del file? Is there any way of disabling constraints before
> executing IMPORT?
>

Mime
View raw message