Thx my friend, it worked.
Brian Bruns wrote:
You need to explicitly give it the type, so if AD was an int:
INSERT INTO
HEDEF_TANIMLARI (OID, VERSION, AD)
VALUES (#oid#, #version#, #ad:INT#)
I've not seen Sybase require this, but DB2 needs the type for
Try adding a prepend to workspace_id.
isNotNull property=workspace_Id prepend=BOGUS
...
/isNotNull
The reason this occurs is that the dynamic tag has an automatic
removeFirstPrepend=true. Since the isNotNull:position tag is the first to
produce a prepend it removes the prepend from the
Hi,
With below code how do I get correct value for dependent first name and
dependent last name? Right now as both qol_customer and qol_dependet has
same field name for FIRST_NAME and LAST_NAME, I am getting qol_customer's
FIRST_NAME and LAST_NAME populated in
typeAlias alias=customerVo
type=org.nexweb.qol.gcc.model.CustomerVO/
resultMap id=customerRS class=customerVo
result property=custStatus column=CUST_STATUS/
result property=firstName column=FIRST_NAME/
result property=middleName column=MIDDLE_NAME/
Hi Jasmin,
you should be able to set different column names in your resultmap like
resultMap id=customerRS class=customerVo
result property=custStatus column=CUST_STATUS/
result property=firstName column=FIRST_NAME/
result property=middleName column=MIDDLE_NAME/
I can not change the column names of table QOL_DEPENDENT
from FIRST_NAME to DEP_FIRST_NAME
It has to be the same.
From:
Brandon Goodin brandon.goo...@gmail.com
To:
user-java@ibatis.apache.org
Date:
03/27/2009 11:59 AM
Subject:
Re: How to define alias in resultMap
typeAlias alias=customerVo
You just have to change the result map.
Larry
On Fri, Mar 27, 2009 at 10:03 AM, Jasmin Mehta jasmin_me...@nexweb.org wrote:
I can not change the column names of table QOL_DEPENDENT
from FIRST_NAME to DEP_FIRST_NAME
It has to be the same.
From: Brandon Goodin brandon.goo...@gmail.com
You can specify the columnIndex (yuck).
result property=customerDependentVo.depFirstName
columnIndex=.../
result
property=customerDependentVo.depLastName columnIndex =.../
Brandon Goodin
Silver Mind Software
http://www.silvermindsoftware.com
bgoo...@silvermindsoftware.com
You know rethinking your statement. It makes no sense. You just showed us
the SQL. You can add an alias in the SQL. It does *not* change your table.
It only changes the column name in the result. Then you just map it in the
resultMap like we originally said.
Brandon
On Fri, Mar 27, 2009 at 11:10
You can also poke yourself in the eye with a sharp stick, but in
either case it's a bad idea, imo. :-P
Larry
On Fri, Mar 27, 2009 at 10:10 AM, Brandon Goodin
brandon.goo...@gmail.com wrote:
You can specify the columnIndex (yuck).
result property=customerDependentVo.depFirstName
alias in SQL will work, Sorry I overlooked the SQL change earlier in first
posting. And just saw the table column name in resultMap. I apologies.
Thanks for all your help.
From:
Brandon Goodin brandon.goo...@gmail.com
To:
user-java@ibatis.apache.org
Date:
03/27/2009 12:29 PM
Subject:
Re: How
--
View this message in context:
http://www.nabble.com/Ibatis-%2B-Spring-tp22745182p22745182.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
I am currently working on a project using Spring + Ibatis. DBA's have
recently switched a varchar field into a CLOB field to support large Strings
of data.
My SQL map has the following
result property=filters column=FILTER_DATA jdbcType=CLOB/
which maps to a String object in my java
No problem. I'm glad it worked out for you.
Brandon
On Fri, Mar 27, 2009 at 11:58 AM, Jasmin Mehta jasmin_me...@nexweb.orgwrote:
alias in SQL will work, Sorry I overlooked the SQL change earlier in first
posting. And just saw the table column name in resultMap. I apologies.
Thanks for all
14 matches
Mail list logo
