Ekkehard Rohwedder

It began sometime in late '96 or early '97 ­ JDK 1.0 still ruled and Tandem was still called Tandem, not Digital or Compaq ­ when people from IBM, Tandem and Oracle met and started to muse. "Wouldn't it be nice to have SQL embedded in Java just as it's embedded in other host languages? However, we don't just want to copy previous efforts but to do justice to the Java language." Of course, the embedding would have to permit the use of compiled SQL statements and be just as portable as Java code. It would also need to provide the easiest, most robust way to write SQL code in Java. Sun, Sybase and Informix soon joined the fray....and the "JSQL" effort was born. "Gotcha," you're thinking. "You meant to say SQLJ, didn't you?" Well, yes and no ­ hold off just a second. The JSQL enterprise was all about Java programs that call SQL. When the same informal intercompany worki... (more)

SQL Embedded in Java: Part 1 Starting Out

If you know SQL and Java, and you want to learn SQLJ, this series of articles is for you! I'm going to introduce SQLJ, the standard for embedding database SQL statements in Java programs. You may be familiar with JDBC, an API for talking SQL with the database. SQLJ takes many ideas from JDBC further by providing a language interface for SQL statements in Java. This allows programmers to concentrate on what to say, not how to say it. Take the following SQLJ statement (here aName is a Java variable of type String, and emp is a database table with a numeric column sal and a charact... (more)

Part III Finale: A SQLJ MAGIC SHOW

Several fun and important secrets of SQLJ will be unlocked today. Our show will include the following numbers: Some magic tricks for taming the SQLJ translator to do your bidding. Some incantations to turn you into a SQLJ debug-mon. An initiation to the mysteries of execution contexts - for getting full control over executing SQL statements - and of connection contexts. A happy story of brotherly love between JDBC and SQLJ. A map of the hidden location containing all of the remaining SQLJ details that the wonderful folks from Java Developer's Journal neither would or could let me... (more)