You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Javier Toyos Lanza (JIRA)" <ib...@incubator.apache.org> on 2006/11/10 12:18:37 UTC
[jira] Created: (IBATIS-365) Problem with a Long data type
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
[jira] Commented: (IBATIS-365) Problem with a Long data type
Posted by "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
[jira] Closed: (IBATIS-365) Problem with a Long data type
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Clinton Begin closed IBATIS-365.
--------------------------------
Resolution: Invalid
> Problem with a Long data type
> -----------------------------
>
> Key: IBATIS-365
> URL: https://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.
-
You can reply to this email to add a comment to the issue online.