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
