Friday, December 13 2002

I should have written WebObjects 4.5, Sybase and real as the title of my last post. I don't think WebObjects has any problems handling BigDecimals. Sorry for that.

Anyway, the solution to the problem was simply to avoid real. For some reason reals aren't handled very well by EOF, at least not in our WebObjects 4.5 setup.

I got help setting up a proxy between the WO application and the database logging every single byte sent over the network, and the reals sent back to the application in response to a SQL query appeared to be ok. This has got to be some strangeness in the EOF Sybase adaptor.

After this finding we changed the reals to floats and the problem was gone.