How Does Embedded SQLJ Work?

When you use Embedded SQLJ, you embed SQL statements in your Java source code. You use the SQLJ translator to convert the embedded SQL statements to Java source code with calls to JDBC. JDBC is the JavaSoft specification of a standard application programming interface (API) that allows Java programs to access database management systems.

Finally, you use the Java compiler to compile your translated Java program into an executable Java .class file, as shown in Figure 1.

Figure 1. Translation and Compilation of an Embedded SQLJ Program

When you run your program, it uses the IBM Informix JDBC Driver to connect to an Informix database, as shown in Figure 2.

Figure 2. Runtime Architecture for Embedded SQLJ Programs

See the IBM Informix: JDBC Driver Programmer's Guide for information about using the IBM Informix JDBC Driver.