Re: Prepared Statement cache

2009-07-22 Thread Mario Ds Briggs
The statement cache is configured on the Data Source properties in WAS. You probably want to check with your WAS admin what's the minimal way of flushing it without bouncing WAS itself ( bouncing the app alone wont help) Mario

Re: Prepared Statement cache

2009-07-22 Thread Nicholoz Koka Kiknadze
Maybe I'm totally wrong, but I'm almost sure it must be possible to force database server to RE-generate execution plans even for cached statements. I've never used DB2 but googling a little I found:

Questions regd ibatis best practices - need some help here

2009-07-22 Thread swaroop belur
Hello all, Is there any pointer/link or document which suggests using certain features over others to achieve the same goal to improve performance for example. 1. Like for instance when executing an update query , we can either specify parameterClass or parameterMap Which one is preferred

LazyLoading and CGLIB return wrong types

2009-07-22 Thread Dawson Lewis
Hi , I have an object with a List property - ListAddress addresses, after iBatis populates this object the addresses fields will not contain a list of address objects but a List$$EnhancerCGLIBb$$475a4210 , according to the eclipse debugger. This only happens when lazyLoadingEnabled and

Re: LazyLoading and CGLIB return wrong types

2009-07-22 Thread Larry Meadors
They are still Address objects, just enhanced ones. Larry On Wed, Jul 22, 2009 at 7:58 AM, Dawson Lewishardcore...@yahoo.com.br wrote: Hi , I have an object with a List property - ListAddress addresses, after iBatis populates this object  the addresses fields will not contain a list of

Programatically investigate namespace configuration

2009-07-22 Thread Ryborg
Is there a way to programatically investigate the configuration settings of an SqlMapClient? I would like to check the configuration to see if namespaces are enabled, and do something like the following: useNamespaces = getSqlMapClientProperty(useStatementNamespaces) if (useNamespaces)

Abator generated classes and MVC

2009-07-22 Thread Vinaya Tirikkovalluru
Hi, I am using iBatis in my application with JSF and Spring. We are using ABator to generate the objects based on the database objects. For example Account table will have Account.java AccountExample.java AccountDAO.java

weird behavior

2009-07-22 Thread David McReynolds
Anyone know under what circumstances ibatis would fail to locate a record when I can take the query from the log and run it and find the record. The field I'm searching on is a simple integer. Turned on debug for java.sql and ibatis. The query is logged, along with the parameter. The result set

Re: weird behavior

2009-07-22 Thread Brandon Goodin
perhaps you haven't specified a resultClass/resultMap? Brandon Goodin On Wed, Jul 22, 2009 at 12:38 PM, David McReynolds dmcreyno...@secureworks.net wrote: Anyone know under what circumstances ibatis would fail to locate a record when I can take the query from the log and run it and find the

Re: weird behavior

2009-07-22 Thread David McReynolds
DOH! There are only two kinds of programming errors: stupid programmer mistakes and stupid programmer mistakes. Brandon Goodin wrote: perhaps you haven't specified a resultClass/resultMap? Brandon Goodin On Wed, Jul 22, 2009 at 12:38 PM, David McReynolds dmcreyno...@secureworks.net

Re: weird behavior

2009-07-22 Thread Larry Meadors
On Wed, Jul 22, 2009 at 12:29 PM, David McReynoldsdmcreyno...@secureworks.net wrote: There are only two kinds of programming errors: stupid programmer mistakes and stupid programmer mistakes. Brandon Goodin wrote: perhaps you haven't specified a resultClass/resultMap? I've never spent a day

Re: Abator generated classes and MVC

2009-07-22 Thread Jeff Butler
My opinion, and it is just opinion, is that Account and AccountExample are *sort of* like model classes (although Account suffers from the anemic domain model disease). AccountDAO and AccountDAOImpl are service classes - to be used by the controller layer. Ultimately, my view is that these are

size of paginated list

2009-07-22 Thread Odelya YomTov
Hi! I need to know the size of the paginated list (not per page). Because if I do: orderList.getPageSize - I get the amount of records per page, and I need to know in general how many records are there in the database. For example: If my page size is 10, and the query should return 15, it should

RE: size of paginated list

2009-07-22 Thread Andrey Rogov
select count(*) From your_table dynamic Your expression /dynamic Before select. -Original Message- From: Odelya YomTov [mailto:ode...@jpost.com] Sent: Wednesday, July 22, 2009 11:17 PM To: user-java@ibatis.apache.org Subject: size of paginated list Hi! I need to know the size

RE: Abator generated classes and MVC

2009-07-22 Thread Vinaya Tirikkovalluru
Thanks for your opinion Jeff. I agree that DAO and Impl so in controller. Right now I have a delegate pattern which delegates the calls to DAO from the service layer. More clearly... I have a view layer, model layer Model layer has all the Abator generated code, View has all the beans,

RE: size of paginated list

2009-07-22 Thread Odelya YomTov
Right But I prefer not to call 2 different queries.. can I do it in one query? -Original Message- From: Andrey Rogov [mailto:konu...@gmail.com] Sent: Wednesday, July 22, 2009 9:44 PM To: user-java@ibatis.apache.org Subject: RE: size of paginated list select count(*) From your_table

RE: size of paginated list

2009-07-22 Thread Andrey Rogov
For oracle you can write ( something like this ) select * from ( select rownum as rnum , g.good , g.namerus , cnt.count from servers.goods g , ( select count(*) as count from servers.goods g1 ) cnt where

Re: AW: AW: String parameter problem

2009-07-22 Thread Cax
Finally,i know what is the problem...that is because of the declared length of PX_IR025_PAN in database is 19 CHAR..but the data is only contain 16 CHAR...that's why I can't get the result,so I should put a TRIM in the query to remove the last 3 CHAR..like this : select F9_IR025_CRN as