[
https://issues.apache.org/jira/browse/IBATIS-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Clinton Begin closed IBATIS-460.
--------------------------------
Resolution: Invalid
Assignee: Clinton Begin
Not a bug
> 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
> Assignee: Clinton Begin
> 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/21/07 9:57:18:514 EDT] 0000004f Connection 1
> com.ibatis.common.jdbc.logging.ConnectionLogProxy <init> {conn-101840}
> Connection
> [9/21/07 9:57:18:515 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-101841}
> PreparedStatement: SELECT PERSON.OID, PERSON.LAST_NAME,
> PERSON.FIRST_NAME, PERSON.PREFFERED_NAME, PERSON.UNIQUE_ID
> FROM PERSON WHERE USER_CODE = ?
> [9/21/07 9:57:18:515 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-101841}
> Parameters: [EMAIL PROTECTED]
> [9/21/07 9:57:18:515 EDT] 0000004f PreparedState 1
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy invoke {pstm-101841}
> Types: [java.lang.String]
> [9/21/07 9:57:18:625 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy <init> {rset-101842}
> ResultSet
> [9/21/07 9:57:18:626 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy invoke {rset-101842} Header:
> [OID, LAST_NAME, FIRST_NAME, PREFFERED_NAME, UNIQUE_ID]
> [9/21/07 9:57:18:626 EDT] 0000004f ResultSet 1
> com.ibatis.common.jdbc.logging.ResultSetLogProxy invoke {rset-101842} Result:
> [22:1347, Coker, Goldwyn N, null, 101-06-2178]
> [
> 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.
