Re: WebObjects 5.4.3 and SQL Server 2005
2009/9/23 David Avendasora : > > 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... When using a java.lang.Number I get a class cast exception, integer cannot be cast to java.lang.Boolean <> ___ 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
Re: WebObjects 5.4.3 and SQL Server 2005
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 : 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 : 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 : 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
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 7:36 PM, Chuck Hill wrote: Not sure why that works and not inclined to dig into it right now. Chuck According to the 'legacy' docs, that's the way it's supposed to work. That seems odd as Boolean is not a Number. There is trickery there in EOF. David, your modeling skills should be safe from Chuck's snide comments... for now (^_^) Well lookie there! When you use a Value Class of java.lang.Number, "c" means Boolean. (c—java.lang.Boolean) I am obviously a far superior modeler/coder than I even realized! I am unlikely to allow simple facts to stand in my way. ;-) Why start now. :-P Dave ___ 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
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 4:27 PM, Ramsey Lee Gurley wrote: On Sep 22, 2009, at 2:05 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:57 AM, David Avendasora wrote: On Sep 22, 2009, at 12:19 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: 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. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but it's working for me. Okay, Chuck, here's where you put your snide comment about my Modeling skills. :-P One cannot comment on what does not exist. :-P I'd want to see screen shots of each to be sure we are all talking about the same thing. Here's my custom Prototype: Here's my attribute that implements the Boolean prototype: Not sure why that works and not inclined to dig into it right now. Chuck According to the 'legacy' docs, that's the way it's supposed to work. That seems odd as Boolean is not a Number. There is trickery there in EOF. David, your modeling skills should be safe from Chuck's snide comments... for now (^_^) I am unlikely to allow simple facts to stand in my way. ;-) Chuck http://developer.apple.com/legacy/mac/library/documentation/WebObjects/UsingEOModeler/4WorkingWithAttributes/WorkingWithAttributes.html#/ /apple_ref/doc/uid/TP30001018-CH204-BABFGECE Ramsey ___ 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/chill%40global-village.net This email sent to ch...@global-village.net -- 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 (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
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 2:05 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:57 AM, David Avendasora wrote: On Sep 22, 2009, at 12:19 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: 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. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but it's working for me. Okay, Chuck, here's where you put your snide comment about my Modeling skills. :-P One cannot comment on what does not exist. :-P I'd want to see screen shots of each to be sure we are all talking about the same thing. Here's my custom Prototype: Here's my attribute that implements the Boolean prototype: Not sure why that works and not inclined to dig into it right now. Chuck According to the 'legacy' docs, that's the way it's supposed to work. David, your modeling skills should be safe from Chuck's snide comments... for now (^_^) http://developer.apple.com/legacy/mac/library/documentation/WebObjects/UsingEOModeler/4WorkingWithAttributes/WorkingWithAttributes.html#//apple_ref/doc/uid/TP30001018-CH204-BABFGECE Ramsey smime.p7s Description: S/MIME cryptographic signature ___ 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
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 2:05 PM, Chuck Hill wrote: Here's my custom Prototype: Here's my attribute that implements the Boolean prototype: Not sure why that works and not inclined to dig into it right now. Agreed. Dave ___ 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
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 9:57 AM, David Avendasora wrote: On Sep 22, 2009, at 12:19 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: 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. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but it's working for me. Okay, Chuck, here's where you put your snide comment about my Modeling skills. :-P One cannot comment on what does not exist. :-P I'd want to see screen shots of each to be sure we are all talking about the same thing. Here's my custom Prototype: Here's my attribute that implements the Boolean prototype: Not sure why that works and not inclined to dig into it right now. Chuck 2009/9/22 David Avendasora : 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 : 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 : 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/chill%40global-village.net This email sent to ch...@global-village.net -- 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 -- Chuck Hi
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: 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. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but it's working for me. Okay, Chuck, here's where you put your snide comment about my Modeling skills. :-P One cannot comment on what does not exist. :-P I'd want to see screen shots of each to be sure we are all talking about the same thing. Chuck 2009/9/22 David Avendasora : 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 : 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 : 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/chill%40global-village.net This email sent to ch...@global-village.net -- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archi
Re: WebObjects 5.4.3 and SQL Server 2005
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. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but it's working for me. Okay, Chuck, here's where you put your snide comment about my Modeling skills. :-P Dave Thanks! 2009/9/22 David Avendasora : 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 : 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 : 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
Re: WebObjects 5.4.3 and SQL Server 2005
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 : > 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 : > > 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 : > > 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/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.4.3 and SQL Server 2005
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 : 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 : 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/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.4.3 and SQL Server 2005
This will give me class cast errors java.lang.Short cannot be cast to java.lang.Boolean 2009/9/22 David Avendasora : > 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 : >>> >>> 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/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.4.3 and SQL Server 2005
On Sep 22, 2009, at 10:39 AM, David Avendasora wrote: I think there is a bug in Entity Modeler that doesn't properly update the external type when changing to "intBoolean". And yes, I'll finally create a Jira ticket for this. :-) Dave ___ 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
Re: WebObjects 5.4.3 and SQL Server 2005
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 : 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/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WebObjects 5.4.3 and SQL Server 2005
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 : > 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/archive%40mail-archive.com This email sent to arch...@mail-archive.com
WebObjects 5.4.3 and SQL Server 2005
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/archive%40mail-archive.com This email sent to arch...@mail-archive.com