Number to big decimal mapping problem in CMP

[Binu jose]

hi all
i am writing a CMP ,with oracle 9i as database and blazix as ejb
server. i mapped my number fields in oracle db to
java.math,BigDecimal, it compiles ok ,

when i call create with java.math.BigNumber arguement , error comes
saying
javax.ejb.FinderException: java.rmi.RemoteException: SQL Error:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00932: inconsistent
datatypes: expected NUMBER got BINARY
My code snippet follows
java.math.BigDecimal id = new java.math.BigDecimal("44.22");
try
{
// Obtain the EJB home
Properties env = new Properties();
env.put( "java.naming.factory.initial",
"desisoft.ejb.client.JRMPFactory" );
env.put( "desisoft.ejb.nameServer1",
"localhost:2050" );
Context ctx = new InitialContext( env );
temp.TempHome sitesHome = (temp.TempHome)
PortableRemoteObject.narrow( ctx.lookup( "Temp" ), temp.TempHome.class
);
temp.Temp bean = sitesHome.create(id);
System.out.println(bean.getId().toString());


TIA
Binu Jose

[Eric Olander]

The error you're getting makes perfect sense. A BigDecimal is an object,
not a number, so I can understand Oracle's complaint. How large of a value
do you need to store? Do you really need the arbitrary precision that
BigDecimal provides? If you can use one of Java's primive types (int,
long, float, double) I think you'd be better off. If not, BigDecimal does
have some conversion routines (intValue(), floatValue(), etc) that might
help.

-Eric

"Binu jose" <bn****@yahoo.com> wrote in message
news:ef**************************@posting.google.c om...

hi all
i am writing a CMP ,with oracle 9i as database and blazix as ejb
server. i mapped my number fields in oracle db to
java.math,BigDecimal, it compiles ok ,

when i call create with java.math.BigNumber arguement , error comes
saying
javax.ejb.FinderException: java.rmi.RemoteException: SQL Error:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00932: inconsistent
datatypes: expected NUMBER got BINARY
My code snippet follows
java.math.BigDecimal id = new java.math.BigDecimal("44.22");
try
{
// Obtain the EJB home
Properties env = new Properties();
env.put( "java.naming.factory.initial",
"desisoft.ejb.client.JRMPFactory" );
env.put( "desisoft.ejb.nameServer1",
"localhost:2050" );
Context ctx = new InitialContext( env );
temp.TempHome sitesHome = (temp.TempHome)
PortableRemoteObject.narrow( ctx.lookup( "Temp" ), temp.TempHome.class
);
temp.Temp bean = sitesHome.create(id);
System.out.println(bean.getId().toString());


TIA
Binu Jose