please note the typo
getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws
HibernateException, SQLException {
StatelessSession statelessSession =
session.getSessionFactory().openStatelessSession();
ScrollableResults customers = statelessSession
.getNamedQuery("GetCustomers").scroll(ScrollMode.FORWARD_ONLY);
while ( customers.next() ) {
Customer customer = (Customer) customers.get(0);
customer.updateStuff(...);
statelessSession.update(customer);
}
return null;
}
});
On 4/20/07, Sanjiv Jivan <[EMAIL PROTECTED]> wrote:
On 4/20/07, Jason Brice <[EMAIL PROTECTED]> wrote:
>
> >> However if would still like to use Hibernate for your read-only DB2
> data, make sure you're using Hibernate's StatelessSession API or else you'll
> just be paying a huge CPU and memory overhead using Hiberanate.
>
> Hi Sanjiv,
>
> Is there a way to use the StatelessSession API and still have Spring
> managing the session?
Just get the SessionFactory from the Hibernate Session passed to the
HibernateCallback and from there create the StatelessSession.
getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws
HibernateException, SQLException {
StatelessSession statelessSession =
session.getSessionFactory().openStatelessSession();
ScrollableResults customers = session.getNamedQuery
("GetCustomers").scroll(ScrollMode.FORWARD_ONLY);
while ( customers.next() ) {
Customer customer = (Customer) customers.get(0);
customer.updateStuff(...);
statelessSession.update(customer);
}
return null;
}
});
I've got three Spring managed datasources... one of them is only ever used
> to grab a sequence value out of an Oracle db, which sounds like a big waste
> of resources. But I'd like to keep all the config stuff in one spot and
> don't yet see an obvious way to do this with the StatelessSession API.
>
> Any pointers appreciated.
> Jason
>
>
