If you really want to use bit as the datatype in SQL Server, here's how I did
it:
External Type: bit
Value Class NSNumber
Value Type c
And that turned 0 and 1 in the database into false and true in the Java.
Dave
On Sep 9, 2010, at 11:04 AM, Chuck Hill wrote:
>
> On Sep 9, 2010, at 6:52 AM, Josef Vanek wrote:
>
>> 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;
>
> externalType should be varchar, it is storing "true" and "false" (see width =
> 5 below).
>
>
>> 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
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>
>> This email sent to [email protected]
>
> --
> Chuck Hill Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase their overall
> knowledge of WebObjects or who are trying to solve specific problems.
> http://www.global-village.net/products/practical_webobjects
>
>
>
>
>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
