• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

what is sqlj?

 
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello friends,
Can anyone explain what is sqlj and in what way it is advantageous to use?
Thanks in advance,
Kavita.
 
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
drifter
Posts: 1364
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic