ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cax <cahyadiherma...@gmail.com>
Subject Re: String parameter problem
Date Wed, 08 Jul 2009 15:31:17 GMT

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


Mime
View raw message