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