WebObjects 4.5, Sybase and BigDecimal

Having a big problem with BigDecimals in a WebObjects application talking to Sybase. There's a few columns with the type real. WebObjects thinks real should be mapped to BigDecimal.

The problem occurrs at first when an object is fetched. Methods that should return instances of BigDecimal always return null. Browsing the table in EOModeler is a bit weird; selecting the entity - i.e. fetching all attributes - the real attributes are showing up empty; select specific attributes and the values show up. Very strange but could perhaps be dismissed as a bug in EOModeler.

The second problem occurrs when trying to save data (I've tried this from within the WebObjects application as well as from an application created from scratch with the EOF Application wizard in ProjectBuilder). The following exception is raised...thrown...whatever:

rowDiffsForAttributes:: snapshot in EODatabaseOperation 0xfa45da does not contain value for attribute named paymentRate with snapshot key: paymentRate

Note: the skeleton application created with the wizard doesn't fetch the values either. The text fields are empty just like with EOModeler.

If you have any ideas you know where to reach me.

Oh, and have a nice weekend! I'll certainly try to, but leaving for the weekend with this stuff in the back of my head can't be a good start.

Jon Udell: Talk to the hand

I can agree to some degree (hey, a rhyme!) with what Jon says about whitelists. The loss of spontaneous associations is bad. At the same time whitelisting is probably the only solution that can really stop the spam. All spam.

For this very reason my plan is setting up a whitelist scheme myself using qconfirm. It'll probably work flawlessly.

Until spammers begin replying to my confirmation requests...