Relational persistence: Most Java database programmers rely on the proven JDBC API. Why does SAP promote the newer standard, SQLJ?

We highly appreciate and support the JDBC-based application components! However, as we have learned over years, static SQL checks significantly improve the system reliability and maintainability and enormously speed the whole development process, first of all the testing phase. The SQLJ API even provides the static checks for your SQL statements.

If you save your SQLJ source file, the SQLJ Checker immediately checks firstly the SQL syntax and secondly the accordance of the embedded names and types of database objects (tables, columns, and indexes) with the definitions in the database catalog. Try mixing SQLJ and JDBC: With SAP Web AS, you can convert the SQLJ connection context to the JDBC connection, and vice versa, in a straightforward manner. The same holds for JDBC result sets and SQLJ iterators.

You can run SQLJ- and JDBC-based code even in the same database transaction. Both Open SQL/SQLJ and Open SQL/JDBC support the identical portable SQL set. More.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions