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
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.
