SQLJ Reference

This is the source distribution of the SQLJ reference implementation

You must have JDK1.1 or later, JavaCC 0.7.1, GNUmake, and Unix utilities
to compile this source distribution.

If you want to install and compile the sources right away, you can run
gmake and follow the instructions that are displayed.


Oracle, IBM, Sybase, Tandem, Informix, Microsoft, Sun Microsystems, and
others have produced the SQLJ Standard for embedding static SQL statements
and constructs in Java programs (ANSI proposal X3H2 98-227).

SQLJ is a way to reduce the development and maintenance costs of Java
programs that require Database connectivity. SQLJ provides a simpler model
for Java code containing static SQL Statements (SQL which does not change each
time you run your application or applet. Applications typically contain
much more static SQL than dynamic SQL).

The reductions in the development and maintenance costs arise because SQLJ
uses an easier methodology of embedding SQL directly into Java programs,
resulting in code that is more concise and more legible. SQLJ can further
make coding easier by providing compile-time checks on the SQL statements
your application uses. In using dynamic SQL API’s such as JDBC, you won’t
find out if your SQL is syntactically or semantically wrong until you test
the line in your code which runs it.

This implementation is intended to work with any standard JDBC Driver running
against any Database Management System.

For more information visit the SQLJ homepage at


or Oracle’s SQLJ homepage at


If you have questions or suggestions about SQLJ, please send email to:



This distribution contains the source code of the SQLJ reference
implementation. Unless you want to:
– write SQLJ profile customizations, e.g. to support features or
additional databases,
– write SQLJ SQL checkers for particular databases, or
– embed the SQLJ preprocessor in IDE environments
you will probably not need to use this distribution.

Also note, that this distribution contains SOURCE ONLY. Documentation of
the SQLJ specification and the SQLJ preprocessor is packaged with the
binary SQLJ Reference Distribution

This source distribution contains
- this file [README]
- a GNU makefile for building and compiling the source [GNUmakefile]
- a makefile include for specifying the location for generated classes
- one subdirectory for each of the Java packages that make up SQLJ


(1) Unzip the distribution file as per operating system instructions below.
The sources will be installed in a directory sqlj/src.

gzip -dc sqlj___RELEASEFILE__src.tgz | tar xvf -

Use Winzip to unzip sqlj___RELEASEFILE__src.zip to sqlj___RELEASEFILE__src_stored.zip
and then unzip that file.

(2) SQLJ uses Java 1.1 or later. You can download a Java 1.1 or later
development kit from:


SQLJ uses JavaCC 0.7.1 and the Java 1.1 grammar provided with it.
You can download JavaCC (including jjtree) version 0.7.1 from


The Java 1.1 grammar is copyright by Sun Microsystems and can not be
included in this distribution. However, you can obtain it from:


Once you have downloaded it, you must place the Java1.1.jj file into
this directory to allow gmake to continue.

(3) Edit the ClassRepository file to make the repository variable
point to the directory where you want the compiled class files
to be placed.

(4) The oracle.util.javadep package is not part of SQLJ proper.
However, since it is used for ‘gmake depend’ targets, it is also built.

(5) After you have retrieved Java1.1.jj and made changes to ClassRepository,
you can build and compile the source by typing ‘gmake’.

Other targets:
gmake clean – removes created classes and files
gmake all – rebuilds all packages
gmake depend – rebuilds intra-package dependencies
gmake javadoc – creates Javadoc pages for all packages


There is no official Oracle support for this source distribution.

However, your may direct suggestions for fixes and enhancements to:



Oracle expressly places this Software in the public domain.
However, Oracle grants no other rights, whether express or
implied, to users of this Software, and Oracle provides this
Software on an “AS-IS” basis, exclusive of any warranty
including, without limitation, all warranties of merchantability
or fitness for a particular purpose, noninfringement or any other
warranty, whether expressed or implied. You use this Software at
your own risk and agree that Oracle shall not be liable for any
damages, including but not limited to, direct, indirect, incidental,
special, cover, reliance, or consequential damages, arising from
your use of the Software.


SQLJ is built with the Java Compiler Compiler Version 0.7.1 (Parser Generator)
which is Copyright (c) 1996, 1997 Sun Microsystems Inc.

SQLJ utilizes a modified version of the Java Compiler Compiler grammar for
Java 1.1, which is Copyright (C) 1996, 1997 Sun Microsystems Inc.

Posted in SQLJ Articles | Leave a comment

Dominic Scelzi 6/21/14 “King of the West” Heat Race Calistoga Speedway

Dominic Scelzi 6/21/14 “King of the West” Heat Race Calistoga Speedway.

Related Calistoga Videos

Posted in Napa Valley Videos | Tagged , , , , , , , , | 1 Comment

Peju Winery : California Wine with Tony

Peju Winery, a family-owned winery in Napa Valley’s Rutherford, was started by Tony Peju and his wife, Herta, in 1982. Cabernet Sauvignon, Cabernet Franc, an…
Video Rating: 4 / 5

The California Wine Club www.cawineclub.com Contact Us Today 1-800-777-4443 Learn how to use a Wine Decanter.

Posted in Napa Valley Videos | Tagged , , , , | 5 Comments

Dario Sattui – The Mad King of Napa Valley and his Castle

An authentic medieval castle in Napa Valley? A winery with a torture chamber?! Go inside Castello di Amorosa and meet the man who made his crazy fairytale a …
Video Rating: 5 / 5

Related Napa Valley Videos

Posted in Napa Valley Videos | Tagged , , , , , | 7 Comments

Napa Valley Makes History: Stag’s Leap Wine Cellars

Learn about wine and find out how two bottles of Napa Valley wine made history this year and why Stag’s Leap Wine Cellars was listed in “101 Objects That Mad…

Posted in Napa Valley Videos | Tagged , , , , , , , | Comments Off

Smooth Wall Specialists Calistoga CA; Level 4, Level 5 Smooth

SMOOTH WALL Calistoga CA, Level 4 – 5 Smooth Wall Calistoga CA, Smooth Wall Services in Calistoga CA. Level 4 and 5 Drywall Finishing COST Calistoga CA, http…
Video Rating: 0 / 5

Find More Calistoga Videos

Posted in Napa Valley Videos | Tagged , , , , | 1 Comment

GOD IS AN ASTRONAUT – Calistoga (Live @ Proxima, Warsaw, POLAND)

Tuesday, April 15th @ PROXIMA, WARZAWA (POLAND) OFFICIAL BAND WEBSITE: http://superadmusic.com/god/ wikipedia band biography: http://en.wikipedia.org/wiki/Go…
Video Rating: 5 / 5

Find More Calistoga Videos

Posted in Napa Valley Videos | Tagged , , , , , | 1 Comment

CampgroundViews.com – Napa County Fairgrounds Calistoga RV Park – Calistoga California

CampgroundViews.com takes user submitted videos combined with professional editing to provide campers and RV owners with a first person view of campgrounds a…
Video Rating: 1 / 5

Find More Calistoga Videos

Posted in Napa Valley Videos | Tagged , , , , , , | Comments Off

Fly from Napa Valley and enjoy our Hot Air Balloon Rides

Fly from Napa Valley and enjoy our Hot Air Balloon Rides.

Enjoy the Q&A from a special Springtime screening of the amazing documentary “Twenty Feet From Stardom” with director Morgan Neville and one of the film’s st…

More Napa Valley Videos

Posted in Napa Valley Videos | Tagged , , , , , | 7 Comments

Napa Valley Rocks – Viticulture

Viticulture – the process of growing grapes – is an inherent collaboration between people and place. “Napa Valley Rocks: Viticulture” shares some of the secr…

Reupload – Improved quality! 3DO/PSX OST From the 3DO and Playstation release of the series. The music is from the Napa Valley race course. Recorded in real …
Video Rating: 4 / 5

Related Napa Valley Videos

Posted in Napa Valley Videos | Tagged , , , | 6 Comments

Cat Loader – Calistoga Lighted Tractor Parade 2010

Recorded on December 4, 2010 using a Flip Video camcorder.
Video Rating: 5 / 5

More Calistoga Videos

Posted in Napa Valley Videos | Tagged , , , , , | Comments Off