{"action":"created","issue":{"url":"https://api.github.com/repos/mybatis/mybatis-3/issues/1336","repository_url":"https://api.github.com/repos/mybatis/mybatis-3","labels_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/1336/labels{/name}","comments_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/1336/comments","events_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/1336/events","html_url":"https://github.com/mybatis/mybatis-3/issues/1336","id":354099939,"node_id":"MDU6SXNzdWUzNTQwOTk5Mzk=","number":1336,"title":"about BatchExecutor","user":{"login":"taifenglan","id":34531389,"node_id":"MDQ6VXNlcjM0NTMxMzg5","avatar_url":"https://avatars0.githubusercontent.com/u/34531389?v=4","gravatar_id":"","url":"https://api.github.com/users/taifenglan","html_url":"https://github.com/taifenglan","followers_url":"https://api.github.com/users/taifenglan/followers","following_url":"https://api.github.com/users/taifenglan/following{/other_user}","gists_url":"https://api.github.com/users/taifenglan/gists{/gist_id}","starred_url":"https://api.github.com/users/taifenglan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taifenglan/subscriptions","organizations_url":"https://api.github.com/users/taifenglan/orgs","repos_url":"https://api.github.com/users/taifenglan/repos","events_url":"https://api.github.com/users/taifenglan/events{/privacy}","received_events_url":"https://api.github.com/users/taifenglan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-26T14:38:58Z","updated_at":"2018-08-26T16:19:14Z","closed_at":"2018-08-26T16:19:14Z","author_association":"NONE","body":"Hello,recently when using the foreach tag to complete the insert BEGIN END; operation, due to the large number of batches of SQL statements, eventually caused by the hang of the database due to too many binding parameters. MyBatis in batch processing, about SQL Are there any specific restrictions on the number of bound parameters? Then, can you ask the oracle database to do the code writing in the batch MERGE operation? Thank you, hope to reply."},"comment":{"url":"https://api.github.com/repos/mybatis/mybatis-3/issues/comments/416050417","html_url":"https://github.com/mybatis/mybatis-3/issues/1336#issuecomment-416050417","issue_url":"https://api.github.com/repos/mybatis/mybatis-3/issues/1336","id":416050417,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNjA1MDQxNw==","user":{"login":"harawata","id":149268,"node_id":"MDQ6VXNlcjE0OTI2OA==","avatar_url":"https://avatars3.githubusercontent.com/u/149268?v=4","gravatar_id":"","url":"https://api.github.com/users/harawata","html_url":"https://github.com/harawata","followers_url":"https://api.github.com/users/harawata/followers","following_url":"https://api.github.com/users/harawata/following{/other_user}","gists_url":"https://api.github.com/users/harawata/gists{/gist_id}","starred_url":"https://api.github.com/users/harawata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harawata/subscriptions","organizations_url":"https://api.github.com/users/harawata/orgs","repos_url":"https://api.github.com/users/harawata/repos","events_url":"https://api.github.com/users/harawata/events{/privacy}","received_events_url":"https://api.github.com/users/harawata/received_events","type":"User","site_admin":false},"created_at":"2018-08-26T16:19:14Z","updated_at":"2018-08-26T16:19:14Z","author_association":"MEMBER","body":"Please post your question to the [mailing list](http://groups.google.com/group/mybatis-user).\r\nWe use GitHub Issues to track bugs and feature requests.\r\n\r\nMost DB/drivers have limitations on number of placeholders.\r\nUsing foreach with BatchExecutor is meaningless because it will generate a long statement with a bunch of placeholders.\r\n\r\nPlease see the [FAQ entry](https://github.com/mybatis/mybatis-3/wiki/FAQ#how-do-i-code-a-batch-insert) for how to perform batch operation with MyBatis.\r\nThe point is to reuse the single statement with a different parameter.\r\nIf you still need help, please create a small example project or post relevant code/statement.\r\n\r\nClosing as this is not a MyBatis bug."}}
{"actor":{"display_login":"harawata"}}