ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cax <cahyadiherma...@gmail.com>
Subject Re: AW: AW: String parameter problem
Date Thu, 09 Jul 2009 17:15:39 GMT

i try to change the sql not to get the parameter, like this :

select
      PX_IR025_PAN as pan,
      F9_IR025_CRN as CRN,
      FX_IR025_EMB_NAME as name,
      FX_IR025_CRD_PGM as crdPgm,
      FX_IR025_UPD_UID as updId 
    from IR025
    where PX_IR025_PAN = '1234567890123456'

and it works....


Andrey Rogov-2 wrote:
> 
> hi Cax, iBatis doesn't resolve sql problems, it is sql mapper.
> try to solve this problem with external sql runner, then copy sql
> to xml files.
> 
> 
> 2009/7/9 Cax <cahyadihermanto@gmail.com>
> 
>>
>> Hi Benjamin,i'd tried this way before also...but it still hit the same
>> problem... :(
>>
>>
>>
>> Benjamin-Klatt wrote:
>> >
>> > No there should not be any limitation that you will have to worry
>> about.
>> > What data type do you use in the database for the PX_IR025_PAN field?
>> >
>> > Can you try to explicitly define your sql data type in the query?
>> > Like: where PX_IR025_PAN = #pan:VARCHAR#
>> >
>> >
>> >
>> >
>> > -----Urspr√ľngliche Nachricht-----
>> > Von: Cax [mailto:cahyadihermanto@gmail.com]
>> > Gesendet: Mittwoch, 8. Juli 2009 19:08
>> > An: user-java@ibatis.apache.org
>> > Betreff: Re: AW: String parameter problem
>> >
>> >
>> > yes,of course.there is a record which match the query. When i try to
>> > change
>> > the data type to Long,it works.but if String,return null value. And
>> > then,when i change the WHERE clause condition,to based on other field
>> > which
>> > the data type is String also like this :
>> >
>> > select
>> >       PX_IR025_PAN as pan,
>> >       F9_IR025_CRN as CRN,
>> >       FX_IR025_EMB_NAME as name,
>> >       FX_IR025_CRD_PGM as crdPgm,
>> >       FX_IR025_UPD_UID as updId
>> >     from IR025
>> >     where FX_IR025_UPD_UID = #updId#
>> >
>> > and it works...FYI,the field length for FX_IR025_UPD_UID is 8 char
>> > only...is
>> > there any length limitation for String data type?
>> >
>> >
>> >
>> > Benjamin-Klatt wrote:
>> >>
>> >> Hi cax,
>> >>
>> >> have you tried to execute the query directly on the database to ensure
>> >> there
>> >> is a result for your query?
>> >>
>> >> br
>> >> Benjamin
>> >>
>> >>
>> >> -----Urspr√ľngliche Nachricht-----
>> >> Von: Cax [mailto:cahyadihermanto@gmail.com]
>> >> Gesendet: Mittwoch, 8. Juli 2009 17:31
>> >> An: user-java@ibatis.apache.org
>> >> Betreff: Re: String parameter problem
>> >>
>> >>
>> >> Hi,i turn on Log4j,but i can't see what is the problem in the log
>> >> file..here
>> >> is the result in the log file :
>> >>
>> >> 2009-07-08 21:59:12,422 DEBUG main
>> >> com.ibatis.common.jdbc.SimpleDataSource
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl - Created
>> >> connection 35293.
>> >> 2009-07-08 21:59:12,438 DEBUG main java.sql.Connection
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl -
>> >> {conn-100000}
>> >> Connection
>> >> 2009-07-08 21:59:12,438 DEBUG main java.sql.Connection
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl -
>> >> {conn-100000}
>> >> Preparing Statement:      select       PX_IR025_PAN as pan,
>> >> F9_IR025_CRN as CRN,       FX_IR025_EMB_NAME as name,
>> >> FX_IR025_CRD_PGM
>> >> as crdPgm,       FX_IR025_UPD_UID as updId      from IR025     where
>> >> PX_IR025_PAN = ?
>> >> 2009-07-08 21:59:12,703 DEBUG main java.sql.PreparedStatement
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl -
>> >> {pstm-100001}
>> >> Executing Statement:      select       PX_IR025_PAN as pan,
>> >> F9_IR025_CRN as CRN,       FX_IR025_EMB_NAME as name,
>> >> FX_IR025_CRD_PGM
>> >> as crdPgm,       FX_IR025_UPD_UID as updId      from IR025     where
>> >> PX_IR025_PAN = ?
>> >> 2009-07-08 21:59:12,703 DEBUG main java.sql.PreparedStatement
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl -
>> >> {pstm-100001}
>> >> Parameters: [1234567890123456]
>> >> 2009-07-08 21:59:12,703 DEBUG main java.sql.PreparedStatement
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl -
>> >> {pstm-100001}
>> >> Types: [java.lang.String]
>> >> 2009-07-08 21:59:12,734 DEBUG main java.sql.ResultSet
>> >> com.ibatis.common.logging.jakarta.JakartaCommonsLoggingImpl -
>> >> {rset-100002}
>> >> ResultSet
>> >> 2009-07-08 22:08:43,805 ERROR main ibatis.com.mydomain.data.Main
>> >> ibatis.com.mydomain.data.Main - java.lang.NullPointerException
>> >>
>> >>
>> >> Andrey Rogov-2 wrote:
>> >>>
>> >>> hi ,
>> >>> turn on Log4j and look at the sql statement, prepare, parameter and
>> >>> query
>> >>> result .
>> >>>
>> >>>
>> >>>
>> >>> 2009/7/7 Cax <cahyadihermanto@gmail.com>
>> >>>
>> >>>>
>> >>>> hello, I got a problem in iBatis, i hope somebody could help me...
>> >>>> i hit problem when i pass in a parameter which the data type is
>> string,
>> >>>> and
>> >>>> the field length in database is 19 char. But,it throws exception
>> >>>> because
>> >>>> the
>> >>>> returned object is null. and then i try to change the WHERE clause
>> >>>> condition,to based on other field which the data type is number,and
>> it
>> >>>> works...
>> >>>> i want to know what is the problem,is the string value too long
or
>> >>>> what?
>> >>>>
>> >>>> below is my code example :
>> >>>>
>> >>>> <select id="selectAccountById" parameterClass="Account"
>> >>>> resultClass="Account">
>> >>>>    select
>> >>>>      PX_IR025_PAN as pan,
>> >>>>      F9_IR025_CRN as CRN,
>> >>>>      FX_IR025_EMB_NAME as name,
>> >>>>      FX_IR025_CRD_PGM as crdPgm,
>> >>>>      FX_IR025_UPD_UID as updId
>> >>>>    from IR025
>> >>>>    where PX_IR025_PAN = #pan#
>> >>>> </select>
>> >>>>
>> >>>>
>> >>>> in java:
>> >>>>
>> >>>> Account acc = new Account();
>> >>>>
>> >>>> acc.setpan("1234567890123456");
>> >>>>
>> >>>> acc = (Account) sqlMapper.queryForObject("selectAccountById", acc);
>> >>>> //(Note : return null)
>> >>>> System.out.println("  " + acc.getname());
>> >>>>
>> >>>>
>> >>>> Thanks before for your help....:-)
>> >>>>
>> >>>>
>> >>>>
>> >>>> --
>> >>>> View this message in context:
>> >>>>
>> http://www.nabble.com/String-parameter-problem-tp24370405p24370405.html
>> >>>> Sent from the iBATIS - User - Java mailing list archive at
>> Nabble.com.
>> >>>>
>> >>>>
>> >>>>
>> ---------------------------------------------------------------------
>> >>>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> >>>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/String-parameter-problem-tp24370405p24393125.html
>> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >>
>> >>
>> >>
>> >
>> > --
>> > View this message in context:
>> > http://www.nabble.com/String-parameter-problem-tp24370405p24395565.html
>> > Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> > For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> > For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/String-parameter-problem-tp24370405p24410991.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/String-parameter-problem-tp24370405p24414345.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message