what is sqlj?

[Kavita Ghia]

Hello friends,
Can anyone explain what is sqlj and in what way it is advantageous to use?
Thanks in advance,
Kavita.

[Preethi Suryam]

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. http://www.sqlj.org/
Hope u find this information useful
All the best!
Preethi.

[Carl Trusiak]

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

  void runExample() throws SQLException {
          System.out.println( "Running the example--" );
          // Declare two Java host variables--
         Float salary;
         String ename;
         // Execute a query to retrieve the values.
         // SQLJ uses the standard embedded SQL select ... into syntax--
         #sql { SELECT Ename, Sal INTO :ename, :salary FROM Emp WHERE Empno = 7499 };
          // Print the results--
        System.out.println("Name is " + ename + ", and Salary is " + salary);
  }

Standard JDBC Version

  void runExample() throws SQLException {
          System.out.println( "Running the example--" );
          // Declare two Java host variables--
         Float salary;
         String ename;
         // Execute a query to retrieve the values.
         Statement stmt = conn.createStatement();
         ResultSet rset = stmt.executeQuery("SELECT Ename, Sal FROM Emp WHERE Empno = 7499");
         //get the results
         if(rset.next())
         {
             ename = rset.getString(1);
             salary = rset.getFloat(2);
         }
          // Print the results--
        System.out.println("Name is " + ename + ", and Salary is " + salary);
  }

Hope this helps

[Carol Enderlin]

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) http://technet.oracle.com/tech/java/sqlj_jdbc/htdocs/overview.html and more recent info "Oracle Technology Network Java SQLJ JDBC" http://technet.oracle.com/tech/java/sqlj_jdbc/listing.htm