This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hello everyone, I am currently working which involves an ecommerce system. The database is MS SQL server 2000 and I am using the MS provided driver. The application runs on Orion Application Server. I have a container managed OrderLine entity. I've tried the following primary keys for this entity: Float orderNumber Float lineNumber and BigDecimal orderNumber BigDecimal lineNumber In the DB schema, these are defined as type float. The DB supports the iMIS enterprise management system, so I can't change it (though I'd like to.) I'm trying to insert floating point values into the lineNumber field. Before the insert takes place, my program logs the proper values (1.01, 1.02, 1.03... .) However, in the database the values end up distorted: (1.00999999046326, 1.01999998092651, 1.02999997138977 ... .) This occurs whether I define the bean with Float fields or BigDecimal fields. Has anyone else encountered this problem? Is there a solution other than changing the schema to use decimal instead of float? Any help appreciated, Matt
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com