Estou tentando fazer uma inserção de um registro no BD Firebird mas ocorre o seguinte erro:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544466. violation of FOREIGN KEY constraint “FK_ACESSO_SISTEMA_ADMIN” on table “ACESSO_SISTEMA”
Foreign key reference target does not exist
[code]/**************************************************************************/
/ Generated by IBExpert 19/01/2012 08:18:15 /
/**************************************************************************/
/**************************************************************************/
/ Tables /
/**************************************************************************/
CREATE GENERATOR GEN_ACESSO_SISTEMA_ID;
CREATE TABLE ACESSO_SISTEMA (
ID_ACESSO_SISTEMA INTEGER NOT NULL,
DATA_ACESSO DATE,
ID_USUARIO_ADMIN INTEGER,
HORA_ENTRADA TIME,
HORA_SAIDA TIME,
ID_USUARIO_PADRAO INTEGER
);
/**************************************************************************/
/ Primary Keys /
/**************************************************************************/
ALTER TABLE ACESSO_SISTEMA ADD CONSTRAINT PK_ACESSO_SISTEMA PRIMARY KEY (ID_ACESSO_SISTEMA);
/**************************************************************************/
/ Foreign Keys /
/**************************************************************************/
ALTER TABLE ACESSO_SISTEMA ADD CONSTRAINT FK_ACESSO_SISTEMA_ADMIN FOREIGN KEY (ID_USUARIO_ADMIN) REFERENCES USUARIO_ADMIN (ID_USUARIO_ADMIN)
USING INDEX FK_ACESSO_SISTEMA_1;
ALTER TABLE ACESSO_SISTEMA ADD CONSTRAINT FK_ACESSO_SISTEMA_PADRAO FOREIGN KEY (ID_USUARIO_PADRAO) REFERENCES USUARIO_PADRAO (ID_USUARIO_PADRAO)
USING INDEX FK_ACESSO_SISTEMA_2;
/**************************************************************************/
/ Triggers /
/**************************************************************************/
SET TERM ^ ;
/**************************************************************************/
/ Triggers for tables /
/**************************************************************************/
/* Trigger: ACESSO_SISTEMA_BI */
CREATE OR ALTER TRIGGER ACESSO_SISTEMA_BI FOR ACESSO_SISTEMA
ACTIVE BEFORE INSERT POSITION 0
as
begin
if (new.id_acesso_sistema is null) then
new.id_acesso_sistema = gen_id(gen_acesso_sistema_id,1);
end
^
SET TERM ; ^
/**************************************************************************/
/ Privileges /
/**************************************************************************/
[/code]