April 2003
Intermediate to advanced
750 pages
16h 53m
English
When you generate the deployed code, EJB QL statement are converted into SQL. You can find the generated SQL statements for the Account bean in the package itso.bank5.cmp.websphere_deploy.DB2UDBNT_V72_1 and class called AccountFunctionSet. Let’s look at two examples.
The simple EJB QL statement select object(o) from Account o translates into:
select q1.\"ACCID\", q1.\"BALANCE\", q1.\"INTEREST\", q1.\"ACCTYPE\", q1.\"DISCRIMINATOR\", q1.\"MINAMOUNT\", q1.\"OVERDRAFT\" from ITSO.ACCOUNT q1 where ( ( q1.\"DISCRIMINATOR\" = \'A\') or ( q1.\"DISCRIMINATOR\" = \'S\') or ( q1.\"DISCRIMINATOR\" = \'C\') )
The EJB QL statement is:
findlargestAccount(int ...
Read now
Unlock full access