yes,i solve the problem..Thx
Andrey Rogov-3 wrote: > > do you solve problem ? > > 2009/7/23, Cax <cahyadiherma...@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 <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 >> >> > > --------------------------------------------------------------------- > 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-tp24370405p24622698.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
