On Sep 22, 2009, at 11:29 AM, Freddie Tilley wrote:

Value class of type NSNumber does not work for me, using a value class
of java.lang.Boolean does.

What are the results if you use NSNumber? You could also try "Number" or "java.lang.Number"

I'm suspicious of the Boolean setting...

Dave


Thanks!

2009/9/22 David Avendasora <webobje...@avendasora.com>:
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 <webobje...@avendasora.com>:

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 <webobje...@avendasora.com>:

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      (Webobjects-dev@lists.apple.com)

Help/Unsubscribe/Update your Subscription:


http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to webobje...@avendasora.com




_______________________________________________

Do not post admin requests to the list. They will be ignored.

Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)

Help/Unsubscribe/Update your Subscription:

http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to webobje...@avendasora.com




_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to webobje...@avendasora.com




_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com

This email sent to webobje...@avendasora.com



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to