ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Rogov <konu...@gmail.com>
Subject Re: AW: AW: String parameter problem
Date Thu, 23 Jul 2009 09:40:55 GMT
do you solve problem ?

2009/7/23, Cax <cahyadihermanto@gmail.com>:
>
> Finally,i know what is the problem...that is because of the declared length
> of PX_IR025_PAN in database is 19 CHAR..but the data is only contain 16
> CHAR...that's why I can't get the result,so I should put a TRIM in the query
> to remove the last 3 CHAR..like this :
>
> select
>       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 TRIM(PX_IR025_PAN) = #pan#
>
> and it's working now...
> Thanks for all of your suggestions to help me...:-)
>
>
> Andrey Rogov-2 wrote:
>>
>> mail me DDL table properties and IR025data .
>>
>> 2009/7/10 Cax <cahyadihermanto@gmail.com>
>>
>>>
>>> I use Oracle database.
>>>
>>>
>>> Sergey Livanov-2 wrote:
>>> >
>>> > What database do you use ?
>>> >
>>> > 2009/7/9 Cax <cahyadihermanto@gmail.com>
>>> >
>>> >>
>>> >> 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
>>> >>
>>> >>
>>> >
>>> >
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/String-parameter-problem-tp24370405p24419592.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-tp24370405p24619051.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


Mime
View raw message