Number to big decimal mapping problem in ejb

[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