[
https://issues.apache.org/jira/browse/IBATIS-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeff Butler closed IBATIS-460.
------------------------------
Resolution: Invalid
Please use the mailing lists for support requests.
BTW - your example has two different SQL statements, not surprising that the
results are different.
> Intermittent requests gives null ResultMap
> ------------------------------------------
>
> Key: IBATIS-460
> URL: https://issues.apache.org/jira/browse/IBATIS-460
> Project: iBatis for Java
> Issue Type: Bug
> Affects Versions: 2.0.8
> Environment: iBatis 2.0.7, WebSphere 6, Oracle 10g, JDBC driver
> 10.1.0.3.0
> Reporter: Chirag
> Priority: Blocker
>
> We are getting intermittent issues. We have webservices implementation.
> iBatis is returning null ResultSet when it tries to get data for new request.
> If you try 4-5 times, it might fail once. I don't understand why the same
> query would give null result sometimes. So I think it has something to do
> with iBatis ResultSet. We found this issue recently. Our sysem was upgraded
> to 10g before 3 months. I also moved my client database to 9i. But this time
> I got the same issue. Our iBatis version is really old. I am not sure if
> that's the issue.
> Here is the iBatis logging for successful and failed request:
> Failed Request:
> [9/20/07 14:05:59:660 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-100181}
> PreparedStatement: SELECT PERSON.OID, PERSON.LAST_NAME,
> PERSON.FIRST_NAME, PERSON.PREFFERED_NAME, PERSON.UNIQUE_ID
> FROM PERSON WHERE USER_CODE = ?
> [9/20/07 14:05:59:660 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-100181}
> Parameters: [EMAIL PROTECTED]
> [9/20/07 14:05:59:660 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-100181}
> Types: [java.lang.String]
> [9/20/07 14:05:59:662 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy <init> {rset-100182}
> ResultSet
> Successful request:
> [9/20/07 14:05:50:475 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-100173}
> PreparedStatement: select ADDRESS.OID, PERSON.OID as
> PERSON_OID, ADDRESS.CITY, ADDRESS.STATE, ADDRESS.STREET1,
> ADDRESS.STREET2, ADDRESS.ZIP_CODE, ASSOCIATE.EMAIL_ADDRESS,
> ASSOCIATE.SECONDARY_EMAIL_ADDRESS from PERSON, ADDRESS, ASSOCIATE
> where PERSON.USER_CODE = ? and ASSOCIATE.OID = PERSON.OID and
> ADDRESS.OID = ASSOCIATE.ADDRESSOID
> [9/20/07 14:05:50:475 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-100173}
> Parameters: [EMAIL PROTECTED]
> [9/20/07 14:05:50:476 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-100173}
> Types: [java.lang.String]
> [9/20/07 14:05:50:478 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy <init> {rset-100174}
> ResultSet
> [9/20/07 14:05:50:479 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy invoke {rset-100174} Header:
> [OID, PERSON_OID, CITY, STATE, STREET1, STREET2, ZIP_CODE, EMAIL_ADDRESS,
> SECONDARY_EMAIL_ADDRESS]
> [9/20/07 14:05:50:479 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy invoke {rset-100174} Result:
> [22:207, 22:205, Terry, CA, 4 Tree Fine Road, null, 55854, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
> Appreciate your help.
> Thanks,
> Chirag
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
