SQLJ - SQLJ Part 0 - Advantages and Disadvantages

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

Other articles related to "advantages and disadvantages, advantages, advantage, disadvantages":

Superheater - Advantages and Disadvantages
... The main advantages of using a superheater are reduced fuel and water consumption but there is a price to pay in increased maintenance costs ... In locomotives used for mineral traffic the advantages seem to have been marginal ...
C-4 (explosive) - Characteristics and Uses - Advantages
... A major advantage of C4 is that it can easily be molded into any desired shape ... C4 can be pressed into gaps, cracks, holes and voids in buildings, bridges, equipment or machinery ...
Leather Currency - Advantages and Disadvantages
... Banknotes have a natural advantage over coins in that they are lighter to carry but are also less durable ... The different disadvantages between coins and banknotes imply that there may be an ongoing role for both forms of bearer money, each being used where its advantages outweigh its disadvantages ...
Learning By Teaching By Martin (LdL) - The LdL Approach - Advantages and Disadvantages
... They state the following advantages and disadvantages Advantages Student work is more motivated, efficient, active and intensive due to lowered inhibitions and an ... planning abilities reliability presentation and moderation skills self-confidence Disadvantages The introduction of the method requires a lot of time ...

Famous quotes containing the word advantages:

    But there are advantages to being elected President. The day after I was elected, I had my high school grades classified Top Secret.
    Ronald Reagan (b. 1911)