Sven,
This file attached has the XML mapping and the java code. I try to
user hashMap and the parameterClass (FaixaLimite) and both didn´t
work.
The release that I´m using is 2.0.6.
tks
On 8/24/05, Sven Boden <[EMAIL PROTECTED]> wrote:
>
> Renato,
>
> You're not giving much to work with... which version of iBATIS do you
> use? Can you possibly upgrade to 2.1.5. and try that. Can you supply
> the piece of java code you use + your maps.
>
> Regards,
> Sven
>
>
> On Wed, 24 Aug 2005 15:34:00 -0300, you wrote:
>
> >Sven,
> >
> >The first one is not because the insert made using sqlplus is working fine.
> >
> >I´m passing the float value using the Float wrapper. And it´s not
> >working. Do you think that this problem have anything to do with a old
> >version of Ibatis, because in this project we are using an old one?
> >
> >tks.
> >
> >
> >
> >
> >On 8/24/05, Sven Boden <[EMAIL PROTECTED]> wrote:
> >>
> >> Usually it's one of 2:
> >>
> >> - check your table definition in Oracle whether the column you insert
> >> to can contain a decimal part. Try to insert a decimal value via
> >> SQL*Plus e.g. ... if that doesn't work that's the error.
> >>
> >> - Maybe you're using Integers to pass parameters to iBATIS which would
> >> cut your decimal part, but that would require some more information
> >> from you: maps, pieces of java code.
> >>
> >> Regards,
> >> Sven
> >>
> >> On Wed, 24 Aug 2005 15:19:20 -0300, you wrote:
> >>
> >> >I´m trying to insert some decimal values in a table at oracle
> >> >database. But the decimal part of the value is not recorded.
> >> >
> >> >Like if try to record 325.34 the value that is recorded is 325 only
> >> >the integer part. How can i solve this problem?
> >> >
> >> >
> >> >tks
> >>
> >>
>
>
###XML
<parameterMap id="parametrosFaixaLimiteCampanha" class="FaixaLimite">
<parameter property="codigoCampanha" jdbcType="NUMBER" javaType="int" />
<parameter property="valorLimiteSuperiorFaixa" jdbcType="FLOAT"
javaType="float" />
<parameter property="numeroAkatuzinhos" jdbcType="NUMBER" javaType="int" />
</parameterMap>
<insert id="inserirFaixaLimiteCampanha"
parameterMap="parametrosFaixaLimiteCampanha">INSERT INTO
TBAKFAIXALIMITECAMPANHA (CODCAMPANHA, VALORLIMITE, NUMESTRELAS) VALUES
(?,?,?)</insert>
###Java Code
public void inserirFaixaLimiteCampanha(int codCampanha,
float valorLimiteSuperior, int numeroAkatuzinhos)
throws DaoException {
FaixaLimiteCampanha faixa = new FaixaLimiteCampanha();
faixa.setCodigoCampanha(codCampanha);
faixa.setValorLimiteSuperiorFaixa(valorLimiteSuperior);
faixa.setNumeroAkatuzinhos(numeroAkatuzinhos);
/*
* HashMap map = new HashMap(); map.put("codigoCampanha", new
* Integer(codCampanha)); map.put("valorLimite", new
* Float(valorLimiteSuperior)); map.put("numEstrelas", new
* Integer(numeroAkatuzinhos));
*/
insert("inserirFaixaLimiteCampanha", faixa);
}
