Will it be possible to add support for Oracle's Cursor expression ?
e.g. something like this
select d.id, d.name, cursor(select e.id,e.name from employee e where
e.id_dept = d.id) as employees from dept d;
The jdbc type for the 3rd column is CURSOR or more specifically ORACLEREF
(Ref cursor)
,
Is it a good practice to cache an instance of SqlMapClient in the
HttpSession for each user? I cannot use generic database connections
since data access is granted based on the username and password for
each user.