[
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-unsubscr...@ibatis.apache.org
For additional commands, e-mail: dev-h...@ibatis.apache.org
