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
