ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Livanov <Sergey.Liva...@ukrpost.net>
Subject Re[2]: simple question
Date Thu, 12 May 2005 18:19:47 GMT
Thank you a lot, Brandon.
BG> it should be okay to use dynamic. What version of iBatis are you using?
2.0.8

When I remove <dynamic></dynamic> it does'not work too. 
I'd like to ask you to see to Log4j java PreparedStatement:. 
The parameters are correct, but 
<dynamic><isGreaterThan prepend="and" property="owner" compareValue="0"></dynamic>

construction has been kept,
and this SQL operator would not work. 

Sergey.

BG> Brandon

BG> On 5/12/05, Pedro Emanuel Castro Faria Salgado <registration@04web.com> wrote:
>> On 12/05/2005 15:39, "Sergey Livanov" <Sergey.Livanov@ukrpost.net> wrote:
>> 
>> >
>> > Could you, please, help me find an error,
>> > very simple statement, but not work..
>> >
>> > <statement id="getPayorders" resultMap="payorder_result">
>> >
>> >   select d.payorder
>> >     from fin.payorders d
>> >    where d.partner = #partner#
>> 
>> Take off the <dynamic>?
>> 
>> Below a working example that I have:
>> 
>> SELECT *
>> FROM myTable
>> WHERE condition_clause AND some_other_condition_clause
>>         <isNotNull prepend="AND" property="description">
>> description LIKE #description#
>>         </isNotNull>
>> 
>> >    <dynamic>
>> >      <isGreaterThan prepend=" and " property="owner" compareValue="0">
>> >          d.owner = #owner#
>> >      </isGreaterThan>
>> >    </dynamic>
>> >
>> > </statement>
>> >
>> > without dynamic all works,
>> > Log4J text.
>> >
>> > 2005-05-12 16:26:52,718 INFO main TestIbatis TestIbatis - Executing:
>> > 2005-05-12 16:26:53,703 DEBUG main com.ibatis.common.jdbc.SimpleDataSource
>> > com.ibatis.common.jdbc.SimpleDataSource - Created connection 8002486.
>> > 2005-05-12 16:26:53,703 DEBUG main java.sql.Connection
>> > com.ibatis.common.jdbc.logging.ConnectionLogProxy - {conn-100000} Connection
>> > 2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
>> > com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-100001}
>> > PreparedStatement:
>> > select d.payorder from sell.payorders d where d.partner = ?
>> > <dynamic><isGreaterThan prepend=" and " property="owner"
>> >  compareValue="0"> d.owner = ? </isGreaterThan></dynamic>
>> > 2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
>> > com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-100001}
>> > Parameters: [1, 15842]
>> > 2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
>> > com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-100001}
>> > Types: [java.lang.Long, java.lang.Long]
>> > 2005-05-12 16:26:53,781 DEBUG main com.ibatis.common.jdbc.SimpleDataSource
>> > com.ibatis.common.jdbc.SimpleDataSource - Returned connection 8002486 to pool.
>> >
>> 
>>



-- 
Ñ óâàæåíèåì,
 Sergey                          mailto:Sergey.Livanov@ukrpost.net


Mime
View raw message