Re: MySQL5.1 to 5.5
I'll check for that one thanks! On 29 September 2016 at 13:46, Stéphan Mertz <sme...@me.com> wrote: > Hi, > > We had a problem in a MySQL migration with a DEFAULT value in a not null > date time field. > It was set at -00-00 00:00:00 what was not working in recent MySQL. > > Stéphan > > Le 28 sept. 2016 à 11:13, Robin Smith <robin.sm...@clicktravel.com> a > écrit : > > Hi All > > We have a legacy WO app running using MySQL 5.1 and its been happily > chugging along for many years. However we are now in a situation where our > provider is forcing us to move to MySQL 5.5. > > I wanted to know if anyone knows of any gotchas or clangers around this > move, the mysql upgrade docs dont scream anything at me but i thought i > would shout out for the experience of others. Eg do i need a new > mysql-connector.jar? > > Or is it generally just upgrade and continue? > > Thanks in advance > > -- > Robin Smith > > Please don't print this email __ > _ > 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: > https://lists.apple.com/mailman/options/webobjects-dev/smertz%40me.com > > This email sent to sme...@me.com > > > -- Robin Smith Engineering Team Leader BEng (Hons) MBCS Email: robin.sm...@clicktravel.com -- Please don't print this email ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
MySQL5.1 to 5.5
Hi All We have a legacy WO app running using MySQL 5.1 and its been happily chugging along for many years. However we are now in a situation where our provider is forcing us to move to MySQL 5.5. I wanted to know if anyone knows of any gotchas or clangers around this move, the mysql upgrade docs dont scream anything at me but i thought i would shout out for the experience of others. Eg do i need a new mysql-connector.jar? Or is it generally just upgrade and continue? Thanks in advance -- Robin Smith -- Please don't print this email ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: MySqlPlugin
Using the explain tells me that when i supply a LIMIT query then my indexes are ignored, which i believe is the expected behaviour as according to mysql forums this is the way mysql works out of the box What i'm wondering is if i choose not to use LIMIT queries then will there be any fallout to things such as batch fetch iterator as i seem to recall that the addition of LIMIT to the mysql plugin is relatively new. Thanks Robin On 7 March 2014 18:32, Klaus Berkling webobje...@berkling.us wrote: On Mar 7, 2014, at 10:20 AM, Robin Smith robin.sm...@clicktravel.com wrote: I'm not sure about fetch plans, all i know at the moment is if i remove the LIMIT query i get millisecond performance on my query but if i include a LIMIT clause i get a full table scan. You can log the query WO generates and run that through EXPLAIN? Try it with and without the limit. On 7 March 2014 17:15, Jesse Tayler jtay...@oeinc.com wrote: did you check to make sure your database is using the index fetch plan you expect? I recall with MySQL sometimes indexes would fail but there would be no indication until I actually reviewed the fetch internals... something chuck would know off the top of his head I'm sure... On Mar 7, 2014, at 12:02 PM, Robin Smith robin.sm...@clicktravel.com wrote: Hi All We have been experiencing some performace issues with our DB queries that we have narrowed down to the limitClause applied to sql queries. It seems that out of the box MySQL uses no indexes when supplied with a LIMIT clause. Taking this into consideration we were wondering if anything like batch fetch iterator rely on the limit clause being applied to queries or if we could safely remove (or add switch to) this part of _MySqlPlugin. Thanks Robin -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- http://www.clicktravel.com Think: Do you really need to print this email? ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com This email sent to jtay...@oeinc.com -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- http://www.clicktravel.com Think: Do you really need to print this email? ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/webobjects%40berkling.us This email sent to webobje...@berkling.us kib *We keep moving forward, opening new doors, and doing new things, because we're curious and curiosity keeps leading us down new paths.* Walt Disney *Klaus Berkling* www.berkling.us | @kiberkli | Buy My iPhone apphttp://itunes.apple.com/us/app/exactbart!/id425068916?mt=8 ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/robin.smith%40clicktravel.com This email sent to robin.sm...@clicktravel.com -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- -- http://www.clicktravel.com Think: Do you really need to print this email? ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
MySqlPlugin
Hi All We have been experiencing some performace issues with our DB queries that we have narrowed down to the limitClause applied to sql queries. It seems that out of the box MySQL uses no indexes when supplied with a LIMIT clause. Taking this into consideration we were wondering if anything like batch fetch iterator rely on the limit clause being applied to queries or if we could safely remove (or add switch to) this part of _MySqlPlugin. Thanks Robin -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- -- http://www.clicktravel.com Think: Do you really need to print this email? ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: MySqlPlugin
I'm not sure about fetch plans, all i know at the moment is if i remove the LIMIT query i get millisecond performance on my query but if i include a LIMIT clause i get a full table scan. On 7 March 2014 17:15, Jesse Tayler jtay...@oeinc.com wrote: did you check to make sure your database is using the index fetch plan you expect? I recall with MySQL sometimes indexes would fail but there would be no indication until I actually reviewed the fetch internals... something chuck would know off the top of his head I'm sure... On Mar 7, 2014, at 12:02 PM, Robin Smith robin.sm...@clicktravel.com wrote: Hi All We have been experiencing some performace issues with our DB queries that we have narrowed down to the limitClause applied to sql queries. It seems that out of the box MySQL uses no indexes when supplied with a LIMIT clause. Taking this into consideration we were wondering if anything like batch fetch iterator rely on the limit clause being applied to queries or if we could safely remove (or add switch to) this part of _MySqlPlugin. Thanks Robin -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- http://www.clicktravel.com Think: Do you really need to print this email? ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com This email sent to jtay...@oeinc.com -- Robin Smith Engineering Team Leader BEng (Hons) MBCS -- -- http://www.clicktravel.com Think: Do you really need to print this email? ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WOWODC 2011 coming to your city
To be honest after attending SF and Montreal this year i was much happier in Montreal. It was much nicer place to spend the evenings. Robin ___ 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: WOWODC 2010 recordings
Yeah it was a great weekend, many thanks to Pascal for all your hard work. Bring on WOWODC 2011 Robin ___ 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
EOs not in an EC
Hi All, Bit of a basic question but i was wondering if this is allowed. If i create an array of EO's for example using XMLCoder they don't get placed in an EC. Is it ok to iterate through the array and only insert the EO's i actually want to keep into my EC allowing the other ones to disappear off into the void. Or is this bad practice, should they all get put into an EC and then dealt with from there. Many Thanks Robin ___ 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: EOs not in an EC
Dam ok i was hoping you were going to say Yeah thats fine as long as you don't try to do anything with the objects not in an EC. not to worry i'll run through and make the changes required. Shame really as it seems quite logical to me to only insert the ones i want to keep. I'm sure thats just my lack of understanding. Thanks for help Robin On 5 March 2010 14:08, Steve Peery spe...@me.com wrote: They say you should always put an EO object in an editing context before doing anything else. Therefore, I subclass the decoder and put the editing context in it so it can be used on creation. Something like this: public MyObject(WOXMLDecoder decoder) { super(); EOEditingContext ec = ((MyXMLDecoder)decoder).editingContext(); ec.insertObject(this); setName((String)decoder.decodeObjectForKey(name)); setType((String)decoder.decodeObjectForKey(type)); } Steve On Mar 5, 2010, at 4:54 AM, Robin Smith wrote: Hi All, Bit of a basic question but i was wondering if this is allowed. If i create an array of EO's for example using XMLCoder they don't get placed in an EC. Is it ok to iterate through the array and only insert the EO's i actually want to keep into my EC allowing the other ones to disappear off into the void. Or is this bad practice, should they all get put into an EC and then dealt with from there. Many Thanks Robin ___ 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/speery%40me.com This email sent to spe...@me.com -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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: EOs not in an EC
I am being supplied a XML feed from a third party thats contains a number of objects. Every so often i will refetch the xml file and create all the EOs. I then drop any EOs that i already have in my DB hence just saving any new objects in the feed. On 5 March 2010 16:40, Steve Peery spe...@me.com wrote: Why are they in the XML if you don't want them? Seems like a waste to create them and just to be disposed. Can you modify the XML before you use it? Steve On Mar 5, 2010, at 11:24 AM, Robin Smith wrote: Dam ok i was hoping you were going to say Yeah thats fine as long as you don't try to do anything with the objects not in an EC. not to worry i'll run through and make the changes required. Shame really as it seems quite logical to me to only insert the ones i want to keep. I'm sure thats just my lack of understanding. Thanks for help Robin On 5 March 2010 14:08, Steve Peery spe...@me.com wrote: They say you should always put an EO object in an editing context before doing anything else. Therefore, I subclass the decoder and put the editing context in it so it can be used on creation. Something like this: public MyObject(WOXMLDecoder decoder) { super(); EOEditingContext ec = ((MyXMLDecoder)decoder).editingContext(); ec.insertObject(this); setName((String)decoder.decodeObjectForKey(name)); setType((String)decoder.decodeObjectForKey(type)); } Steve On Mar 5, 2010, at 4:54 AM, Robin Smith wrote: Hi All, Bit of a basic question but i was wondering if this is allowed. If i create an array of EO's for example using XMLCoder they don't get placed in an EC. Is it ok to iterate through the array and only insert the EO's i actually want to keep into my EC allowing the other ones to disappear off into the void. Or is this bad practice, should they all get put into an EC and then dealt with from there. Many Thanks Robin ___ 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/speery%40me.com This email sent to spe...@me.com -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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/speery%40me.com This email sent to spe...@me.com -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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: How to upgrade my OSXServer10.4 to Wonder 5.4 from Wonder 5.3
Yep this is what we do too, Our apps are much bigger because of it, but the benefits of this are huge. Robin 2010/1/19 James Cicenia ja...@jimijon.com: So does that mean... To select the System Frameworks on my Eclipse deploy switch for the project? Basically, embed everything? Does this also mean, that all I have to do is install WOMonitor and never the Frameworks on a new server? Or better yet try the new WonderMonitor? I am still keeping to Java5. Thanks James On Jan 19, 2010, at 8:35 AM, Pascal Robert wrote: +100! Yes, the .woa will be bigger but it solve so much problems, not embedding frameworks is a disaster waiting to happen. And make sure you're building everything on Java 5, 10.4 don't have Java 6 so you won't be able to run your app on 10.4 if your classes are compiled with Java 6 bytecode. never just replace frameworks in a production app ... you should rebuild, retest, redeploy, and you should do it with embedded frameworks. ms On Jan 19, 2010, at 9:27 AM, James Cicenia wrote: Hello- I am creating a new app that needs Wonder 5.4 which needs WO 5.4. Which is fine with me as there seems like a lot of nice things there. However, I have three mature projects that just run on my various servers, two Linux and one MacOSXServer 10.4. These were all developed and deployed with 5.3 and they just work. One I haven't touched the code in two years! Anyway, can I just change the frameworks to 5.4 on the servers by just uploading them from my client? I couldn't seem to find any instructions on how to update my OSXServer running 10.4. Nothing comes up in my software update. Or is there a community installer that does it? Thanks James ___ 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/mschrag%40mdimension.com This email sent to msch...@mdimension.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/probert%40macti.ca This email sent to prob...@macti.ca Pascal Robert prob...@macti.ca AIM: MacTICanada Twitter : MacTICanada LinkedIn : http://www.linkedin.com/in/macti ___ 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/robin.rhs2%40googlemail.com This email sent to robin.r...@googlemail.com -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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
CData WOXMLCoder
Does anyone know how, if it is at all possible? I can use xml coder and a mapping file to create elements that have CDATA contents as i cant find any docs on this. Or maybe just point me towards the correct docs. Thanks Robin -- Robin Smith ___ 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
Hudson and EOGenerate
Hi All After WOWODC West i have finally got around to getting a Hudson build server created. I got all excited as it started to work, then it all fell over because we don't have our generated superclasses in SVN, so of course the build failed. Is it standard practice to have these files in SVN or can Hudson EOGenerate before building. Thanks Robin -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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: Hudson and EOGenerate
Cheers Mike, i'll start committing them, saves adding complexity for no reason Robin 2009/9/9 Mike Schrag msch...@mdimension.com: i always commit them, but you can use the standalone velocity eogenerator from your ant file: http://webobjects.mdimension.com/wolips/releases/veogen-5594.jar On Sep 9, 2009, at 7:15 AM, Robin Smith wrote: Hi All After WOWODC West i have finally got around to getting a Hudson build server created. I got all excited as it started to work, then it all fell over because we don't have our generated superclasses in SVN, so of course the build failed. Is it standard practice to have these files in SVN or can Hudson EOGenerate before building. Thanks Robin -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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/mschrag%40mdimension.com This email sent to msch...@mdimension.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/robin.rhs2%40googlemail.com This email sent to robin.r...@googlemail.com -- Robin Anthony Smith BEng Hons MBCS Internet Engineering Software and Infrastructure Engineer ___ 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: Possible Request Handler Issue
Its all browsers although firefox seems to be worse off than the others. Since my first post the problem has now been observed in ERXLongResponsePage too. The perform action completes but then gets stuck and never returns the pageForResult. Although i can reproduce the error in production its not consistent and even more annoying is that the error doesn't exist on our development server. (Which does make it look like an apache problem) I'm going switch on all the extra logging that kieran recommends and watch the logs roll past Thanks 2009/6/24 Chuck Hill ch...@global-village.net On Jun 24, 2009, at 4:56 AM, Robin Smith wrote: Hi All, We have suddenly developed an issue in our production enviroment and we have no idea where to start debugging. Symptoms- When using the app and you click a link or button the request seems to just stall, the browser progress bar shows that its doing something but the page never moves on. If i click the link or button again it completes straight away with no problems. All requests? Just some? Is it consistently reproducible? Totally random? All browsers? Just Safari? I have seen this on Safari, but only for file uploads. The request never gets to the WO app. We are not sure if its an apache problem or maybe request handler problem. Does anybody have advice on where i should start? WO 5.3 on Tiger server Wonder Revision 9482 My guess would be a browser / network / apache problem. If it was the app, the second click would not process straight away. Start by checking the Apache logs to see if the request even arrives at your server. If is does, check the app logs (you do have good logging, right?), to see if it gets there. Chuck -- 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 -- Robin Smith Software and Infrastructure Engineer BEng (Hons) MBCS Click Travel Ltd www.clicktravel.com For companies on the move *** Click Travel has been awarded the best Business Travel Management Company 2009 at the Business Travel World Awards *** Read more about our award here: http://www.clicktravel.com/wordpress/?p=484 ___ 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
Possible Request Handler Issue
Hi All, We have suddenly developed an issue in our production enviroment and we have no idea where to start debugging. Symptoms- When using the app and you click a link or button the request seems to just stall, the browser progress bar shows that its doing something but the page never moves on. If i click the link or button again it completes straight away with no problems. We are not sure if its an apache problem or maybe request handler problem. Does anybody have advice on where i should start? WO 5.3 on Tiger server Wonder Revision 9482 -- Robin Smith Click Travel Ltd www.clicktravel.com For companies on the move ___ 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