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 > >
