WRITING MULTIPLE INES USING JDBC ADAPTER

[Former Member]

We are working a solution file-Jdbc that presents the following xml after activation of the cenario in question:

<?xml version="1.0" encoding="UTF-8" ?>

- <p2:P1_Funcionario_MT xmlns:p2="urn:cemig:P1:RH">

- <ESTRUT_FUNC>

- <TFUNCIONARIO ACTION="UPDATE_INSERT">

- <ACCESS>

<NUM_MATRICULA>123460</NUM_MATRICULA>

<NOM_FUNCIONARIO>ANTONIO5CARLOS BORGES BATISTA</NOM_FUNCIONARIO>

<DES_FUNCAO>ENG EMPREENDIMENTO1</DES_FUNCAO>

<SIG_ORGAO>1</SIG_ORGAO>

<END_LOCAL_TRAB>1</END_LOCAL_TRAB>

<END_FUNCIONAL>END FUNC</END_FUNCIONAL>

<NUM_TELEFONE>2737328041</NUM_TELEFONE>

<NOM_CIDADE>AIMOR\'c9S</NOM_CIDADE>

<DAT_NASCIMENTO>19610620</DAT_NASCIMENTO>

<TIP_SITUACAO>T</TIP_SITUACAO>

<NUM_UA>UA</NUM_UA>

<DAT_ATUALIZACAO>2005/10/19</DAT_ATUALIZACAO>

<DES_EMAIL>acborges@cemig.com.br</DES_EMAIL>

<NUM_SIT>1</NUM_SIT>

<COD_CEP_LOTACAO>35200-000</COD_CEP_LOTACAO>

<DES_END_LOTACAO>FAZENDA VI\'c7OSA</DES_END_LOTACAO>

<NUM_END_LOTACAO>1</NUM_END_LOTACAO>

<DES_CIDADE_LOTACAO>AIMOR\'c9S</DES_CIDADE_LOTACAO>

<NUM_CEL_CORPORATIVO>1</NUM_CEL_CORPORATIVO>

<DES_LOCAL_TRABALHO>FAZENDA VI\'c7OSA</DES_LOCAL_TRABALHO>

<COD_EMPRESA>51</COD_EMPRESA>

<END_LOCAL_COMPLETO>USINA AIMOR\'c9S</END_LOCAL_COMPLETO>

</ACCESS>

- <ACCESS>

<NUM_MATRICULA>123461</NUM_MATRICULA>

<NOM_FUNCIONARIO>ANTONIO6CARLOS BORGES BATISTA</NOM_FUNCIONARIO>

<DES_FUNCAO>ENG EMPREENDIMENTO2</DES_FUNCAO>

<SIG_ORGAO>1</SIG_ORGAO>

<END_LOCAL_TRAB>1</END_LOCAL_TRAB>

<END_FUNCIONAL>END FUNC</END_FUNCIONAL>

<NUM_TELEFONE>2737328041</NUM_TELEFONE>

<NOM_CIDADE>AIMOR\'c9S</NOM_CIDADE>

<DAT_NASCIMENTO>19610620</DAT_NASCIMENTO>

<TIP_SITUACAO>T</TIP_SITUACAO>

<NUM_UA>UA</NUM_UA>

<DAT_ATUALIZACAO>2005/10/19</DAT_ATUALIZACAO>

<DES_EMAIL>acborges@cemig.com.br</DES_EMAIL>

<NUM_SIT>1</NUM_SIT>

<COD_CEP_LOTACAO>35200-000</COD_CEP_LOTACAO>

<DES_END_LOTACAO>FAZENDA VI\'c7OSA</DES_END_LOTACAO>

<NUM_END_LOTACAO>1</NUM_END_LOTACAO>

<DES_CIDADE_LOTACAO>AIMOR\'c9S</DES_CIDADE_LOTACAO>

<NUM_CEL_CORPORATIVO>1</NUM_CEL_CORPORATIVO>

<DES_LOCAL_TRABALHO>FAZENDA VI\'c7OSA</DES_LOCAL_TRABALHO>

<COD_EMPRESA>51</COD_EMPRESA>

<END_LOCAL_COMPLETO>USINA AIMOR\'c9S</END_LOCAL_COMPLETO>

</ACCESS>

- <KEY>

<NUM_MATRICULA>123460</NUM_MATRICULA>

<DES_FUNCAO>ENG EMPREENDIMENTO1</DES_FUNCAO>

</KEY>

- <KEY>

<NUM_MATRICULA>123461</NUM_MATRICULA>

<DES_FUNCAO>ENG EMPREENDIMENTO2</DES_FUNCAO>

</KEY>

</TFUNCIONARIO>

</ESTRUT_FUNC>

</p2:P1_Funcionario_MT>

The Message Monitor pointed to the Integration Server presents the following error:

2005-10-19 17:59:55 Error Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TFUNCIONARIO' (structure 'ESTRUT_FUNC'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'PK_TFUNCIONARIO'. Cannot insert duplicate key in object 'TFUNCIONARIO'.

We checked the primary key and it is present in the SQLSERVER table ( tfuncionario ). But the XI should rewriting this line and is not doing.

Anyone knows what is happening?

Thanks and regards,

Midervilson de Andrade.

[Former Member · Accepted solution]

Hi,

are you sure there are no records in tfunctionario table with 123460 and 123461.

please check the database, if possible clear the table (delete all data) and try again.

Naveen

[Former Member]

Thanks, Naveen.

The problem was in the mapping and in the definition of the key of the jdbc table. We link again checking the links mainly the root nodes and FUNCTIONED !!!

Many thanks for you atention.

Midervilson