You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Chirag (JIRA)" <ib...@incubator.apache.org> on 2007/09/21 00:03:52 UTC
[jira] Created: (IBATIS-460) Intermittent requests gives null
ResultMap
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: [gcoker@cs1]
[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: [gpa@r58z]
[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, aaa@nationbbb.org, gpa@georgiattt.com]
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.
[jira] Closed: (IBATIS-460) Intermittent requests gives null
ResultMap
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ 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: [gcoker@cs1]
> [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: [gcoker@cs1]
> [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.
[jira] Closed: (IBATIS-460) Intermittent requests gives null
ResultMap
Posted by "Jeff Butler (JIRA)" <ib...@incubator.apache.org>.
[ 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: [gcoker@cs1]
> [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: [gpa@r58z]
> [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, aaa@nationbbb.org, gpa@georgiattt.com]
> 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.