Re: WebObjects 5.4.3 and SQL Server 2005
Re: WebObjects 5.4.3 and SQL Server 2005
- Subject: Re: WebObjects 5.4.3 and SQL Server 2005
- From: Freddie Tilley <email@hidden>
- Date: Tue, 22 Sep 2009 17:29:46 +0200
Value class of type NSNumber does not work for me, using a value class
of java.lang.Boolean does.
Thanks!
2009/9/22 David Avendasora <email@hidden>:
> Okay, let's try it completely manually.
> Here's what I have setup in one of my custom Prototypes for MS SQL Server:
> External Type: bit
> Class: java.lang.Boolean
> Data Type: Custom - Custom
> External Width:
> Value Class: NSNumber
> Value Type: c
> Factory Method:
> ConversionMethod:
> Init Argument:
> These settings work for me in a current project that talks to a SQL Server
> 2000 DB.
> Dave
>
> On Sep 22, 2009, at 11:01 AM, Freddie Tilley wrote:
>
> This will give me class cast errors
>
> java.lang.Short cannot be cast to java.lang.Boolean
>
>
> 2009/9/22 David Avendasora <email@hidden>:
>
> That prototype doesn't do what you think it does. That will convert the
>
> boolean value true to the string "true" and and false to "false" which
>
> obviously won't save into a bit column.
>
> Look at the intBoolean Wonder prototype. You may need to set the Prototype
>
> to "intNumber" first, and then to "intBoolean" to get it to work as I think
>
> there is a bug in Entity Modeler that doesn't properly update the external
>
> type when changing to "intBoolean".
>
> Dave
>
> On Sep 22, 2009, at 10:25 AM, Freddie Tilley wrote:
>
> the EOJDBCSQLServerPrototypes boolean type defaults to bit with a
>
> custom data type as follows:
>
> External Width: 5
>
> Value Class: java.lang.Boolean
>
> Value type: c
>
> Factory Method: valueOf
>
> Conversion Method: toString
>
> Init Argument: String
>
> 2009/9/22 David Avendasora <email@hidden>:
>
> Hi Freddie,
>
> I don't believe Microsoft SQL Server has a boolean datatype. What
>
> datatype
>
> are you using for the column in the DB?
>
> Dave
>
>
> On Sep 22, 2009, at 7:32 AM, Freddie Tilley wrote:
>
> I have a problem with writing a boolean value to the database, using
>
> the EOJDBCSQLServerPrototypes and the boolean type. I'm also
>
> using Chuck Hills MicrosoftPlugin.
>
> If I set the boolean to true when creating an object it actually sets
>
> this value in the db when saving.
>
> But if I edit the object again and set the boolean value to false. It
>
> will show the value as false in the list, but it will remain True
>
> in the database. And after this I cannot change the value to True
>
> anymore.
>
> What's going on here?
>
> Freddie Tilley
>
> _______________________________________________
>
> Do not post admin requests to the list. They will be ignored.
>
> Webobjects-dev mailing list (email@hidden)
>
> Help/Unsubscribe/Update your Subscription:
>
>
>
> This email sent to email@hidden
>
>
>
>
> _______________________________________________
>
> Do not post admin requests to the list. They will be ignored.
>
> Webobjects-dev mailing list (email@hidden)
>
> Help/Unsubscribe/Update your Subscription:
>
>
> This email sent to email@hidden
>
>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden