Got strange issue today while working with mySql and ColdFusion. This might be old issue but we never face issue since we normally work with MS Sql and I think this one is second/third project which use mysql as database. Error says java.sql.SQLException: value '.........with long garbage string and special characters......' can not be represented as java.sql.Date and this is due to mysql store 0000-00-00 stored as Null value of date.

Day 14 on ColdFusion 10, I haven't cover much in last 13 days but go deeper in functionality. Today I keep working with schedule task enhancement and research on event handler feature. This will let us define functions which will call on particular event. Following event/method supported in event handler CFC.

• onTaskStart : Call every time when task start, If function return false will not execute schedule.
• onMisFire : Call anytime schedule file misfire (other than schedule time) any how it only fire first time for me when I create schedule file and but later on manual call doesn't invoke.
• onTaskEnd: Call execution of task end.
• onError: Call on exception on task, either 404 or 500 error. P.S. This will not invoke in case of syntax error in your coldfusion page.
• execute : ColdFusion 10 allow you to write code in cfc function instead of calling any URL, if you do not provide URL while creating schedule file then it will look for execute function in your event handler but URL will get priority if both available.

In my last post I have covered Group and list scheduler enhancement in ColdFusion 10. Today I have spent some time with event hander and other enhancement. In coldfusion 10 added new attribute mode which task application or server as value, this will let you specify task is server specific or application specific and default mode is server. Application specific task can be created from Application only and it will not be editable from ColdFusion administrator although you can run, pause or delete it from there.

In yesterday blog I have list out all new feature added in schedule task in ColdFusion 10. Now time to test it out, covering list, group feature in this post. While creating schedule we can put schedule in specific group and later you can pause all/resume all schedule in same group without firing individual command. And list option added in action attribute which list out all current schedules in query format.

Schedule task is something that I used lot and specially one of our clients love to get email periodically for different reports. In many case we get limited with ColdFusion 9 schedule task, like for one of schedule task require to reschedule on different time once executed and time vary per database transaction. Following are list of new feature in schedule task.

Day 10 of my ColdFusion 10 month, seems that lot more functionality added in ColdFusion 10 and will not able to cover all in within 30 days with current busy schedule. Yesterday cover CFCProxy which you can use in java class to invoke ColdFusion component function but seems limitation is you can't call for coldfusion instance. This will be overcome with createDynamicProxy function.

It's DAY 9 and I enjoyed last 8 days with ColdFusion 10 and as days pass my curiosity graph going high. In yesterday post discuss about how easy to use your java class/jar file within your project. But you may also want to use power of ColdFusion in Java class and this one is possible with use of CFCProxy. Well CFCProxy available since ColdFusion 7 ( I guess) but never get chance to look into this. 

I continue using previous post example to explain how to call ColdFusion component function within Java class.

We all know ColdFusion 10 is out and lots of tweet regarding release. As usual my first step was to install ColdFusion 10 in my dev computer and going everything smooth and start testing ColdFusion 10 with my existing projects which were running under CF9 before. Seems everything working good so Adobe take care of backward compatibility, I have a project on development computer since CF7 era and this project migrated to CF8, CF9 as new ColdFusion version released. When we move from CF8 to CF9 was really tedious job for us because of ExtJs version changed. 

Found list of new features in ColdFusion by Charlie Arehart and decided to checkout all new features (at least one per day) and blog that. Below is list of all 30 days series for ColdFusion 10. (I will add link as post available on that day :) )