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