ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason King <jhk...@airmail.net>
Subject Re: how to concate a string in insert statement using ibatis?
Date Thu, 28 Jan 2010 14:18:23 GMT
In Oracle || is the string concatenation operator

'abc'||#orderId# should work.
suprememenu wrote:
>
> suprememenu wrote:
>   
>> hi all,
>>    i would like to know how can i contact a string in insert statemnet
>> using ibatis?
>>
>> insert into knet 
>>       (TRACK_ID, 
>>        STORE_ID,
>>        order_id
>>        DATE
>>        ) 
>>        values(
>>      	 #trackId#,
>> 		#storeId#,
>> 	       'abc'+#orderId#,
>> 		SYSDATE)
>>
>>
>> i mean for the column orderId i need to add a static string . when i tried
>> the above i am getting error ... Cause: java.sql.SQLException: ORA-01722:
>> invalid number
>>
>>     
>
>   


Mime
View raw message