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

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

Stan Getz – Vintage Getz – Live In The Napa Valley 1983 – Part 1

Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, t…

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

Cool Movie images

Some cool movie images:


Flash fired with ebay remote. 580EX II at 1/4 power on stand at waist level from behind through "smoke". A bit of editing on the left side of the photo to remove ugly background.

Day 147 of 365 (Year Two)

We finally managed to make it to the new Indiana Jones movie. While I didn’t think it was as good as the first one, none of the following movies were, it was good. It wasn’t what I expected and I was a bit surprised by the direction they took with the story, but it was fun.

I had issues with refrigerator scene and it felt a bit forced to me. I didn’t really see the purpose in it other than to give us a frame of reference for the timing of the movie. Lead lined or not, you really had to suspend reality to buy into that, but then, considering the direction the story took, it fit right in. Of course, you don’t go see an Indian Jones movie expecting reality.

For once, there were no crying babies in the theater, but we did have a row of kids behind us that I had to shush several times. One of them had no idea what a whisper was and even his friends started shushing him when he would talk, which I was pleased to see (and hear).

A special thanks to Kathy who helped with the set up and shooting.

Learn how to light at Strobist.

Posted in Film Images | Tagged , , | 37 Comments