Hi everybody
I've encountered a weird problem when using this configuration :
- WebObjects 5.4.2 (tried on Mac OS and Linux platforms) - Wonder 5.0 for WO 5.4 - ERPrototypes - MicrosoftPlugIn - JDBC Driver: sqljdbc4.jar - MS SQL Server 8
One entity has an attribute which uses boolean prototype.
Here are the logs:
We update an element to set it displayed: evaluateExpression: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "UPDATE Element SET displayed = ? WHERE id = ?" withBindings: 1:true(displayed), 2:66(id)>
Then, when we fetch it again: evaluateExpression: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "SELECT t0.constant, RTRIM(t0.content), t0.creation Date, t0.displayed, t0.formulaFormatterID, t0.id, RTRIM(t0.label), t0.localizedDescriptionID, t0.ordering, t0.resultUnitID, t0.spreadsheetId, RTRIM(t0.type) FROM Element t0 WHERE (t0.type = ? AND t0.id = ?)" withBindings: 1:"constant"(type), 2:66(id)> sept. 09 15:42:20 DEBUG NSLog - 1 row(s) processed sept. 09 15:42:20 DEBUG NSLog - === Commit Internal Transaction sept. 09 15:42:20 DEBUG Element - Element PopTotal is displayed: false
How can it be ?
When looking at the database using SQL editor it has not been updated. Why ? The request seems correct. Is there a problem with MicrosoftPlugIn ?
When I look in the EOJDBCSQLServerPrototypes.plist, I found:
{ adaptorValueConversionMethodName = toString; columnName = boolean; externalType = bit; factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString; name = boolean; valueClassName = "java.lang.Boolean"; valueFactoryMethodName = valueOf; width = 5; },
Is that correct ?
Can someone help me with this please ?
Best regards, Josef
|