FileMaker Blogs

Studio Manager 12 passed a FileMaker, Inc review in May 2013 to receive the coveted iOS optimized badge. You can find us among the 37 products Made for FileMaker in the special section: Solutions Optimized for iPad ...

Boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you. Here you can collaborate with other like-minded FileMaker users and ...

Currently when you open your file its always load the Standard Filemaker Menus which is default in Filemaker for a Full Access privileged user so all the options are available for user. So create a custom menus and install the ...

What's next for SeedCode, FileMaker, Calendars, and the Web.

Are DML changes rolled back when an exception occurs in Visualforce?

It is clear from the official Salesforce documentation that all database modifications initiated from a trigger are rolled back when an exception occurs. We can look at it as if the application server started a transaction in our behalf, and handled the roll back if an exception is thrown and is not handled.

But, what happens with exceptions in VisualForce?

From reading some of the documentation, it may not be as clear how the application behaves when an exception occurs as a result of a VisualForce interaction. Are DML changes rolled back when an exception occurs as a consequence of a VisualForce request? Well, it turns out it’s pretty easy to test it, so I went ahead and did that.

I used just two components for my test:

1. A VisualForce page
2. A Controller for our VisualForce page

This is the code for the VisualForce page:

This is the code for the Controller:

The only thing that the VF page does is call the throwException method when the user clicks on the “Click Me” button.

In the throwException method the second insert fails because the name field is required when creating a pricebook.

If you look at the database state after clicking the button, you will see that neither insert went through. (You can comment out the second one to make sure the first one works.)

So from our test it is clear that VisualForce pages display the same behaviour triggers do, and that all database changes are rolled back when an exception occurs.

This behavior is consistent with the way exceptions are handled everywhere else, and we could imagine that internally Salesforce is using something like Java filters for establishing transaction boundaries, in a fashion similar to how it’s done in the Spring framework.

Happy coding!

Salesforce.com
Software Development
Web
Salesforce

Salesforce
Visualforce

Tips on how to start a training classes - posted in Making A Living: Hi, Im a filemaker developer (almost 15 years now). Everything I learned is by myself or with the help of this great FM community. There are no FM training ...

College lecture-class auto scheduling - posted in Solutions Wanted: Hi, Anyone know of a solution that can auto-schedule lecturers and classes for an entire semester? (at least 80% effective) tnx.

Information about updating a FileMaker solution when using a separation model for deployment of FileMaker files. More...

after conversion from fm11 to fm12 clicking on an object i can see the line setting to embossed,, change the setting to none then try to change the setting back to embossed again and embossed is not an option ?????????????? (same with ...

posted in FileMaker Go for iPhone & iPad: hi all, is it just me or does the attaching of a fmp12-file (compacted copy or previously exported data) does not work on FM Go? i export data to the temp directory and use the same ...

Hi, I have a Field DateofEvent and a repeating field of 7 called DayofWeek. I want that when a user enters a Date that it will put the number 1 in the repeating field DayofWeek corresponding with the day (DayofWeek = Sunday, ...