3 May 2008 - XMLToaster Version1.0.10 released. See the downloads page. This is a bugfix release which increases support for MySQL, improves error handling to give meaningful messages and some tweaks for compatibility with AjaxToaster.

3 May 2008 - We’ve put the new AjaxToaster code on the download page. This is a server which is designed to make it very easy for your ajax applications to get data from, and persist data to your databases. The goal is to provide a powerful but simple and easy to use SOA.

The downloads page contains a beta version of the ajaxToaster servlet that can be installed under any application server. Read the tutorial for information on how to set it up.
Read the rest of this entry »

The Smell of Burning XML - Introducing XMLToaster

Java can be a very blunt tool when it comes to working with XML - there are lots of concepts to understand, lots of APIs to learn, and lots of code to write. Even when you have made it through the concepts and APIs you’ve only made it to the starting line!
Now you need to get some data to go with your XML, which often means learning yet another API to integrate with your relational database!

In this article I will explain how the XMLToaster can simplify the process of working in the XML and relational database worlds, without giving away any of the power and flexibility of either.
Read the rest of this entry »

We have reviewed how persistance is managed in v1.0.8.
The xmltosql parser has been rewritten to support a more human readable psuedo-sql syntax in addition to the current XML configuration.

An example of updating a table with the new, simplified syntax: If this is the xml message to save to the database….

<message>
    <dish  id=12>
        <dishname>Dry  Toast</dishname>
        <dishtype>MAIN</dishtype>
        <prices>
            <retail>1.50</retail>
            <wholesale>0.05</wholesale>
        </prices>
    </dish>

    <dish  id=14>
          :
          etc
          :
    </dish>
</message>


Then the xmltoaster update statement you would need is…

 update table menu using (update)
 set
  dishid = {message.dish.@id, key:1 },
  dishname = {message.dish.dishname, type:'string'},
  dishtype = {message.dish.type, type:'string'},
  price = {message.dish.prices.retail }
 ;
 onError('Error updating the menu table!!.', abort, rollback);


Easy, huh?