Re: PHP Customer Request
That is a great presentation for anyone doing contract or consulting work. I wish I had seen it 12 years ago. Chuck On 2011-04-14, at 10:57 PM, Q wrote: > > On 08/04/2011, at 4:23 AM, Dov Rosenberg wrote: > >> This says a lot about the customer in general. If his primary motivation for >> going with PHP is cheap hosting - he is going to be a pain in the ass when >> it comes to payment and functionality. These kind of people want the moon >> for the price of a trip around the block. > > http://vimeo.com/22053820 > >> When I first started in this business nearly 20 years ago - I came across a >> bunch of these guys - nearly killed me >> >> Dov >> >> >> On 4/7/11 9:38 AM, "Dov Rosenberg" wrote: >> >>> It is a lot cheaper to host a php site - the cheapest GoDaddy hosting plan >>> for $5/mon includes PHP and mysql. >>> >>> Dov >>> >>> >>> On 4/7/11 8:55 AM, "Chuck Hill" wrote: >>> The place to start is to understand why your customer wants (or thinks that he wants) a site specifically in PHP. Maybe he has a valid reason. Maybe he thinks that PHP brings some benefit that other technologies don't. In that case, focus on the technical and business needs and then help him to select a technology based on that. Chuck On Apr 7, 2011, at 8:41 AM, Amedeo Mantica wrote: > Hello all, > > Generic question, how do you promote Java/WebObjects technology to > customers > ? > > A customer today asked me for a PHP/MySQ WebSite/WebApp. That was a > specific > request., he doesn't want a dynamic WebSite, he wants a php based website. > > Suggestions ? > > Amed > > ___ > 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 >>> >>> ___ >>> 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/drosenberg%40inquira.com >>> >>> This email sent to drosenb...@inquira.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/qdolan%40gmail.com >> >> This email sent to qdo...@gmail.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: PHP Customer Request
On 08/04/2011, at 4:23 AM, Dov Rosenberg wrote: > This says a lot about the customer in general. If his primary motivation for > going with PHP is cheap hosting - he is going to be a pain in the ass when > it comes to payment and functionality. These kind of people want the moon > for the price of a trip around the block. http://vimeo.com/22053820 > When I first started in this business nearly 20 years ago - I came across a > bunch of these guys - nearly killed me > > Dov > > > On 4/7/11 9:38 AM, "Dov Rosenberg" wrote: > >> It is a lot cheaper to host a php site - the cheapest GoDaddy hosting plan >> for $5/mon includes PHP and mysql. >> >> Dov >> >> >> On 4/7/11 8:55 AM, "Chuck Hill" wrote: >> >>> The place to start is to understand why your customer wants (or thinks that >>> he >>> wants) a site specifically in PHP. Maybe he has a valid reason. Maybe he >>> thinks that PHP brings some benefit that other technologies don't. In that >>> case, focus on the technical and business needs and then help him to select >>> a >>> technology based on that. >>> >>> >>> Chuck >>> >>> >>> On Apr 7, 2011, at 8:41 AM, Amedeo Mantica wrote: >>> Hello all, Generic question, how do you promote Java/WebObjects technology to customers ? A customer today asked me for a PHP/MySQ WebSite/WebApp. That was a specific request., he doesn't want a dynamic WebSite, he wants a php based website. Suggestions ? Amed ___ 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 >> >> ___ >> 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/drosenberg%40inquira.com >> >> This email sent to drosenb...@inquira.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/qdolan%40gmail.com > > This email sent to qdo...@gmail.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
Sessions and resources
During debugging of other things, I overrode dispatchRequest() in my
Application class.
Oddly, there is a session ID associated with every /wr/ request for resources.
dispatchRequest(): session: t73fX3HunlN1WUbxfbUB5g
Apr 14 22:11:44 RSNews[] DEBUG com.eldrix.news.app.Application -
uri:
/cgi-bin/WebObjects/RSNews.woa/-/wr/wodata=/Users/mark/Dev/eclipse/rsdb/Applications/RSNews/build/RSNews.woa/Contents/WebServerResources/images/unknown_user.jpg
Apr 14 22:11:44 RSNews[] DEBUG com.eldrix.news.app.Application -
form values = {}
My own session() constructor is not called.
Is this normal behaviour for requests to the /wr/ handler?
I am using Wonder.
Mark
--
Dr. Mark Wardle
Specialist registrar, Neurology
Cardiff, UK
___
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, just-in-time login and SSL
Hi there. I now have a [almost] working system that checks a system property and conditionally forces the use of https for relevant resources. There is some hostname flakiness going on which messes with cookies (switching between localhost and Daisy.local) which is odd. The main reason why the hostname keeps getting changed in my use of ERXNavigationMenu and specifically the way it generates URLs for direct actions. These seem to insist on being full URLs (and hence change the hostname) although this somewhat depends on whether I'm switch from storing sessions in a cookie or URL. Whatever the case, despite the navigation buttons being rendered on a https page, the link goes to http:// I note any component actions simply use a relative URL and stay as https:// and exhibit no hostname flakiness. I'm ready the relevant wiki pages on SSL and specifically setting the hostname to localhost specifically in all the relevant configuration files. My naive assessment of this is that within ERXNavigationMenuItem.contextComponentActionURL() should be fixed to default to the current setup: change return context().directActionURLForActionNamed(navigationItem().directActionName(), bindings); to return context().directActionURLForActionNamed(navigationItem().directActionName(), bindings, ERXRequest.isRequestSecure(context().request()), false); Or is this wrong? Many thanks, Mark -- Dr. Mark Wardle Specialist registrar, Neurology Cardiff, UK ___ 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: EOGeneralAdaptorException: EvaluateExpression
CREATE TABLE `notification` ( `notification_id` bigint(20) unsigned default '0', `text_contents` varchar(4096) default '', `create_date` datetime default NULL, `notification_type_id` int(11) default '1', `application_id` int(11) default NULL, `minutes_to_expire` int(11) default NULL, `story_guid` varchar(100) default NULL, `not_identifier` varchar(100) default NULL, `modify_date` datetime default NULL, `active` int(11) default '1', `pushed` int(11) default '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 But that is of course, after I re-set the storyGuid to varchar after it was somehow changed to int. So that problem is solved. The other one, remains. (see: RE: intBoolean) On Apr 14, 2011, at 4:58 PM, Kieran Kelleher wrote: > What is the output from the following statement in your mysql database: > > SHOW CREATE TABLE NOTIFICATION; > > > > On Apr 14, 2011, at 4:03 PM, Andrew Kinnie wrote: > >> Well, today is just doing a bang-up job of making me question my profession. >> >> In attempting to ensure that my version of WO and Wonder were in agreement >> with the server, I got the latest wonder from git, installed it per the >> instructions on the wiki, and now my app won't run on the development >> machine with a completely different error on save changes. >> >> EOGeneralAdaptorException: EvaluateExpression failed: >> > NOTIFICATION(notification_type_id, not_identifier, pushed, active, >> text_contents, modify_date, minutes_to_expire, create_date, application_id, >> story_guid, notification_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" >> withBindings: 1:2(notificationTypeID), 2:"42"(notificationIdentifier), >> 3:true(pushed), 4:true(active), 5:"Yadda Yadda"(textContents), 6:2011-04-14 >> 15:54:31(modifyDate), 7:23(minutesToExpire), 8:2011-04-14 >> 15:54:31(createDate), 9:1(applicationId), 10:"ljkdfgs"(storyGuid), >> 11:42(notification_Id)>: >> Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect >> integer value: 'ljkdfgs' for column 'story_guid' at row 1 >> at >> com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) >> ... skipped 1 stack elements >> at >> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) >> at >> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) >> >> The database is the same (storyGuid is a varchar 100), the model is the same >> (storyGuid is a string -> varchar 100). I have regenerated. Somehow, for >> no reason I understand, EOF has decided it is an int. So if I pass in text, >> I get this crash. The IT guy hasn't come back yet, so I didn't check >> anything on the server (other than the db itself, to ensure that is a >> varchar 100). >> >> Any ideas on this? >> >> Andrew >> ___ >> 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/kelleherk%40gmail.com >> >> This email sent to kelleh...@gmail.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: EOGeneralAdaptorException: EvaluateExpression -SOLVED
Yeah, I did check that. It was a varchar100. Of course since the 25th time I looked at it to make sure, this time I looked again after I quit Sequel Pro and restarted it, and discovered that it apparently changed to an int. I need about 14 beers. Sooo... that part works now. Of course, it worked fine before too, but it works again. Thanks for telling me to again do the obvious thing I literally did 25 times before. 26 times in the charm I guess. :-/ Well, at least I got reached my monthly quota of feeling like an idiot. :-) Andrew On Apr 14, 2011, at 4:48 PM, Henrique Gomes wrote: > > On Apr 14, 2011, at 9:30 PM, Andrew Kinnie wrote: > Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect integer value: 'ljkdfgs' for column 'story_guid' at row 1 > > I don't use mySQL but if that message comes from the db then it really looks > like the database field is an int. I would double check that. > > Henrique Gomes ___ 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: EOGeneralAdaptorException: EvaluateExpression
What is the output from the following statement in your mysql database: SHOW CREATE TABLE NOTIFICATION; On Apr 14, 2011, at 4:03 PM, Andrew Kinnie wrote: > Well, today is just doing a bang-up job of making me question my profession. > > In attempting to ensure that my version of WO and Wonder were in agreement > with the server, I got the latest wonder from git, installed it per the > instructions on the wiki, and now my app won't run on the development machine > with a completely different error on save changes. > > EOGeneralAdaptorException: EvaluateExpression failed: > NOTIFICATION(notification_type_id, not_identifier, pushed, active, > text_contents, modify_date, minutes_to_expire, create_date, application_id, > story_guid, notification_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" > withBindings: 1:2(notificationTypeID), 2:"42"(notificationIdentifier), > 3:true(pushed), 4:true(active), 5:"Yadda Yadda"(textContents), 6:2011-04-14 > 15:54:31(modifyDate), 7:23(minutesToExpire), 8:2011-04-14 > 15:54:31(createDate), 9:1(applicationId), 10:"ljkdfgs"(storyGuid), > 11:42(notification_Id)>: > Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect > integer value: 'ljkdfgs' for column 'story_guid' at row 1 > at > com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) > ... skipped 1 stack elements > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) > at > com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) > > The database is the same (storyGuid is a varchar 100), the model is the same > (storyGuid is a string -> varchar 100). I have regenerated. Somehow, for no > reason I understand, EOF has decided it is an int. So if I pass in text, I > get this crash. The IT guy hasn't come back yet, so I didn't check anything > on the server (other than the db itself, to ensure that is a varchar 100). > > Any ideas on this? > > Andrew > ___ > 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/kelleherk%40gmail.com > > This email sent to kelleh...@gmail.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: EOGeneralAdaptorException: EvaluateExpression
On Apr 14, 2011, at 9:30 PM, Andrew Kinnie wrote: >>> Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect >>> integer value: 'ljkdfgs' for column 'story_guid' at row 1 I don't use mySQL but if that message comes from the db then it really looks like the database field is an int. I would double check that. Henrique Gomes ___ 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: EOGeneralAdaptorException: EvaluateExpression
Well I deleted my entire wonder source folder and downloaded it fresh from git. I checked the classpath, and it was in the project but not in the framework, so I added it there too. Didn't help. ERPrototypes is also included. On Apr 14, 2011, at 4:16 PM, David LeBer wrote: > Hey Andrew, > > Wonder's MySQLPlugin is up-to-date and included in your project? > > On 2011-04-14, at 4:03 PM, Andrew Kinnie wrote: > >> Well, today is just doing a bang-up job of making me question my profession. >> >> In attempting to ensure that my version of WO and Wonder were in agreement >> with the server, I got the latest wonder from git, installed it per the >> instructions on the wiki, and now my app won't run on the development >> machine with a completely different error on save changes. >> >> EOGeneralAdaptorException: EvaluateExpression failed: >> > NOTIFICATION(notification_type_id, not_identifier, pushed, active, >> text_contents, modify_date, minutes_to_expire, create_date, application_id, >> story_guid, notification_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" >> withBindings: 1:2(notificationTypeID), 2:"42"(notificationIdentifier), >> 3:true(pushed), 4:true(active), 5:"Yadda Yadda"(textContents), 6:2011-04-14 >> 15:54:31(modifyDate), 7:23(minutesToExpire), 8:2011-04-14 >> 15:54:31(createDate), 9:1(applicationId), 10:"ljkdfgs"(storyGuid), >> 11:42(notification_Id)>: >>Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect >> integer value: 'ljkdfgs' for column 'story_guid' at row 1 >> at >> com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) >> ... skipped 1 stack elements >> at >> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) >> at >> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) >> >> The database is the same (storyGuid is a varchar 100), the model is the same >> (storyGuid is a string -> varchar 100). I have regenerated. Somehow, for >> no reason I understand, EOF has decided it is an int. So if I pass in text, >> I get this crash. The IT guy hasn't come back yet, so I didn't check >> anything on the server (other than the db itself, to ensure that is a >> varchar 100). >> >> Any ideas on this? >> >> Andrew >> ___ >> 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/dleber_wodev%40codeferous.com >> >> This email sent to dleber_wo...@codeferous.com > > ;david > > -- > David LeBer > Codeferous Software > 'co-def-er-ous' adj. Literally 'code-bearing' > site: http://codeferous.com > blog: http://davidleber.net > profile: http://www.linkedin.com/in/davidleber > twitter: http://twitter.com/rebeld > -- > Toronto Area Cocoa / WebObjects developers group: > http://tacow.org > > > > ___ 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: EOGeneralAdaptorException: EvaluateExpression
Hey Andrew, Wonder's MySQLPlugin is up-to-date and included in your project? On 2011-04-14, at 4:03 PM, Andrew Kinnie wrote: > Well, today is just doing a bang-up job of making me question my profession. > > In attempting to ensure that my version of WO and Wonder were in agreement > with the server, I got the latest wonder from git, installed it per the > instructions on the wiki, and now my app won't run on the development machine > with a completely different error on save changes. > > EOGeneralAdaptorException: EvaluateExpression failed: > NOTIFICATION(notification_type_id, not_identifier, pushed, active, > text_contents, modify_date, minutes_to_expire, create_date, application_id, > story_guid, notification_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" > withBindings: 1:2(notificationTypeID), 2:"42"(notificationIdentifier), > 3:true(pushed), 4:true(active), 5:"Yadda Yadda"(textContents), 6:2011-04-14 > 15:54:31(modifyDate), 7:23(minutesToExpire), 8:2011-04-14 > 15:54:31(createDate), 9:1(applicationId), 10:"ljkdfgs"(storyGuid), > 11:42(notification_Id)>: > Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect > integer value: 'ljkdfgs' for column 'story_guid' at row 1 > at > com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) > ... skipped 1 stack elements > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) > at > com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) > > The database is the same (storyGuid is a varchar 100), the model is the same > (storyGuid is a string -> varchar 100). I have regenerated. Somehow, for no > reason I understand, EOF has decided it is an int. So if I pass in text, I > get this crash. The IT guy hasn't come back yet, so I didn't check anything > on the server (other than the db itself, to ensure that is a varchar 100). > > Any ideas on this? > > Andrew > ___ > 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/dleber_wodev%40codeferous.com > > This email sent to dleber_wo...@codeferous.com ;david -- David LeBer Codeferous Software 'co-def-er-ous' adj. Literally 'code-bearing' site: http://codeferous.com blog: http://davidleber.net profile:http://www.linkedin.com/in/davidleber twitter:http://twitter.com/rebeld -- Toronto Area Cocoa / WebObjects developers group: http://tacow.org ___ 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: EOGeneralAdaptorException: EvaluateExpression
Long shot... make sure you have ERPrototypes on your classpath. Ramsey On Apr 14, 2011, at 1:03 PM, Andrew Kinnie wrote: > Well, today is just doing a bang-up job of making me question my profession. > > In attempting to ensure that my version of WO and Wonder were in agreement > with the server, I got the latest wonder from git, installed it per the > instructions on the wiki, and now my app won't run on the development machine > with a completely different error on save changes. > > EOGeneralAdaptorException: EvaluateExpression failed: > NOTIFICATION(notification_type_id, not_identifier, pushed, active, > text_contents, modify_date, minutes_to_expire, create_date, application_id, > story_guid, notification_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" > withBindings: 1:2(notificationTypeID), 2:"42"(notificationIdentifier), > 3:true(pushed), 4:true(active), 5:"Yadda Yadda"(textContents), 6:2011-04-14 > 15:54:31(modifyDate), 7:23(minutesToExpire), 8:2011-04-14 > 15:54:31(createDate), 9:1(applicationId), 10:"ljkdfgs"(storyGuid), > 11:42(notification_Id)>: > Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect > integer value: 'ljkdfgs' for column 'story_guid' at row 1 > at > com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) > ... skipped 1 stack elements > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) > at > com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) > > The database is the same (storyGuid is a varchar 100), the model is the same > (storyGuid is a string -> varchar 100). I have regenerated. Somehow, for no > reason I understand, EOF has decided it is an int. So if I pass in text, I > get this crash. The IT guy hasn't come back yet, so I didn't check anything > on the server (other than the db itself, to ensure that is a varchar 100). > > Any ideas on this? > > Andrew > ___ > 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/rgurley%40smarthealth.com > > This email sent to rgur...@smarthealth.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
EOGeneralAdaptorException: EvaluateExpression
Well, today is just doing a bang-up job of making me question my profession. In attempting to ensure that my version of WO and Wonder were in agreement with the server, I got the latest wonder from git, installed it per the instructions on the wiki, and now my app won't run on the development machine with a completely different error on save changes. EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect integer value: 'ljkdfgs' for column 'story_guid' at row 1 at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) ... skipped 1 stack elements at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) The database is the same (storyGuid is a varchar 100), the model is the same (storyGuid is a string -> varchar 100). I have regenerated. Somehow, for no reason I understand, EOF has decided it is an int. So if I pass in text, I get this crash. The IT guy hasn't come back yet, so I didn't check anything on the server (other than the db itself, to ensure that is a varchar 100). Any ideas on this? Andrew ___ 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: Reminder: Contributing to Project Wonder webcast
Thanks to everyone who attended, and the recording will be available in the couple of days. > Good morning everyone, > > Just a friendly reminder about the "Contributing to Project Wonder" webcast > this morning (well, morning in America/Montreal timezone). You can register > at http://bit.ly/i2895R > > Thanks. ___ > 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/probert%40macti.ca > > This email sent to prob...@macti.ca ___ 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: intBoolean
What is different between your dev and deploy? Different WO version? java
version? MySQL version? MySQL JDBC driver version? Something must be different
and that might lead you to the problem.
Regards, Kieran
PS.
I have no problem with intBoolean or the other String boolean with Dev on OS X
and deploy on Linux using WO 5.3.3 and embedded everything ( including the
mysql jdbc driver), and /Library/WebObjects/Extensions is empty on every dev
box and server, and nothing related to WO in Java Extensions either.
Also my preferred definition nowadays is to use an enum in MySQL with the
Boolean from/to String prototype. This 2-value ENUM has storage of only 1 byte.
`isActive` ENUM('false','true') DEFAULT 'false'
http://dev.mysql.com/doc/refman/5.1/en/constraint-enum.html
On Apr 14, 2011, at 1:09 PM, Andrew Kinnie wrote:
> OK, still no luck.
>
> I have one column in the table which is called "active" and is an int
> (precision of 11) and default of 1. This is modeled as an intBoolean and
> works fine
> I have another column in the same table which is called "pushed" and is an
> int with a precision of 11 and a default of 1. It is also modeled as an
> intBoolean, and works fine with the app running on the development machine
> but fails on the server with the rest error referred to before.
>
> I deleted the column and the model attribute and the table and entity work
> fine. I recreated them, same problem
> I did it again and recreated them as intNumber and got the Integer version of
> the same error as a response from rest.
>
> com.MyCommon.eos.MyEntity.pushed()Ljava/lang/Integer;.
>
> I removed the prototype (and set the external value as int and class to
> integer) and get the same error. I cleaned and repeated, no effect. I have
> redeployed dozens of times (because as I mentioned it works fine on the dev
> box), no luck.
>
> I am completely at a loss. I suppose we could just delete the column and
> give up on the feature that this was supposed to represent, but that seems
> like a highly questionable solution.
>
> Andrew
>
> On Apr 14, 2011, at 11:45 AM, webobjects-dev-requ...@lists.apple.com wrote:
>
>> Date: Thu, 14 Apr 2011 11:43:55 -0400
>> From: Andrew Kinnie
>> Subject: intBoolean
>> To: WebObjects-Dev List
>> Message-ID:
>> Content-Type: text/plain; charset="us-ascii"
>>
>> I have an app tied to a model which has an entity with an intBoolean
>> attribute.
>>
>> The database is MySQL. My dev machine connects to the save database as the
>> app does deployed for testing.
>>
>> I have an ERRest interface which has an action method which sets the
>> variable if it is not passed into the request. This works fine on the dev
>> machine. However, the same app, deployed onto the server, talking to the
>> same database returns this:
>>
>> "com.MyCommon.eos.MyEntity.notPushed()Ljava/lang/Boolean;"
>>
>> Equally fascinating, I have several other entities with other intBoolean
>> variables which work perfectly fine. No error. I have another intBoolean
>> variable in this very table which works fine. I deleted the column and
>> re-created it. Same problem. I renamed it. Same problem.
>>
>> Anyone have any idea what this is?
>>
>> Andrew Kinnie
>>
>> PS: I am running wonder from the end of last week, and I have all the
>> frameworks bundled into the tarball, and have checked the box (that I never
>> before knew existed) under the Order and Export tab (that I never before
>> knew existed) of the common framework's properties Java Build Path:
>
> ___
> 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/kelleherk%40gmail.com
>
> This email sent to kelleh...@gmail.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: intBoolean
OK, still no luck. I have one column in the table which is called "active" and is an int (precision of 11) and default of 1. This is modeled as an intBoolean and works fine I have another column in the same table which is called "pushed" and is an int with a precision of 11 and a default of 1. It is also modeled as an intBoolean, and works fine with the app running on the development machine but fails on the server with the rest error referred to before. I deleted the column and the model attribute and the table and entity work fine. I recreated them, same problem I did it again and recreated them as intNumber and got the Integer version of the same error as a response from rest. com.MyCommon.eos.MyEntity.pushed()Ljava/lang/Integer;. I removed the prototype (and set the external value as int and class to integer) and get the same error. I cleaned and repeated, no effect. I have redeployed dozens of times (because as I mentioned it works fine on the dev box), no luck. I am completely at a loss. I suppose we could just delete the column and give up on the feature that this was supposed to represent, but that seems like a highly questionable solution. Andrew On Apr 14, 2011, at 11:45 AM, webobjects-dev-requ...@lists.apple.com wrote: > Date: Thu, 14 Apr 2011 11:43:55 -0400 > From: Andrew Kinnie > Subject: intBoolean > To: WebObjects-Dev List > Message-ID: > Content-Type: text/plain; charset="us-ascii" > > I have an app tied to a model which has an entity with an intBoolean > attribute. > > The database is MySQL. My dev machine connects to the save database as the > app does deployed for testing. > > I have an ERRest interface which has an action method which sets the variable > if it is not passed into the request. This works fine on the dev machine. > However, the same app, deployed onto the server, talking to the same database > returns this: > > "com.MyCommon.eos.MyEntity.notPushed()Ljava/lang/Boolean;" > > Equally fascinating, I have several other entities with other intBoolean > variables which work perfectly fine. No error. I have another intBoolean > variable in this very table which works fine. I deleted the column and > re-created it. Same problem. I renamed it. Same problem. > > Anyone have any idea what this is? > > Andrew Kinnie > > PS: I am running wonder from the end of last week, and I have all the > frameworks bundled into the tarball, and have checked the box (that I never > before knew existed) under the Order and Export tab (that I never before knew > existed) of the common framework's properties Java Build Path: ___ 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
Reminder: Contributing to Project Wonder webcast
Good morning everyone, Just a friendly reminder about the "Contributing to Project Wonder" webcast this morning (well, morning in America/Montreal timezone). You can register at http://bit.ly/i2895R Thanks. ___ 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: Re: fetching on joined table
Hi , Thank you everyone for your information about my problem. It's true I just want to read my data, because for modification or recording, this side is already set. To Chuck, I think that we can make everything with a framework ( WO) and even if it is difficult but there is always an issue. To Joe, I do not necessarily execute SQL but just wondering if there is a way to do this in WO? Or make a stored procedure with my complex SQL query in the lower part and just call it in WO. It would avoid me to every new version of my database to touch my WO code. I'm just looking for ways and John gave me a way Message du : 13/04/2011 De : "John Huss " A : Copie à : naneon.raym...@neuf.fr, webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table IF your data is read-only and you really, really want to use a custom SQL statement, then it's ok to fetch raw rows and set the SQL using a hint: String sqlQuery = ... NSMutableDictionary hints = new NSMutableDictionary(); hints.setObjectForKey( sqlQuery, EODatabaseContext.CustomQueryExpressionHintKey); fetchSpec.setHints( hints ); fetchSpec.setRawRowKeyPaths( ... ) return editingContext.objectsWithFetchSpecification( fetchSpec ); If this is editable data then this is definitely NOT the way to do it. John On Wed, Apr 13, 2011 at 10:18 AM, Chuck Hill wrote: You will notice that Joe works at a rather well known university too. :-) I'd listen to his advice or decide to not use WO. Chuck On Apr 13, 2011, at 8:00 AM, Joe Little wrote: Others will say similarly, but as someone who once used views, etc, you'll want to avoid these and stored procedures and build out all of this logic in EOF/Modeler and let WebObjects do it's thing. If you are executing SQL for results lists, you are likely trying too hard to outthink WO ___ 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
