Re: Issue with Ibatis in Websphere

2006-12-21 Thread Ashish Kulkarni
Hi Thanks, for now i have changed my code as Jeff suggested and testing it, still now not seen any major issues, and hope it continues that way. Ashish On 12/19/06, Clinton Begin <[EMAIL PROTECTED]> wrote: Exactly. This interface isn't perfect either though...I have better ideas. It's fine u

Re: Issue with Ibatis in Websphere

2006-12-19 Thread Clinton Begin
Exactly. This interface isn't perfect either though...I have better ideas. It's fine until you need transactions, then you have to nest try/finally blocks for the session and transaction. Session never did work out how I expected in iBATIS, and really it's just a higher level abstraction for a

Re: Issue with Ibatis in Websphere

2006-12-18 Thread Jeff Butler
SqlMapSession session = sqlMapClient.openSession(conn); try { session.queryForList("getItemFormat","myname"); } finally { session.close (); } Jeff Butler On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: Hi How do i replace my existing code with sqlMapClient.openSession(myConnection

Re: Issue with Ibatis in Websphere

2006-12-18 Thread Ashish Kulkarni
Hi How do i replace my existing code with sqlMapClient.openSession(myConnection); My excisting code is as below client.setUserConnection(conn); client.queryForList("getItemFormat","myname" ); Regards Ashish On 12/18/06, Clinton Begin <[EMAIL PROTECTED]> wrote: GACK.. setUserConnection()

Re: Issue with Ibatis in Websphere

2006-12-18 Thread Clinton Begin
GACK.. setUserConnection() is another API we should deprecate. A cleaner way to do it is: SqlMapSession session = sqlMapClient.openSession(myConnection); try { //do work. } finally { session.close(); } Cheers, Clinton On 12/18/06, Jeff Butler <[EMAIL PROTECTED]> wrote: This is very

Re: Issue with Ibatis in Websphere

2006-12-18 Thread Jeff Butler
This is very similar to this issue: http://issues.apache.org/jira/browse/IBATIS-66 Make sure you're calling client.setUserConnection(null) after processing each query. Jeff Butler On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: Hi I have attached the sqlmap and xml file with all th

Re: Issue with Ibatis in Websphere

2006-12-18 Thread Ashish Kulkarni
Hi I have attached the sqlmap and xml file with all the sql statements along this mail. On 12/18/06, Larry Meadors <[EMAIL PROTECTED]> wrote: Can you post your configuration (database and sqlmap)? Larry On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hi > We have a web applicat

Re: Issue with Ibatis in Websphere

2006-12-18 Thread Larry Meadors
Can you post your configuration (database and sqlmap)? Larry On 12/18/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: Hi We have a web application running in websphere, and for a while we are seeing some hung threads in websphere, do we did some java dump as insturcted by IBM and we are seein

Issue with Ibatis in Websphere

2006-12-18 Thread Ashish Kulkarni
Hi We have a web application running in websphere, and for a while we are seeing some hung threads in websphere, do we did some java dump as insturcted by IBM and we are seeing some of the following messages in the dump. In our java program before calling SQL statemenet we do the following SqlMap