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 <[email protected]>
>
>>
>> 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:[email protected]]
>> > Gesendet: Mittwoch, 8. Juli 2009 19:08
>> > An: [email protected]
>> > 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:[email protected]]
>> >> Gesendet: Mittwoch, 8. Juli 2009 17:31
>> >> An: [email protected]
>> >> 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 <[email protected]>
>> >>>
>> >>>>
>> >>>> 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: [email protected]
>> >>>> For additional commands, e-mail: [email protected]
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >> --
>> >> 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: [email protected]
>> >> For additional commands, e-mail: [email protected]
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: [email protected]
>> >> For additional commands, e-mail: [email protected]
>> >>
>> >>
>> >>
>> >
>> > --
>> > 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: [email protected]
>> > For additional commands, e-mail: [email protected]
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: [email protected]
>> > For additional commands, e-mail: [email protected]
>> >
>> >
>> >
>>
>> --
>> 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: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
>
--
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: [email protected]
For additional commands, e-mail: [email protected]
