Advantages and Disadvantages
Some advantages of SQLJ over JDBC include:
- SQLJ commands tend to be shorter than equivalent JDBC programs.
- SQL syntax can be checked at compile time. The returned query results can also be checked strictly.
- Preprocessor might generate static SQL which performs better than dynamic SQL because query plan is created on program compile time, stored in database and reused at runtime. Static SQL can guarantee worst case reply time and access plan stability. IBM DB2 supports static SQL use in SQLJ programs.
Disadvantages include:
- SQLJ requires a preprocessing step.
- Many IDEs do not have SQLJ support.
- SQLJ lacks support for most of the common persistence frameworks, such as Hibernate.
Read more about this topic: SQLJ, SQLJ Part 0
Famous quotes containing the word advantages:
“... there are no chains so galling as the chains of ignorance—no fetters so binding as those that bind the soul, and exclude it from the vast field of useful and scientific knowledge. O, had I received the advantages of early education, my ideas would, ere now, have expanded far and wide; but, alas! I possess nothing but moral capability—no teachings but the teachings of the Holy Spirit.”
—Maria Stewart (1803–1879)