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: David Avendasora <email@hidden>
- Date: Tue, 22 Sep 2009 10:39:31 -0400
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