|
I'm with problems to update table with foreign
key fields, the fields that are foreign keys brought update with value "null".
It follows mapping XML and stack trace generated for P6Spy.
<class-descriptor
class="br.com.gerfiscal.NotaFiscal"
table="GERFISCAL.TB_NOTA_FISCAL">
<field-descriptor name="nrProc" column="NR_PROC" jdbc-type="VARCHAR" primarykey="true" /> <field-descriptor name="dataEntrada" column="DATA_ENTRADA" jdbc-type="DATE" /> <field-descriptor name="codigoEmpresa" column="CD_EMPRESA" jdbc-type="INTEGER" /> <field-descriptor name="natOperacao" column="NAT_OPE" jdbc-type="VARCHAR" /> <field-descriptor name="numeroNota" column="NUMERO_NOTA" jdbc-type="BIGINT" /> <field-descriptor name="valorNota" column="VALOR_NOTA" jdbc-type="REAL" /> <field-descriptor name="codigoUnaDm" column="CD_UA_RESP" jdbc-type="VARCHAR" /> <field-descriptor name="codForncId" column="COD_FORNC_ID" jdbc-type="BIGINT" /> <field-descriptor name="dataComprometimento" column="DT_COMPRO" jdbc-type="DATE" /> <field-descriptor name="numeroComprometimento" column="NUMERO_COMPRO" jdbc-type="INTEGER" /> <field-descriptor name="codigoContrato" column="CD_CONTRATO" jdbc-type="VARCHAR" /> <field-descriptor name="mesAno" column="MES_ANO" jdbc-type="DATE" /> <field-descriptor name="forma" column="FORMA" jdbc-type="VARCHAR" /> <reference-descriptor name="fornecedor" class-ref="br.com.bean.cad.Fornecedor2" refresh="true" auto-retrieve="true" > <foreignkey field-ref="codForncId" /> </reference-descriptor> <reference-descriptor name="compro" class-ref="br.com.bean.orcam.Comprometimento" refresh="true" auto-retrieve="true" > <foreignkey field-ref="dataComprometimento" /> <foreignkey field-ref="numeroComprometimento" /> </reference-descriptor> <reference-descriptor name="contratoOrc" class-ref="br.com.bean.orcam.ContratoOrcam" refresh="true" auto-retrieve="true" > <foreignkey field-ref="codigoEmpresa" /> <foreignkey field-ref="codigoContrato" /> </reference-descriptor> <reference-descriptor name="ua" class-ref="br.com.bean.ctb.UnidadeAdministrativa" refresh="true" auto-retrieve="true" > <foreignkey field-ref="codigoUnaDm" /> </reference-descriptor> </class-descriptor> UPDATE GERFISCAL.TB_NOTAFISCAL_APROPSET CC_CONTABIL = '', CD_CONTRATO = '', CD_EMPRESA = '1', CD_NG_1 = '', CD_ORCAMENTO = '', CD_PROJETO = '', DATA_COMPR = '', ELEM_CUS = '', NAGAS = '', NUMERO_COMPR = '406', ORDEM_CUR = '', SOMA_ABATE = 'S', TIPO_ORCA = '', UNID_ADM = '', UNID_OPE = '', VALOR = '0.0', SELECIONADA = 'S' WHERE SQ_APROP = '' AND NR_PROC = '2' [],
Francisco Bruno Analista de Sistemas OFM Tecnologia & Informa��o ----------------------------------------------------------------------------------------------------------------- "Fa�a as coisas o mais simples que voc� puder, por�m n�o as mais simples." Albert Einstein |
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.11 - Release Date: 12/1/2005
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
