[jira] Created: (IBATIS-615) Preparestatement cache bug

Preparestatement cache bug
--------------------------

                 Key: IBATIS-615
                 URL: https://issues.apache.org/jira/browse/IBATIS-615
             Project: iBatis for Java
          Issue Type: Bug
    Affects Versions: 2.3.4
         Environment: Windows Operating System
            Reporter: saravanan


I wrote one sample program to test the caching of preparestatement for dynamic queries.

Code Snippet:-

                Map<String, String> lParam = new HashMap<String,String>() ;
                lParam.put("query", "select * from T1") ;
                sqlMap.queryForList("getObjects", lParam) ;
                sqlMap.queryForList("getObjects", lParam) ;

Log:-

[main] 07/23/09 00:56:44.671 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Created connection 7804298.
[main] 07/23/09 00:56:44.674 DEBUG java.sql.Connection :{conn-100000} Connection
[main] 07/23/09 00:56:44.677 DEBUG java.sql.Connection :{conn-100000} Preparing Statement:  select * from T1    
[main] 07/23/09 00:56:44.720 DEBUG java.sql.PreparedStatement :{pstm-100001} Executing Statement:  select * from T1    
[main] 07/23/09 00:56:44.720 DEBUG java.sql.PreparedStatement :{pstm-100001} Parameters: []
[main] 07/23/09 00:56:44.720 DEBUG java.sql.PreparedStatement :{pstm-100001} Types: []
[main] 07/23/09 00:56:44.747 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Returned connection 7804298 to pool.
[main] 07/23/09 00:56:44.747 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Checked out connection 7804298 from pool.
[main] 07/23/09 00:56:44.747 DEBUG java.sql.Connection :{conn-100003} Connection
[main] 07/23/09 00:56:44.748 DEBUG java.sql.Connection :{conn-100003} Preparing Statement:  select * from T1     **************Why Preparing Statement again**********
[main] 07/23/09 00:56:44.748 DEBUG java.sql.PreparedStatement :{pstm-100004} Executing Statement:  select * from T1    
[main] 07/23/09 00:56:44.748 DEBUG java.sql.PreparedStatement :{pstm-100004} Parameters: []
[main] 07/23/09 00:56:44.748 DEBUG java.sql.PreparedStatement :{pstm-100004} Types: []
[main] 07/23/09 00:56:44.749 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Returned connection 7804298 to pool.
[main] 07/23/09 00:56:44.750 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Checked out connection 7804298 from pool.


If i add sqlmap.startTransaction() in the begining of the code, preparestatement is getting cached.  But why should we need to begin a transaction to cache preparestatements.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

    [ https://issues.apache.org/jira/browse/IBATIS-615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741498#action_12741498 ]

Kai Grabfelder commented on IBATIS-615:
---------------------------------------

have you by any chance by affected by IBATIS-436 and had no settings defined until configuring the transaction?

> Preparestatement cache bug
> --------------------------
>
>                 Key: IBATIS-615
>                 URL: https://issues.apache.org/jira/browse/IBATIS-615
>             Project: iBatis for Java
>          Issue Type: Bug
>    Affects Versions: 2.3.4
>         Environment: Windows Operating System
>            Reporter: saravanan
>
> I wrote one sample program to test the caching of preparestatement for dynamic queries.
> Code Snippet:-
> Map<String, String> lParam = new HashMap<String,String>() ;
> lParam.put("query", "select * from T1") ;
> sqlMap.queryForList("getObjects", lParam) ;
> sqlMap.queryForList("getObjects", lParam) ;
> Log:-
> [main] 07/23/09 00:56:44.671 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Created connection 7804298.
> [main] 07/23/09 00:56:44.674 DEBUG java.sql.Connection :{conn-100000} Connection
> [main] 07/23/09 00:56:44.677 DEBUG java.sql.Connection :{conn-100000} Preparing Statement:  select * from T1    
> [main] 07/23/09 00:56:44.720 DEBUG java.sql.PreparedStatement :{pstm-100001} Executing Statement:  select * from T1    
> [main] 07/23/09 00:56:44.720 DEBUG java.sql.PreparedStatement :{pstm-100001} Parameters: []
> [main] 07/23/09 00:56:44.720 DEBUG java.sql.PreparedStatement :{pstm-100001} Types: []
> [main] 07/23/09 00:56:44.747 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Returned connection 7804298 to pool.
> [main] 07/23/09 00:56:44.747 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Checked out connection 7804298 from pool.
> [main] 07/23/09 00:56:44.747 DEBUG java.sql.Connection :{conn-100003} Connection
> [main] 07/23/09 00:56:44.748 DEBUG java.sql.Connection :{conn-100003} Preparing Statement:  select * from T1     **************Why Preparing Statement again**********
> [main] 07/23/09 00:56:44.748 DEBUG java.sql.PreparedStatement :{pstm-100004} Executing Statement:  select * from T1    
> [main] 07/23/09 00:56:44.748 DEBUG java.sql.PreparedStatement :{pstm-100004} Parameters: []
> [main] 07/23/09 00:56:44.748 DEBUG java.sql.PreparedStatement :{pstm-100004} Types: []
> [main] 07/23/09 00:56:44.749 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Returned connection 7804298 to pool.
> [main] 07/23/09 00:56:44.750 DEBUG com.ibatis.common.jdbc.SimpleDataSource :Checked out connection 7804298 from pool.
> If i add sqlmap.startTransaction() in the begining of the code, preparestatement is getting cached.  But why should we need to begin a transaction to cache preparestatements.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...