String parameter problem
|
View:
New views
15 Messages
—
Rating Filter:
Alert me
|
 |
String parameter problem
by Cax
::
Rate this Message:
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....  |
|
|
Re: String parameter problem
by Andrey Rogov-2
::
Rate this Message:
hi ,
turn on Log4j and look at the sql statement, prepare, parameter and query result . 2009/7/7 Cax <cahyadihermanto@...>
|
|
|
Re: String parameter problem
by Cax
::
Rate this Message:
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
|
|
|
AW: String parameter problem
by Benjamin-Klatt
::
Rate this Message:
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:cahyadihermanto@...] Gesendet: Mittwoch, 8. Juli 2009 17:31 An: user-java@... 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 <cahyadihermanto@...> > >> >> 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-unsubscribe@... >> For additional commands, e-mail: user-java-help@... >> >> > > -- 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@... For additional commands, e-mail: user-java-help@... --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... |
|
|
Re: AW: String parameter problem
by Cax
::
Rate this Message:
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?
|
|
|
AW: AW: String parameter problem
by Benjamin-Klatt
::
Rate this Message:
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:cahyadihermanto@...] Gesendet: Mittwoch, 8. Juli 2009 19:08 An: user-java@... 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:cahyadihermanto@...] > Gesendet: Mittwoch, 8. Juli 2009 17:31 > An: user-java@... > 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 <cahyadihermanto@...> >> >>> >>> 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-unsubscribe@... >>> For additional commands, e-mail: user-java-help@... >>> >>> >> >> > > -- > 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@... > For additional commands, e-mail: user-java-help@... > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscribe@... > For additional commands, e-mail: user-java-help@... > > > -- 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@... For additional commands, e-mail: user-java-help@... --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... |
|
|
Re: AW: AW: String parameter problem
by Cax
::
Rate this Message:
Hi Benjamin,i'd tried this way before also...but it still hit the same problem... :(
|
|
|
Re: AW: AW: String parameter problem
by Andrey Rogov-2
::
Rate this Message:
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 <cahyadihermanto@...>
|
|
|
Re: AW: AW: String parameter problem
by Cax
::
Rate this Message:
i try to change the sql in xml file, 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....
|
|
|
Re: AW: AW: String parameter problem
by Sergey Livanov-2
::
Rate this Message:
What database do you use ?
2009/7/9 Cax <cahyadihermanto@...>
|
|
|
Re: AW: AW: String parameter problem
by Cax
::
Rate this Message:
I use Oracle database.
|
|
|
Re: AW: AW: String parameter problem
by Andrey Rogov-2
::
Rate this Message:
mail me DDL table properties and IR025data .
2009/7/10 Cax <cahyadihermanto@...>
|
|
|
Re: AW: AW: String parameter problem
by Cax
::
Rate this Message:
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 query 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) = #pan# and it's working now... Thanks for all of your suggestions to help me...
|
|
|
Re: AW: AW: String parameter problem
by Andrey Rogov-3
::
Rate this Message:
do you solve problem ?
2009/7/23, Cax <cahyadihermanto@...>: > > 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 query > 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) = #pan# > > and it's working now... > Thanks for all of your suggestions to help me...:-) > > > Andrey Rogov-2 wrote: >> >> mail me DDL table properties and IR025data . >> >> 2009/7/10 Cax <cahyadihermanto@...> >> >>> >>> I use Oracle database. >>> >>> >>> Sergey Livanov-2 wrote: >>> > >>> > What database do you use ? >>> > >>> > 2009/7/9 Cax <cahyadihermanto@...> >>> > >>> >> >>> >> 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 <cahyadihermanto@...> >>> >> > >>> >> >> >>> >> >> 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:cahyadihermanto@...] >>> >> >> > Gesendet: Mittwoch, 8. Juli 2009 19:08 >>> >> >> > An: user-java@... >>> >> >> > 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:cahyadihermanto@...] >>> >> >> >> Gesendet: Mittwoch, 8. Juli 2009 17:31 >>> >> >> >> An: user-java@... >>> >> >> >> 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 <cahyadihermanto@...> >>> >> >> >>> >>> >> >> >>>> >>> >> >> >>>> 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-unsubscribe@... >>> >> >> >>>> For additional commands, e-mail: >>> user-java-help@... >>> >> >> >>>> >>> >> >> >>>> >>> >> >> >>> >>> >> >> >>> >>> >> >> >> >>> >> >> >> -- >>> >> >> >> 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@... >>> >> >> >> For additional commands, e-mail: >>> user-java-help@... >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> >> --------------------------------------------------------------------- >>> >> >> >> To unsubscribe, e-mail: user-java-unsubscribe@... >>> >> >> >> For additional commands, e-mail: >>> user-java-help@... >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> >> >> > >>> >> >> > -- >>> >> >> > 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@... >>> >> >> > For additional commands, e-mail: user-java-help@... >>> >> >> > >>> >> >> > >>> >> >> > >>> >> --------------------------------------------------------------------- >>> >> >> > To unsubscribe, e-mail: user-java-unsubscribe@... >>> >> >> > For additional commands, e-mail: user-java-help@... >>> >> >> > >>> >> >> > >>> >> >> > >>> >> >> >>> >> >> -- >>> >> >> 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@... >>> >> >> For additional commands, e-mail: user-java-help@... >>> >> >> >>> >> >> >>> >> > >>> >> > >>> >> >>> >> -- >>> >> 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@... >>> >> For additional commands, e-mail: user-java-help@... >>> >> >>> >> >>> > >>> > >>> >>> -- >>> 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@... >>> For additional commands, e-mail: user-java-help@... >>> >>> >> >> > > -- > View this message in context: > http://www.nabble.com/String-parameter-problem-tp24370405p24619051.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscribe@... > For additional commands, e-mail: user-java-help@... > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... |
|
|
Re: AW: AW: String parameter problem
by Cax
::
Rate this Message:
yes,i solve the problem..Thx
|
| Free embeddable forum powered by Nabble | Forum Help |
