Re: LazyLoading and CGLIB return wrong types

2009-07-22 Thread Dawson Lewis
Thanks for you reply Larry, Is there a way I can get the "normal" Address objects ? I need to serialize those objects to XML , the extra fields in these enhanced classes will create problems when deserializing because maybe the application that will deserialize is not using iBatis. Can't I just d

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 CRN,

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 rown

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: 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, handler

RE: size of paginated list

2009-07-22 Thread Andrey Rogov
select count(*) From your_table Your expression 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 of the paginated

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 t

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

Re: weird behavior

2009-07-22 Thread Larry Meadors
On Wed, Jul 22, 2009 at 12:29 PM, David McReynolds 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 trying to figure tha

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 > mailto:dmcreyno...@securew

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

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 is

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 Account

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) sq

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 Lewis wrote: > > Hi , > > I have an object with a List property - List addresses, after > iBatis populates this object  the addresses fields will not contain a list > of address objects but a List$$

LazyLoading and CGLIB return wrong types

2009-07-22 Thread Dawson Lewis
Hi , I have an object with a List property - List 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 enhancementEnab

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 an

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: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.ugref/db2

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