Bom dia pessoal,
Estou tentando associar dois objetos no IBatis mas estou com problemas.
<resultMap class="com.vf.bvf.cpc.marketing.model.datatype.RegraSolicitacaoMaterialVO" id="RegraSolicitacaoMaterialResultMapper">
<result jdbcType="INTEGER" javaType="Integer" property="cdRegraSolicitacaoMaterial" column="CdRegraSolicitacaoMaterial"/>
<result jdbcType="DOUBLE" javaType="double" property="vrMultiplicadorParaSolicitacaoCCB" column="VrMultiplicadorParaSolicitacao"/>
<result jdbcType="INTEGER" javaType="Integer" property="qtdCCbsBloco" column="QtCCBBloco"/>
<result jdbcType="DOUBLE" javaType="double" property="vrMultiplicadorSaldo" column="VrMultiplicadorSaldo"/>
<result jdbcType="DOUBLE" javaType="double" property="vrProducaoMinima" column="VrProducaoMinima"/>
<result jdbcType="CHAR" javaType="String" property="tpGeracaoSaldo" column="TpGeracaoSaldo"/>
<result jdbcType="TIMESTAMP" javaType="Date" property="dtIniCriacaoSaldo" column="DtIniCriacaoSaldo"/>
<result jdbcType="TIMESTAMP" javaType="Date" property="dtFimCriacaoSaldo" column="DtFimCriacaoSaldo"/>
<result property="modalidades" column="CdRegraSolicitacaoMaterial" select="selecionaModalidade"/>
</resultMap>
<resultMap class="com.vf.bvf.cpc.marketing.model.datatype.RegraModalidadeVO" id="RegraModalidadeResultMapper">
<result jdbcType="INTEGER" javaType="Integer" property="cdProduto" column="CdProduto"/>
<result jdbcType="INTEGER" javaType="Integer" property="cdModalidadeProduto" column="CdModalidadeProduto"/>
<result jdbcType="DOUBLE" javaType="double" property="vrCreditoContratoPago" column="VrCreditoContratoPago"/>
</resultMap>
<!--
Comando para seleção
-->
<select id="listarRegrasDeSolicitacaoMaterial" resultMap="RegraSolicitacaoMaterialResultMapper">
SELECT
CdRegraSolicitacaoMaterial,
VrMultiplicadorParaSolicitacao,
QtCCBBloco,
VrMultiplicadorSaldo,
VrProducaoMinima,
TpGeracaoSaldo,
DtIniCriacaoSaldo,
DtFimCriacaoSaldo
FROM
dbcpc..tbRegraSolicitacaoMaterial
</select>
<insert id="persistirRegrasSolicitacaoMaterial" parameterClass="regras">
INSERT INTO dbcpc..tbRegraSolicitacaoMaterial
(CdRegraSolicitacaoMaterial, VrMultiplicadorParaSolicitacao, QtCCBBloco, VrMultiplicadorSaldo, VrProducaoMinima, TpGeracaoSaldo, DtIniCriacaoSaldo, DtFimCriacaoSaldo)
VALUES
(#cdRegraSolicitacaoMaterial#, #vrMultiplicadorSaldo#, #qtdCCbsBloco#, #vrMultiplicadorSaldo#, #vrProducaoMinima#, #tpGeracaoSaldo#, #dtIniCriacaoSaldo#, #dtFimCriacaoSaldo#)
</insert>
<select id="selecionaModalidade" resultMap="RegraModalidadeResultMapper" parameterClass="int">
SELECT
CdProduto,
CdModalidadeProduto,
VrCreditoContratoPago
FROM
dbcpc..tbRegraModalidade
WHERE
CdRegraSolicitacaoMaterial = #value#
</select>Ele “estoura” um erro de Spring. Sera que estou mapeando certo ???
O erro esta abaixo:
2010-06-30 10:56:42,909 ERROR [STDERR] 30/06/2010 10:56:42 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [com/vf/bvf/cpc/marketing/Marketing-Startup.xml]
2010-06-30 10:56:42,979 ERROR [STDERR] 30/06/2010 10:56:42 org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
INFO: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=9346982]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [businessBeanFactory]; root of BeanFactory hierarchy
2010-06-30 10:56:42,979 ERROR [STDERR] 30/06/2010 10:56:42 org.springframework.context.support.AbstractApplicationContext refresh
INFO: 1 beans defined in application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=9346982]
2010-06-30 10:56:42,989 ERROR [STDERR] 30/06/2010 10:56:42 org.springframework.context.support.AbstractApplicationContext initMessageSource
INFO: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@12d6858]
2010-06-30 10:56:42,989 ERROR [STDERR] 30/06/2010 10:56:42 org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
INFO: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@1d7b72]
2010-06-30 10:56:43,009 ERROR [STDERR] 30/06/2010 10:56:42 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [businessBeanFactory]; root of BeanFactory hierarchy]
2010-06-30 10:56:43,069 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [com/vf/bvf/fwk/jee/cfg/Spring-Base-Context.xml]
2010-06-30 10:56:43,159 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [com/vf/bvf/cpc/marketing/Marketing-Core.xml]
2010-06-30 10:56:43,259 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [com/vf/bvf/cpc/marketing/Marketing-Context.xml]
2010-06-30 10:56:43,349 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
INFO: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=11637573]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [abstractIbatisClient,abstractTransactionProxy,dataSourceDBCPC,ibatisClientDBCPC,ibatisTemplateDBCPC,transactionManagerDBCPC,baseTransactionProxyDBCPC,marketingSequenceDAO,periodoSolicitacaoMaterialDAO,materialMarketingDAO,regraSolicitacaoMateriaDAO,regraModalidadeDAO,categoriaMaterialBusinessDAO,modalidadeDAO,cadastroMaterialDAO,tipoMaterialDAO,marketingSequenceBO,periodoSolicitacaoMaterialBO,materialMarketingBO,regraSolicitacaoMaterialBO,categoriaMaterialBusinessBO,modalidadeBO,cadastroMaterialBO,tipoMaterialBO,MarketingLocator,suporteLocator]; root of BeanFactory hierarchy
2010-06-30 10:56:43,359 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.context.support.AbstractApplicationContext refresh
INFO: 26 beans defined in application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=11637573]
2010-06-30 10:56:43,450 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.context.support.AbstractApplicationContext initMessageSource
INFO: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@502b2]
2010-06-30 10:56:43,450 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
INFO: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@f3fd5c]
2010-06-30 10:56:43,450 ERROR [STDERR] 30/06/2010 10:56:43 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [abstractIbatisClient,abstractTransactionProxy,dataSourceDBCPC,ibatisClientDBCPC,ibatisTemplateDBCPC,transactionManagerDBCPC,baseTransactionProxyDBCPC,marketingSequenceDAO,periodoSolicitacaoMaterialDAO,materialMarketingDAO,regraSolicitacaoMateriaDAO,regraModalidadeDAO,categoriaMaterialBusinessDAO,modalidadeDAO,cadastroMaterialDAO,tipoMaterialDAO,marketingSequenceBO,periodoSolicitacaoMaterialBO,materialMarketingBO,regraSolicitacaoMaterialBO,categoriaMaterialBusinessBO,modalidadeBO,cadastroMaterialBO,tipoMaterialBO,MarketingLocator,suporteLocator]; root of BeanFactory hierarchy]Obrigado !
