pureQuery is IBM's new, high-performance Java data access platform focused on simplifying, developing, securing, managing, and optimizing applications that access data. Java data access includes Java persistence and all data CRUD operations.
pureQuery makes Java data access simple for agile development and improved application performance. pureQuery can be used both in standaloneJava SE applications and in Java EE applications using servlets or EJB session beans. pureQuery can also be used to develop your data access for Web 2.0 applications. For example, pureQuery can return XML and JSON from a data source. IBM's Project Zero uses pureQuery for its data access
pureQuery includes an integrated Eclipse Java and query(SQL, SQL/XML, XQuery) editor that provides Java data access developers with an interactive software development environment.
pureQuery supports two programming styles: inline and method style.
In an annotated method pureQuery application, the SQL string is defined as an element of a Java 5.0, pureQuery Annotation, such as @Select, @Update and @Call. pureQuery tooling automatically generates an optimized implementation for the annotated method. The annotated method style is capable of supporting both static and dynamic execution of SQL.
In the inline style, SQL statements can be created “inline” within the code as a java String object. This dynamically generated statement is passed as a String parameter to the pureQuery Data interface method. The inline style was based on an early draft enhancement to the JDBC 4.0 specification, although it is not in the final JDBC 4.0 spec.
The first pureQuery openBeta ended October 31, 2007. IBM Data Studio v1.1, which contains pureQuery, was released on 10-31-07. IBM Data Studio 1.1.1, including IBM Data Studio Developer and IBM Data Studio pureQuery Runtime were released December 12, 2007.
IBM Data Studio 1.1.2 (or fixpack 2) was released March 28, 2008.
IBM Data Studio Developer and IBM Data Studio pureQuery Runtime v1.2 were released on July 31, 2008. IBM Data Studio pureQuery Runtime for z/OS is expected to be available on August 29, 2008.