When working with database views I use Session Beans and
JDBC. You cannot use CMP with views. You could try using BMP with views but you have to be carefull because if you change the view (i.e add some columns or remove some) the beans have to change also.
You could also try using DAO but I think using Session Beans with JDBC it's easy and reliable.