Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 75737 invoked from network); 23 Jul 2009 04:19:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 23 Jul 2009 04:19:02 -0000 Received: (qmail 2324 invoked by uid 500); 23 Jul 2009 04:20:06 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 2269 invoked by uid 500); 23 Jul 2009 04:20:05 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 2261 invoked by uid 99); 23 Jul 2009 04:20:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jul 2009 04:20:05 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jul 2009 04:19:55 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1MTpmH-0006SX-Of for user-java@ibatis.apache.org; Wed, 22 Jul 2009 21:19:33 -0700 Message-ID: <24619051.post@talk.nabble.com> Date: Wed, 22 Jul 2009 21:19:33 -0700 (PDT) From: Cax To: user-java@ibatis.apache.org Subject: Re: AW: AW: String parameter problem In-Reply-To: <43c99d630907110717m5a884968x6265a21feac978c8@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: cahyadihermanto@gmail.com References: <24370405.post@talk.nabble.com> <43c99d630907071135t6c7a4d3ejf6633338ab6e9a94@mail.gmail.com> <24393125.post@talk.nabble.com> <006a01c9ffe4$66370d00$32a52700$@de> <24395565.post@talk.nabble.com> <009301c9fff4$aef00b40$0cd021c0$@de> <24410991.post@talk.nabble.com> <43c99d630907090927t889ece1l327de8545ed8443@mail.gmail.com> <24414345.post@talk.nabble.com> <17938a6b0907091028o2edf8adfj99d28d6201ed6967@mail.gmail.com> <24419592.post@talk.nabble.com> <43c99d630907110717m5a884968x6265a21feac978c8@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org 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 quer= y 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) =3D #pan# and it's working now... Thanks for all of your suggestions to help me...:-) Andrey Rogov-2 wrote: >=20 > mail me DDL table properties and IR025data . >=20 > 2009/7/10 Cax >=20 >> >> I use Oracle database. >> >> >> Sergey Livanov-2 wrote: >> > >> > What database do you use ? >> > >> > 2009/7/9 Cax >> > >> >> >> >> 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 =3D '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 >> >> > >> >> >> >> >> >> 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 worr= y >> >> >> 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 =3D #pan:VARCHAR# >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > -----Urspr=C3=BCngliche Nachricht----- >> >> >> > Von: Cax [mailto:cahyadihermanto@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 tr= y >> 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 =3D #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=C3=BCngliche Nachricht----- >> >> >> >> Von: Cax [mailto:cahyadihermanto@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 =3D ? >> >> >> >> 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 =3D ? >> >> >> >> 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.Mai= n >> >> >> >> ibatis.com.mydomain.data.Main - java.lang.NullPointerException >> >> >> >> >> >> >> >> >> >> >> >> Andrey Rogov-2 wrote: >> >> >> >>> >> >> >> >>> hi , >> >> >> >>> turn on Log4j and look at the sql statement, prepare, paramete= r >> >> and >> >> >> >>> query >> >> >> >>> result . >> >> >> >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> 2009/7/7 Cax >> >> >> >>> >> >> >> >>>> >> >> >> >>>> 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 : >> >> >> >>>> >> >> >> >>>> >> >> >> >>>> >> >> >> >>>> >> >> >> >>>> in java: >> >> >> >>>> >> >> >> >>>> Account acc =3D new Account(); >> >> >> >>>> >> >> >> >>>> acc.setpan("1234567890123456"); >> >> >> >>>> >> >> >> >>>> acc =3D (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-unsubscribe@ibatis.apache.org >> >> >> >>>> For additional commands, e-mail: >> user-java-help@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-unsubscribe@ibatis.apache.org >> >> >> >> For additional commands, e-mail: >> user-java-help@ibatis.apache.org >> >> >> >> >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org >> >> >> >> For additional commands, e-mail: >> user-java-help@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-unsubscribe@ibatis.apache.org >> >> >> > For additional commands, e-mail: user-java-help@ibatis.apache.or= g >> >> >> > >> >> >> > >> >> >> > >> >> --------------------------------------------------------------------- >> >> >> > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org >> >> >> > For additional commands, e-mail: user-java-help@ibatis.apache.or= g >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> -- >> >> >> 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-unsubscribe@ibatis.apache.org >> >> >> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org >> >> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org >> For additional commands, e-mail: user-java-help@ibatis.apache.org >> >> >=20 >=20 --=20 View this message in context: http://www.nabble.com/String-parameter-proble= m-tp24370405p24619051.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org For additional commands, e-mail: user-java-help@ibatis.apache.org