Structured Query Language in Java (SQLJ) supported with WebSphere Application Server
 Technote (troubleshooting)
 
Problem(Abstract)
Structured Query Language in Java™ (SQLJ) is only supported for DB2® as the backend database.
 
Cause
SQLJ is a set of programming extensions that allow a programmer, using the Java programming language, to embed statements that provide SQL (Structured Query Language) database requests.


Advantages of developing applications with SQLJ include improved performance and a shorter, more efficient development cycle:

  • You improve performance by using static SQL statements.
  • You reduce the development cycle because you write less code with the simpler SQLJ syntax, which reduces the number of lines of code required to execute statements, and to set and retrieve parameters.

You might consider using SQLJ in situations where dynamic SQL is not needed, and where applications use DB2 as the backend database.
 
Resolving the problem
All versions of WebSphere® Application Server V5.0, V5.1. and V6.0 support SQLJ if application uses DB2 as the backend database. It does not support SQLJ with other databases like Oracle, Sybase, Informix®, SQL Server, Cloudscape™ and others.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 6.0
Software edition:
Reference #: 1270649
IBM Group: Software Group
Modified date: Sep 14, 2007