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 <cahyadiherma...@gmail.com>
>
>>
>> I use Oracle database.
>>
>>
>> Sergey Livanov-2 wrote:
>> >
>> > What database do you use ?
>> >
>> > 2009/7/9 Cax <cahyadiherma...@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 <cahyadiherma...@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:cahyadiherma...@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:cahyadiherma...@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 <cahyadiherma...@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-unsubscr...@ibatis.apache.org
>> >> >> >>>> For additional commands, e-mail:
>> user-java-h...@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-unsubscr...@ibatis.apache.org
>> >> >> >> For additional commands, e-mail:
>> user-java-h...@ibatis.apache.org
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> ---------------------------------------------------------------------
>> >> >> >> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
>> >> >> >> For additional commands, e-mail:
>> user-java-h...@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-unsubscr...@ibatis.apache.org
>> >> >> > For additional commands, e-mail: user-java-h...@ibatis.apache.org
>> >> >> >
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
>> >> >> > For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org
>> >> >> For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org
>> >> For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org
>> For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
