[cfaussie] Student Ticket Competition for cf.Objective(ANZ) + Flex
Sorry for the plug, but in case people aren't aware, we are running a competition for a current ANZ Student to win free flights, accommodation and a ticket to cf.Objective(ANZ) + Flex. Entry is a pretty simple 200 word entry, so nothing too crazy! Rules can be found here: http://cfobjective.com.au/news/student-ticket-accommodation-and-flights-give-away I think it will be a pretty good opportunity for a young student to get some great real-world tech industry perspective at a young age. If you know any students or educational institutions, please feel free to pass on these details, the more entries the better! :) Thanks! Mark -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) + Flex - Nov 17, 18 - Melbourne Australia http://www.cfobjective.com.au 2 Devs from Down Under Podcast http://www.2ddu.com/ -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Student Ticket Competition for cf.Objective(ANZ) + Flex [spamtrap bayes][spamtrap heur]
Plugging at User Group meeting tonight http://www.baug.com.au Richard Mark Mandel mark.man...@gmail.com wrote: Sorry for the plug, but in case people aren't aware, we are running a competition for a current ANZ Student to win free flights, accommodation and a ticket to cf.Objective(ANZ) + Flex. Entry is a pretty simple 200 word entry, so nothing too crazy! Rules can be found here: http://cfobjective.com.au/news/student-ticket-accommodation-and-flights-give-away I think it will be a pretty good opportunity for a young student to get some great real-world tech industry perspective at a young age. If you know any students or educational institutions, please feel free to pass on these details, the more entries the better! :) Thanks! Mark -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) + Flex - Nov 17, 18 - Melbourne Australia http://www.cfobjective.com.au 2 Devs from Down Under Podcast http://www.2ddu.com/ -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Student Ticket Competition for cf.Objective(ANZ) + Flex
Added to ACTCFUG: http://www.actcfug.com/index.cfm?actcfug=NewsViewNewsID=613 Peter Tilbrook Web Administrator, The Club Group (ACT) Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ ABN: 80 826 226 128 On 7 September 2011 17:47, Mark Mandel mark.man...@gmail.com wrote: Sorry for the plug, but in case people aren't aware, we are running a competition for a current ANZ Student to win free flights, accommodation and a ticket to cf.Objective(ANZ) + Flex. Entry is a pretty simple 200 word entry, so nothing too crazy! Rules can be found here: http://cfobjective.com.au/news/student-ticket-accommodation-and-flights-give-away I think it will be a pretty good opportunity for a young student to get some great real-world tech industry perspective at a young age. If you know any students or educational institutions, please feel free to pass on these details, the more entries the better! :) Thanks! Mark -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) + Flex - Nov 17, 18 - Melbourne Australia http://www.cfobjective.com.au 2 Devs from Down Under Podcast http://www.2ddu.com/ -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Does CFTRANSACTION work across multiple datasources?
The scenario: I have a local application, which updates a local database as a business process goes on.But I want the application also to update a remote database, with the details of this event, then set a flag in the local record that the record has been exported to the remote database. However I'm building error handling to provide for the possibility that the remote database might not be available. I dont want that to stop the local application, or it will close the business down. I want the business to go on, the customer satisfied and the web site can be updated later on when the internet connection is back up again Does CFTRANSACTION handle the commit/rollback of both databases if any part of the queries fails?I would code it kind of like this: cftransaction cfquery name=qRemoteInsert datasource=remoteDSN INSERT into eventrecord yada yada yada /cfquery cfquery name=qlocalUpdate datasource=localDSN Update eventrecord SET exportedToRemoteDB = true WHERE eventID = cfqueryparam value=#thiseventID# cfsqltype=cf_sql_integer/ /cfquery /cftransaction -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
ColdFusion 9 or 9.01, I think added this, not 100% certain on it though. On Wed, Sep 7, 2011 at 9:23 PM, Mike Kear afpwebwo...@gmail.com wrote: The scenario: I have a local application, which updates a local database as a business process goes on.But I want the application also to update a remote database, with the details of this event, then set a flag in the local record that the record has been exported to the remote database. However I'm building error handling to provide for the possibility that the remote database might not be available. I dont want that to stop the local application, or it will close the business down. I want the business to go on, the customer satisfied and the web site can be updated later on when the internet connection is back up again Does CFTRANSACTION handle the commit/rollback of both databases if any part of the queries fails?I would code it kind of like this: cftransaction cfquery name=qRemoteInsert datasource=remoteDSN INSERT into eventrecord yada yada yada /cfquery cfquery name=qlocalUpdate datasource=localDSN Update eventrecord SET exportedToRemoteDB = true WHERE eventID = cfqueryparam value=#thiseventID# cfsqltype=cf_sql_integer/ /cfquery /cftransaction -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Is a big ask - what about a temporary table or backup table you can flag for records that made it through - you can compare commits to? I have a similar issue but for sending emails AND the database issue. Peter Tilbrook Web Administrator, The Club Group (ACT) Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ ABN: 80 826 226 128 On 7 September 2011 21:36, Andrew Scott andr...@andyscott.id.au wrote: ColdFusion 9 or 9.01, I think added this, not 100% certain on it though. On Wed, Sep 7, 2011 at 9:23 PM, Mike Kear afpwebwo...@gmail.com wrote: The scenario: I have a local application, which updates a local database as a business process goes on. But I want the application also to update a remote database, with the details of this event, then set a flag in the local record that the record has been exported to the remote database. However I'm building error handling to provide for the possibility that the remote database might not be available. I dont want that to stop the local application, or it will close the business down. I want the business to go on, the customer satisfied and the web site can be updated later on when the internet connection is back up again Does CFTRANSACTION handle the commit/rollback of both databases if any part of the queries fails? I would code it kind of like this: cftransaction cfquery name=qRemoteInsert datasource=remoteDSN INSERT into eventrecord yada yada yada /cfquery cfquery name=qlocalUpdate datasource=localDSN Update eventrecord SET exportedToRemoteDB = true WHERE eventID = cfqueryparam value=#thiseventID# cfsqltype=cf_sql_integer/ /cfquery /cftransaction -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
I don't think ColdFusion cares about temp tables, as long as they exist at that time of the query. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Wed, Sep 7, 2011 at 9:51 PM, ColdGen Internet Solutions coldgen.internet.soluti...@gmail.com wrote: Is a big ask - what about a temporary table or backup table you can flag for records that made it through - you can compare commits to? I have a similar issue but for sending emails AND the database issue. Peter Tilbrook Web Administrator, The Club Group (ACT) Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ ABN: 80 826 226 128 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
No idont think a temp table will solve the problem, which is bascially how can i be sure that the remote database has updated, and if not, be sure of finding the correct records later when i try it again - without doubling up on records in teh remote database, or alternatively missing any? One way i could do it is to perform the remote insert, then immediately do a query on the remote database for that record, but i was hoping to do it without requiring another trip out to the remote database. Hence the question about CFTRANSACTION. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Sep 7, 2011 at 9:57 PM, Andrew Scott andr...@andyscott.id.au wrote: I don't think ColdFusion cares about temp tables, as long as they exist at that time of the query. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Hi Mike, I won't comment about CF or any other database server, but this is possible with SQL server. you need to create a link to your distant server first. Then in your example, instead of using a cftransaction and 2 cfquery with different dsn, you'd have something along the line of cfquery dsn=local being tran t1 begin try INSERT into linkedserver.distantdatabase.dbo.table values(...) Update eventrecord SET exportedToRemoteDB = true COMMIT begin catch Update eventrecord SET exportedToRemoteDB = true end catch end try cfquery I'm sure ant modern dbms would have a similar mechanism, but I'm very much a sql server fan boy, so it's the only thing I know ;-) as for actual cross-server transactions, you can configure something called DTC (Distributed Transaction Coordinator). It's pretty much an engine that allows a tran between 2 or more linked servers to be shared, and that manages commits and rollbacks as a whole. hope this helps. Tof On Wed, Sep 7, 2011 at 9:57 PM, Andrew Scott andr...@andyscott.id.auwrote: I don't think ColdFusion cares about temp tables, as long as they exist at that time of the query. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Wed, Sep 7, 2011 at 9:51 PM, ColdGen Internet Solutions coldgen.internet.soluti...@gmail.com wrote: Is a big ask - what about a temporary table or backup table you can flag for records that made it through - you can compare commits to? I have a similar issue but for sending emails AND the database issue. Peter Tilbrook Web Administrator, The Club Group (ACT) Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ ABN: 80 826 226 128 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Mike, You don't say which version of ColdFusion your using either. btw http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c6b.html On Wed, Sep 7, 2011 at 10:22 PM, Chris Velevitch chris.velevi...@gmail.comwrote: I think the solution is a message queue. It's a system that guarantees the message (record) is delivered to the other system (database) and it can give that guarantee because it stores all the messages in it's own database. So when the remote system is unreachable the message queue stores all the messages in order and when the remote system comes back up, the stored messages are resent in order they where received. There are a number of free open source message queues, so only issue is how much time, effort and resources (a second server) do you what to spend? Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney Topic: Deploying Coldfusion into the Cloud Date: 26th September 6pm for 6:30 start Details and RSVP on http://apugs.groups.adobe.com/index.cfm?event=post.displaypostid=38239 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
sorry, I meant to update that second update statement to false On Wed, Sep 7, 2011 at 10:23 PM, christophe albrech christophe.albr...@gmail.com wrote: Hi Mike, I won't comment about CF or any other database server, but this is possible with SQL server. you need to create a link to your distant server first. Then in your example, instead of using a cftransaction and 2 cfquery with different dsn, you'd have something along the line of cfquery dsn=local being tran t1 begin try INSERT into linkedserver.distantdatabase.dbo.table values(...) Update eventrecord SET exportedToRemoteDB = true COMMIT begin catch Update eventrecord SET exportedToRemoteDB = true end catch end try cfquery I'm sure ant modern dbms would have a similar mechanism, but I'm very much a sql server fan boy, so it's the only thing I know ;-) as for actual cross-server transactions, you can configure something called DTC (Distributed Transaction Coordinator). It's pretty much an engine that allows a tran between 2 or more linked servers to be shared, and that manages commits and rollbacks as a whole. hope this helps. Tof On Wed, Sep 7, 2011 at 9:57 PM, Andrew Scott andr...@andyscott.id.auwrote: I don't think ColdFusion cares about temp tables, as long as they exist at that time of the query. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Wed, Sep 7, 2011 at 9:51 PM, ColdGen Internet Solutions coldgen.internet.soluti...@gmail.com wrote: Is a big ask - what about a temporary table or backup table you can flag for records that made it through - you can compare commits to? I have a similar issue but for sending emails AND the database issue. Peter Tilbrook Web Administrator, The Club Group (ACT) Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ ABN: 80 826 226 128 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Sorry Andrew, you're quite right - i forgot to say it's CF9.0.1. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Sep 7, 2011 at 10:24 PM, Andrew Scott andr...@andyscott.id.au wrote: Mike, You don't say which version of ColdFusion your using either. btw http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c6b.html -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Does CFTRANSACTION work across multiple datasources?
That’s ok Mike, I would assume that unless otherwise stated. So the answer is yes to your question. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Mike Kear Sent: Wednesday, 7 September 2011 10:31 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Does CFTRANSACTION work across multiple datasources? Sorry Andrew, you're quite right - i forgot to say it's CF9.0.1. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Ok i have the answer - NO.For those who are just tuning in, I asked whether i could wrap two queries on different datasources with CFTRANSACTION tags, and in CF9.0.1 I get an error message saying that the datasource for all queries inside CFTRANSACTION tags must be the same. So i think i am going to have to do the insert on the remote datasource, then do a query on the same datasource to verify it has happened correctly, unless someone has a better idea.The most likely problem I foresee is that the internet might be down for one reason or another during a transaction. In that case, I want the local processing to continue without a pause, and the remote database updated later on when the internet is up again, and be able to ensure [a] no duplicate records are inserted on the remote database, and [b] no records are missed either. Anyone have a better idea? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Sep 7, 2011 at 10:28 PM, Andrew Scott andr...@andyscott.id.au wrote: That’s ok Mike, I would assume that unless otherwise stated. So the answer is yes to your question. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
Mike, I reread the documentation it looks like the across multiple databases is in fact an enterprise only feature, surprise surprise... -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Thu, Sep 8, 2011 at 12:05 AM, Mike Kear afpwebwo...@gmail.com wrote: Ok i have the answer - NO.For those who are just tuning in, I asked whether i could wrap two queries on different datasources with CFTRANSACTION tags, and in CF9.0.1 I get an error message saying that the datasource for all queries inside CFTRANSACTION tags must be the same. So i think i am going to have to do the insert on the remote datasource, then do a query on the same datasource to verify it has happened correctly, unless someone has a better idea.The most likely problem I foresee is that the internet might be down for one reason or another during a transaction. In that case, I want the local processing to continue without a pause, and the remote database updated later on when the internet is up again, and be able to ensure [a] no duplicate records are inserted on the remote database, and [b] no records are missed either. Anyone have a better idea? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Sep 7, 2011 at 10:28 PM, Andrew Scott andr...@andyscott.id.au wrote: That’s ok Mike, I would assume that unless otherwise stated. So the answer is yes to your question. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?
+1 - A message queue is the best solution for this type of problem. Cheers Kai I think the solution is a message queue. It's a system that guarantees the message (record) is delivered to the other system (database) and it can give that guarantee because it stores all the messages in it's own database. So when the remote system is unreachable the message queue stores all the messages in order and when the remote system comes back up, the stored messages are resent in order they where received. There are a number of free open source message queues, so only issue is how much time, effort and resources (a second server) do you what to spend? Chris -- -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: Amazon EC2 hosting services viability
I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To view this discussion on the web visit https://groups.google.com/d/msg/cfaussie/-/c3O9Fa64BxMJ. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: Amazon EC2 hosting services viability
That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the server, plug a USB drive in and either do backups or transfer large amounts of data to my servers. I have a full rack available to me and i agree that if i was looking to expand, then the cost of hardware will be more than a new instance in the cloud. Looking at the figures starting out fresh, the TCO is much higher with the typical data centre infrastructure on a hardware level and possible hardware maintenance level but the ongoing costs of a cloud seems to be just as high or higher than traditional data center services for running systems. Yes cloud scaling is nice but when then ongoing costs of basic infrastructure ends up being more what would be the compelling argument to move to a cloud? Steve On Sep 8, 11:43 am, Chong kck...@gmail.com wrote: I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Amazon EC2 hosting services viability
Steve: what's the Data Center's/your's disaster recovery plan?** How critical is it for you to deliver, say, 99.5% (or whatever in your SLA) uptime to your customers? no criticism, not having a go, just curious if these are factors to consider (what you've got Vs what EC2 can do for you). me: no affil/bias either way. B ** IIRC, there were a couple of P-o-P's inside the WTC ... until Sept 11, that is (it's all about managing risk... and sometimes mitigating all the risk just costs too much to be competitive in business) On Thu, Sep 8, 2011 at 12:27 PM, Steve Onnis st...@cfcentral.com.au wrote: That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the server, plug a USB drive in and either do backups or transfer large amounts of data to my servers. I have a full rack available to me and i agree that if i was looking to expand, then the cost of hardware will be more than a new instance in the cloud. Looking at the figures starting out fresh, the TCO is much higher with the typical data centre infrastructure on a hardware level and possible hardware maintenance level but the ongoing costs of a cloud seems to be just as high or higher than traditional data center services for running systems. Yes cloud scaling is nice but when then ongoing costs of basic infrastructure ends up being more what would be the compelling argument to move to a cloud? Steve On Sep 8, 11:43 am, Chong kck...@gmail.com wrote: I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: Amazon EC2 hosting services viability
my disaster plan is an open ended ticket to mexico! :) kidding bi-daily backups etc The thing is even with all those backup plans it just adds more to the costs of running in a cloud. On Sep 8, 12:50 pm, Barry Beattie barry.beat...@gmail.com wrote: Steve: what's the Data Center's/your's disaster recovery plan?** How critical is it for you to deliver, say, 99.5% (or whatever in your SLA) uptime to your customers? no criticism, not having a go, just curious if these are factors to consider (what you've got Vs what EC2 can do for you). me: no affil/bias either way. B ** IIRC, there were a couple of P-o-P's inside the WTC ... until Sept 11, that is (it's all about managing risk... and sometimes mitigating all the risk just costs too much to be competitive in business) On Thu, Sep 8, 2011 at 12:27 PM, Steve Onnis st...@cfcentral.com.au wrote: That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the server, plug a USB drive in and either do backups or transfer large amounts of data to my servers. I have a full rack available to me and i agree that if i was looking to expand, then the cost of hardware will be more than a new instance in the cloud. Looking at the figures starting out fresh, the TCO is much higher with the typical data centre infrastructure on a hardware level and possible hardware maintenance level but the ongoing costs of a cloud seems to be just as high or higher than traditional data center services for running systems. Yes cloud scaling is nice but when then ongoing costs of basic infrastructure ends up being more what would be the compelling argument to move to a cloud? Steve On Sep 8, 11:43 am, Chong kck...@gmail.com wrote: I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Amazon EC2 hosting services viability
As far as I can tell there are three main advantages of cloud infrastructure, and others have already mentioned most of them: 1) you don't have to manage your own hardware 2) pay by the hour - good for development, and ties into #3 3) you can bring up new instances effectively instantly - both adding more servers to handle load, and removing unused instances to reduce cost If you don't need for any of those, then you probably shouldn't go with EC2. Blair On Thu, Sep 8, 2011 at 2:24 PM, Steve Onnis st...@cfcentral.com.au wrote: my disaster plan is an open ended ticket to mexico! :) kidding bi-daily backups etc The thing is even with all those backup plans it just adds more to the costs of running in a cloud. On Sep 8, 12:50 pm, Barry Beattie barry.beat...@gmail.com wrote: Steve: what's the Data Center's/your's disaster recovery plan?** How critical is it for you to deliver, say, 99.5% (or whatever in your SLA) uptime to your customers? no criticism, not having a go, just curious if these are factors to consider (what you've got Vs what EC2 can do for you). me: no affil/bias either way. B ** IIRC, there were a couple of P-o-P's inside the WTC ... until Sept 11, that is (it's all about managing risk... and sometimes mitigating all the risk just costs too much to be competitive in business) On Thu, Sep 8, 2011 at 12:27 PM, Steve Onnis st...@cfcentral.com.au wrote: That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the server, plug a USB drive in and either do backups or transfer large amounts of data to my servers. I have a full rack available to me and i agree that if i was looking to expand, then the cost of hardware will be more than a new instance in the cloud. Looking at the figures starting out fresh, the TCO is much higher with the typical data centre infrastructure on a hardware level and possible hardware maintenance level but the ongoing costs of a cloud seems to be just as high or higher than traditional data center services for running systems. Yes cloud scaling is nice but when then ongoing costs of basic infrastructure ends up being more what would be the compelling argument to move to a cloud? Steve On Sep 8, 11:43 am, Chong kck...@gmail.com wrote: I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group athttp:// groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: Amazon EC2 hosting services viability
Yes paying by the hour is great but when you are using them as production instances which need to be up 24/7 then the paying by the hour doesn't really come into it. On Sep 8, 3:35 pm, Blair McKenzie shi...@gmail.com wrote: As far as I can tell there are three main advantages of cloud infrastructure, and others have already mentioned most of them: 1) you don't have to manage your own hardware 2) pay by the hour - good for development, and ties into #3 3) you can bring up new instances effectively instantly - both adding more servers to handle load, and removing unused instances to reduce cost If you don't need for any of those, then you probably shouldn't go with EC2. Blair On Thu, Sep 8, 2011 at 2:24 PM, Steve Onnis st...@cfcentral.com.au wrote: my disaster plan is an open ended ticket to mexico! :) kidding bi-daily backups etc The thing is even with all those backup plans it just adds more to the costs of running in a cloud. On Sep 8, 12:50 pm, Barry Beattie barry.beat...@gmail.com wrote: Steve: what's the Data Center's/your's disaster recovery plan?** How critical is it for you to deliver, say, 99.5% (or whatever in your SLA) uptime to your customers? no criticism, not having a go, just curious if these are factors to consider (what you've got Vs what EC2 can do for you). me: no affil/bias either way. B ** IIRC, there were a couple of P-o-P's inside the WTC ... until Sept 11, that is (it's all about managing risk... and sometimes mitigating all the risk just costs too much to be competitive in business) On Thu, Sep 8, 2011 at 12:27 PM, Steve Onnis st...@cfcentral.com.au wrote: That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the server, plug a USB drive in and either do backups or transfer large amounts of data to my servers. I have a full rack available to me and i agree that if i was looking to expand, then the cost of hardware will be more than a new instance in the cloud. Looking at the figures starting out fresh, the TCO is much higher with the typical data centre infrastructure on a hardware level and possible hardware maintenance level but the ongoing costs of a cloud seems to be just as high or higher than traditional data center services for running systems. Yes cloud scaling is nice but when then ongoing costs of basic infrastructure ends up being more what would be the compelling argument to move to a cloud? Steve On Sep 8, 11:43 am, Chong kck...@gmail.com wrote: I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group athttp:// groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Amazon EC2 hosting services viability
Steve Take a look at Rackspace cloud options. I've been looking at them and chatting with Phil and they are also really good value for money and they don't loose your data like Amazon do upon restart. http://www.rackspace.com/cloud/ Paul. On Thu, Sep 8, 2011 at 3:56 PM, Steve Onnis st...@cfcentral.com.au wrote: Yes paying by the hour is great but when you are using them as production instances which need to be up 24/7 then the paying by the hour doesn't really come into it. On Sep 8, 3:35 pm, Blair McKenzie shi...@gmail.com wrote: As far as I can tell there are three main advantages of cloud infrastructure, and others have already mentioned most of them: 1) you don't have to manage your own hardware 2) pay by the hour - good for development, and ties into #3 3) you can bring up new instances effectively instantly - both adding more servers to handle load, and removing unused instances to reduce cost If you don't need for any of those, then you probably shouldn't go with EC2. Blair On Thu, Sep 8, 2011 at 2:24 PM, Steve Onnis st...@cfcentral.com.au wrote: my disaster plan is an open ended ticket to mexico! :) kidding bi-daily backups etc The thing is even with all those backup plans it just adds more to the costs of running in a cloud. On Sep 8, 12:50 pm, Barry Beattie barry.beat...@gmail.com wrote: Steve: what's the Data Center's/your's disaster recovery plan?** How critical is it for you to deliver, say, 99.5% (or whatever in your SLA) uptime to your customers? no criticism, not having a go, just curious if these are factors to consider (what you've got Vs what EC2 can do for you). me: no affil/bias either way. B ** IIRC, there were a couple of P-o-P's inside the WTC ... until Sept 11, that is (it's all about managing risk... and sometimes mitigating all the risk just costs too much to be competitive in business) On Thu, Sep 8, 2011 at 12:27 PM, Steve Onnis st...@cfcentral.com.au wrote: That's just it though. I own all of my hardware outright, so the only costs at the moment for us is the data centre costs which current is a little over 2k a month and includes 100 Gb of data. I have full control of security, firewalls, the servers, environments and if needed i can walk up to the server, plug a USB drive in and either do backups or transfer large amounts of data to my servers. I have a full rack available to me and i agree that if i was looking to expand, then the cost of hardware will be more than a new instance in the cloud. Looking at the figures starting out fresh, the TCO is much higher with the typical data centre infrastructure on a hardware level and possible hardware maintenance level but the ongoing costs of a cloud seems to be just as high or higher than traditional data center services for running systems. Yes cloud scaling is nice but when then ongoing costs of basic infrastructure ends up being more what would be the compelling argument to move to a cloud? Steve On Sep 8, 11:43 am, Chong kck...@gmail.com wrote: I have an ex colleague that work projects uses EC2... how do you arrive at 450-500 per instance excluding data? With my discussions with him and a few others, it is very hard to estimate your actual usage till you get on it. For me the potential lies in - Ability to exist beyond different regions (the likely hood of all the datacenters going down in all the region is very very small) - scalable (you can switch the instance type, and I also believe there is the ability to create/increase capacity via code/conditions) - Not needing to worry about hardware So for my understand so far, for you to get maximum benefit from EC2 is to architect the app/site whereby it can exists between different regions , know how to interface with EC2 to scale when needed... not needing to worry about hardware is common with any hosting provider, cloud or non cloud. Besides the fact that it is cheaper, due to scale of economics. Just my uneducated 2 cents :) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group athttp:// groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at