Simple example on how to caputure the query execution plan from SQLFire

Java Tools and Frameworks
| May 21, 2012 03:24 +0000

The example below shows how we can capure the query plan for SQL running in SQLFire. Although any user can run an explain plan you must connect as a peer to show the query execution plan as the data is stored in the SYS.STATEMENTPLANS table.

1. Determ…

vfabric Application Director 3 Tier Spring Travel Blueprint

Java Tools and Frameworks
| May 10, 2012 20:45 +0000

Here are the steps used to create a 3 tier application using Spring travel with a MYSQL database. This is based on the screen shots from the previous blog entry.

1. Log into “vFabric Application Director” home page
2. Click on “Manage Applications”.
3…