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
