ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Rogov <andrey.ro...@gmail.com>
Subject Re: AW: AW: String parameter problem
Date Sat, 11 Jul 2009 14:17:15 GMT
mail me DDL table properties and IR025data .

2009/7/10 Cax <cahyadihermanto@gmail.com>

>
> I use Oracle database.
>
>
> Sergey Livanov-2 wrote:
> >
> > What database do you use ?
> >
> > 2009/7/9 Cax <cahyadihermanto@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 <cahyadihermanto@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: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
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@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 <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
> >> >> >>
> >> >> >>
> >> >> >>
> >> ---------------------------------------------------------------------
> >> >> >> 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.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-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
>
>

Mime
View raw message