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.
- 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.
Other articles related to "advantages and disadvantages, advantages, advantage, 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 ...
... 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 ...
... 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 ...
... 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)