S2Dao has the following features:
- SQL programmers and Java programmers can work separately on what they know the best
S2Dao is able to read SQL commands written in external files.
These SQL commands may be tested using tools like Oracle SQL*Plus.
Java mappings are written as comments in these files.
Thus, these SQL commands can still be executed.
Files which contain SQL commands with Java codes in comments are called 2 way SQL.
It is also possible to map with Java read in by S2Dao.
As stated, SQL commands are written in external files separately from Java logic programming files. This allows SQL programmers to work independently from Java logic programmers which results in shortening the overall development schedule.
- Automatic generation of SQL commands
If Java method names are named in a prescribed manner, it is possible to generate SQL commands.
In most circumstances, generated SQL command will suffice, but in cases of complex SQL commands or when SQL command needs to be customized, SQL commands should be written manually.