Re: iBATIS & DB connections

2007-08-07 Thread Clinton Begin
>> Does iBATIS get a new Connection for each query and then close it again afterwards? This totally depends on the connection pool you're using. Since you're using Spring, it's totally up to whichever connection pool spring is using. >> Is it different for select vs insert or update? Normally n

iBATIS & DB connections

2007-08-07 Thread Broderick, Andrew (GE Indust, ES Rail, consultant)
Hi, I am using iBATIS 2.3 with Spring 2 and Oracle 10g. I have a few questions: -Does iBATIS get a new Connection for each query and then close it again afterwards? -Is it different for select vs insert or update? -Does it depend on whether a transaction is open? Thanks, Andrew B

FW: db connections

2005-12-07 Thread James, Steven
I seam to be getting a null return on sqlmap getConnection but if i use getDataSource getConnection that works ok is there any reason for this? And if i use the latter do i need to close the connection myself? Steve. This e-mail and any attachment is for authorised use by the intended reci

db connections

2005-12-06 Thread James, Steven
I seam to be getting a null return on sqlmap.getConnection() but if i use getDataSource().getConnection() that works ok is there any reason for this? And if i use the latter do i need to close the connection myself? Steve. This e-mail and any attachment is for authorised use by the intended