Starting with Release 6.20, the SAP Web Application Server (Web AS) contains a full-fledged J2EE server that provides standard Java support for SAP applications. However, the techniques for accessing relational databases directly from Java in Web AS 6.20 remained largely platform-specific and code-intensive. Web AS 6.30 introduces Open SQL for Java, a framework for relational database access that provides an API - Open SQL/SQLJ - for achieving true platform-independent database access with design-time checking. This article introduces you to Open SQL/SQLJ and, using several practical examples, shows you how to take full advantage of its key features.
Adrian Goerler
Adrian Görler studied physics at the Ruprecht-Karls-University in Heidelberg, Germany, where he specialized in computational biophysics. He received his doctorate at the Max-Planck-Institute for Medical Research, Heidelberg, and did postdoctoral research work in various international laboratories. In 1999, Adrian joined SAP and became a member of the Business Programming Languages group, where he worked as a kernel developer responsible for the implementation and maintenance of Open SQL as well as Native SQL in ABAP. Since 2001, Adrian has been a member of the Java Server Technology group, where he has been working on the implementation of Open SQL for Java, especially Open SQL/SQLJ.
You may contact the author at
adrian.goerler@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the
editor.
Andreas Fischbach
Andreas Fischbach studied Commercial Information Technology and received his diploma in 1996. During that same year, he joined the SAP/Informix porting team, where he was responsible for Informix-specific aspects of the SAP R/3 system. In 2001, Andreas started working on Java persistence in the Java Server Technology group. He focuses mainly on relational persistence, in particular SQLJ. Additionally, Andreas is engaged in object persistence with JDO.
You may contact the author at
andreas.fischbach@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the
editor.
Premium
