Achieving Platform-Independent Database Access with Open SQL/SQLJ - Embedded SQL for Java in the SAP Web Application Server

  • by Adrian Goerler, Java Server Technology Group, SAP AG
  • Andreas Fischbach, Java Server Technology Group, SAP
  • January 15, 2004
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.

See more by this author

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.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.