Support for Oracle's CURSOR expression.

2008-06-04 Thread gumnaam23
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) ,

Cache SqlMapClient in HttpSession - Good Practice?

2008-06-04 Thread Open Source Hunter
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.