[jira] Commented: (IBATIS-365) Problem with a Long data type

["Jeff Butler (JIRA)" <ib...@incubator.apache.org>]

    [ http://issues.apache.org/jira/browse/IBATIS-365?page=comments#action_12454141 ] 
            
Jeff Butler commented on IBATIS-365:
------------------------------------

Please use the mailing lists for support questions.  I don't see evidence of a bug.

It looks like there's no record in the DB with key equal to -1 or -2, you do get a record with key equal to 0.

I'll close this as invalid on Wednesday, November 29 unless you can provide some additional information to prove this is a bug.


> Problem with a Long data type
> -----------------------------
>
>                 Key: IBATIS-365
>                 URL: http://issues.apache.org/jira/browse/IBATIS-365
>             Project: iBatis for Java
>          Issue Type: Bug
>    Affects Versions: 2.2.0
>         Environment: Windows XP Professional SP2. Eclipse 3.2.0. Java 1.5.0_09 
>            Reporter: Javier Toyos Lanza
>
> I have a problem with a java app. with spring + ibatis + oscache + database. In fact, I have a problem with a Long data type where the values are -1 and 0. 
> I try to do : 
> classApp.java { 
>     public static void main(String[] args) { 
>     ... 
>     Horario horario = horarioDAO.buscarHorario(new Long("-1")); 
>     ... 
>     Horario horario = horarioDAO.buscarHorario(new Long("0")); 
>     ... 
>     } 
> } 
> /------/ 
> Interface HorarioDAO.java { 
>    ... 
>    public Horario buscarHorario(Long identificador) throws DAOException; 
>    ... 
> } 
> /-------/ 
> HorarioDAOImpl extends SqlMapClientDaoSupport implements HorarioDAO { 
>     .... 
>     Horario buscarHorario(Long identificador) throws DAOException { 
>         ... 
>        SqlMapClientTemplate sqlMapClientTemplate = getSqlMapClientTemplate(); 
>        Horario horario = (Horario) sqlMapClientTemplate.queryForObject("Horario.buscarHorario", identificador); 
>        return horario; 
>        } 
>        .... 
> } 
> And Horario.xml 
> <sqlMap namespace="Horario"> 
>      <cacheModel id="cacheHorarios" type="OSCACHE"> 
>          <flushInterval minutes="30"/> 
>      </cacheModel> 
>      <select id="buscarHorario" resultMap="horarioResult" parameterClass="java.lang.Long" cacheModel="cacheHorarios"> 
>   SELECT 
> h.idhorario, h.nombre 
> FROM 
> horario h 
> WHERE 
> h.idhorario = #value# 
>      </select> 
> </sqlMap> 
> Finally the log: 
> {conn-100000} Connection Connection.debug (lu00EDnea:27 ) 
> {conn-100000} Preparing Statement: SELECT h.idhorario, h.nombre FROM horario h WHERE h.idhorario = ? Connection.debug (lu00EDnea:27 ) 
> {pstm-100001} Executing Statement: SELECT h.idhorario, h.nombre FROM horario h WHERE h.idhorario = ? PreparedStatement.debug (lu00EDnea:27 ) 
> {pstm-100001} Parameters: [-1] PreparedStatement.debug (lu00EDnea:27 ) 
> {pstm-100001} Types: [java.lang.Long] PreparedStatement.debug (lu00EDnea:27 ) 
> {rset-100002} ResultSet ResultSet.debug (lu00EDnea:27 ) 
> {conn-100003} Connection Connection.debug (lu00EDnea:27 ) 
> If I modified only one of values ( -1 by -2 for example ) works correctly. Also, if I modified the Long data type by String, for example 
> View the log: 
> {conn-100000} Connection Connection.debug (lu00EDnea:27 ) 
> {conn-100000} Preparing Statement: SELECT h.idhorario, h.nombre FROM horario h WHERE h.idhorario = ? Connection.debug (lu00EDnea:27 ) 
> {pstm-100001} Executing Statement: SELECT h.idhorario, h.nombre FROM horario h WHERE h.idhorario = ? PreparedStatement.debug (lu00EDnea:27 ) 
> {pstm-100001} Parameters: [-2] PreparedStatement.debug (lu00EDnea:27 ) 
> {pstm-100001} Types: [java.lang.Long] PreparedStatement.debug (lu00EDnea:27 ) 
> {rset-100002} ResultSet ResultSet.debug (lu00EDnea:27 ) 
> {conn-100003} Connection Connection.debug (lu00EDnea:27 ) 
> {conn-100003} Preparing Statement: SELECT h.idhorario, h.nombre FROM horario h WHERE h.idhorario = ? Connection.debug (lu00EDnea:27 ) 
> {pstm-100004} Executing Statement: SELECT h.idhorario, h.nombre FROM horario h WHERE h.idhorario = ? PreparedStatement.debug (lu00EDnea:27 ) 
> {pstm-100004} Parameters: [0] PreparedStatement.debug (lu00EDnea:27 ) 
> {pstm-100004} Types: [java.lang.Long] PreparedStatement.debug (lu00EDnea:27 ) 
> {rset-100005} ResultSet ResultSet.debug (lu00EDnea:27 ) 
> {rset-100005} Header: [IDHORARIO, NOMBRE] ResultSet.debug (lu00EDnea:27 ) 
> {rset-100005} Result: [0, Ma\u005cu005cu00f1ana y Tarde] ResultSet.debug (lu00EDnea:27 ) 
> Thanks a lot 
> Javier Toyos Lanza 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira