(Owen Cline) This “how-to” article explains how you can use SQLJ in your Java applications as well as your J2EE applications. It covers SQLJ syntax, accessing data sources, setting up WebSphere Application Developer projects to support SQLJ, and creating and invoking DB2 stored procedures using SQLJ
Other News
Optimizing Microsoft SQL Server Analysis Services: Enhance Cube Processing Performance with Optimize Schema
(William E. Pearson, III) In this article, we will explore another tool that MSAS offers for the enhancement of cube processing, the Optimize Schema option. This option can assist us in significantly reducing a cube’s processing time. Optimize Schema attempts to identify unnecessary joins between ou
Generating an XML Document with JAXB
(Deepak Vohra) An XML Schema represents the structure of an XML document in XML syntax. J2EE developers may require an XML document to conform to an XML Schema. The Java Architecture for XML Binding (JAXB) provides a binding compiler, xjc, to generate Java classes from an XML Schema. The Java cl
Architecture of the World Wide Web, Volume One
This document describes the properties we desire of the Web and the design choices that have been made to achieve them. It promotes the reuse of existing standards when suitable, and gives guidance on how to innovate in a manner consistent with Web architecture.
IBM Partners: Will Oracle Displace DB2 And WebSphere?
(Steven Burke) The big question that IBM PeopleSoft partners are grappling with in the wake of the Oracle-PeopleSoft merger is whether Oracle will attempt to displace IBM’s DB2 and WebSphere platform with its own competing product set.
ODBC is not dead
(Tony Patton) One of the .NET Framework features often highlighted is its new data access model, ADO.NET. Some of its improvements over its predecessors include scalability, speed, and its disconnected nature features. A .NET data provider is used to access a database system; a good example is t
Query Rewrite (Sample Chapter)
(Lilian Hobbs, Susan Hillson, Shilpa Lawande and Pete Smith) In Chapter 7, we described materialized views, which can be used to precompute and store results of frequently used queries. A major benefit of doing this is that you can use query rewrite to transparently rewrite queries to use these mate
2004 Review of the Year: Security
(Iain Thomson) Security has remained high on the agenda throughout the IT recession, and the year has seen some major steps forward, and a few steps back.
MySQL Lures Open-Source Newbies with Consulting Deals
(Lisa Vaas) MySQL AB is offering consulting packages and GUI tools for those who want to jump into open-source technology but lack in-house gurus and are too nervous to go it alone.
E-Commerce: Customizing and Extending the Commerce Starter Kit
(Chris Sully) This series of articles is going to examine some of the issues around building a traditional B2C shopping cart e-commerce site using ASP.NET (VB.NET) and SQLServer. Some of the key functional areas are therefore: –shopping basket –customer registration (and login) –customer