It's not a secret anymore!
The moose likes Java in General and the fly likes what is sqlj? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "what is sqlj?" Watch "what is sqlj?" New topic

what is sqlj?

Kavita Ghia
Ranch Hand

Joined: Oct 10, 2000
Posts: 91
Hello friends,
Can anyone explain what is sqlj and in what way it is advantageous to use?
Thanks in advance,
Preethi Suryam
Ranch Hand

Joined: Nov 17, 2000
Posts: 92
Hi Kavitha!
Even i am new to this SQLJ.i browsed through all the sites and finally found some information.
SQLJ is an emerging standard for you to use a set of programming extensions to embed Structured Query Language (SQL) database requests and statements into Java. The embedded SQL statements comply with the ANSI-standard SQLJ Language Reference syntax. You run a SQLJ translator that converts the SQLJ program to a standard Java program, replacing the embedded SQL statements with calls to SQLJ runtime. The generated Java program is compiled using any Java compiler and run against a database. The SQLJ runtime environment consists of a thin SQLJ runtime library that is implemented in pure Java. It calls a Java Database Connectivity (JDBC) driver targeting the appropriate database. Because SQLJ programs are converted to JDBC, they retain their multi-vendor interoperability, and can be used with any JDBC drivers. SQLJ is similar to the ANSI/ISO "embedded SQL" specificiations that prescribe how static SQL is embedded in C, FORTAN, COBOL, and other languages.
For more information pls visit this site.
Hope u find this information useful
All the best!
Carl Trusiak

Joined: Jun 13, 2000
Posts: 3340
SQLJ is a standard way to embed static SQL statements in Java programs. The standard is being developed by a number of software vendors, including IBM, Tandem, Sybase, and JavaSoft, along with Oracle. SQLJ applications are portable and can communicate with databases from multiple vendors using standard JDBC drivers.
It can make programming a database program a little easier
sqlj version

Standard JDBC Version

Hope this helps

I Hope This Helps
Carl Trusiak, SCJP2, SCWCD
Carol Enderlin
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
I came because of the book giveaway and learned something from this interesting thread. I poked around oracle's site and found an old overview on SQLJ (Sep 1999 from Oracle's perspective, of course) and more recent info "Oracle Technology Network Java SQLJ JDBC"
I agree. Here's the link:
subject: what is sqlj?
It's not a secret anymore!