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, 23 Jul 2009 09:56:43 GMT

yes,i solve the problem..Thx


Andrey Rogov-3 wrote:
> 
> 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
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/String-parameter-problem-tp24370405p24622698.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