Hi Suresh,Give us your current SQLMap XML for this, and the code for the beans/POJOs involved. Without seeing the configuration of your result maps, it's hard to help you.Ted
On 18/04/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am using following select query.
Select * from
Hi,
I have a sybase procedure which doesnt take any
parameter. Its a combination of few select statements. Can someone please help
me with the syntax where parameter property is blank.
Can someone help me with this block -
parameterMap
id="getOrders" resultClass="java.util.HashMap"
Try this:
typeAlias alias=order type=pojo.Order /
resultMap id=orderResult class=order
result property=prop1 column=column1/
result property=prop2 column=column2/
/resultMap
procedure id=getOrders resultMap=orderResult
{call get_data()}
/procedure
[EMAIL
Hi,
I don't have any property to specify. Please let me know.
Regards,
Suman Mishra
203-719-1698
-Original Message-
From: Beemsterboer Software [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 12:17 PM
To: user-java@ibatis.apache.org
Subject: Re: Procedures in iBatis
Try
HiI have two lists that I need to iterate in order in build my SQL statement. I would like to know how I would go about in doing that using iBatis.I have 2 list: partitionList=[01, 02]; IDList=[10001, 10002];Basically it should look like this: SELECT DISTINCT NVL(attr_display_name,
I havea fewquestions regarding iBatis
cacheModel. All help is greatly
appreciated.
1) When the iBatis cacheModel is used,a
connection to the database server appears tobe still required. The data
has been cached, so I'm not sure why the database server needs to be up after
caching the
For 1):
do you have the full nested stacktrace? Did you deactivate the ping
query? and are you sure the exception originates in iBATIS (we'll see
from the full stacktrace). The intention of a cache is to speed things
up, it's not the intention to have a complete in-core database.
For 2)
Title: Two quick questions..
1. Can I selectively use lazy loading for some results but not others? How do I specify this? I only see one global setting in sqlMapConfig.xml.
2. How does iBatis caching know that data/object to be retrieved is already in cache? Does it use SQL statement as
Title: Two quick questions..
I'll add to those questions
1) Be careful when updating cached data in a transactional
environment. If you update a cached object, then calling a rollback will
undo db changes but not changes to the object in memory. You should clone
cached object before