I'm using mybatis 3.1 with spring 4.3 to connect Maria db. In my application I am using only 2 prepared statement (callable statement type). But after few hours of the running of the app it starts giving error "Can't create more than max_prepared_stmt_count statements (current value:16382)". I'm using SqlSessionTemplate for getting mapper, not able to understand where statements are getting opened and closed or getting closed at all?
MyBatis is not closing Prepared Statement
450 Views Asked by monu dwivedi At
1
There are 1 best solutions below
Related Questions in SPRING-MVC
- Redirect inside java interceptor
- Custom Spring annotation for request parameters
- Spring - configure Jboss Intros for xml with java config?
- No mapping found for HTTP request with URI [/test/WEB-INF/jsp/hello.jsp] in DispatcherServlet with name 'HelloWeb'
- Show login dialog when not authenticated yet
- How to keep a variable in the URL when using Spring LocaleChangeInterceptor
- LightAdmin - Customise parsing DateTime with app timezone
- Spring + TestNG Autowiring failure - NOT due to "new"
- Spring Boot MVC non-role based security
- Pretty print JSON with Spring 4
- How to initialize @DateTimeFormat Parameter on Get?
- Spring security /j_spring_security_login 404 error
- Use thymeleaf template for some pages and rest for some for building gradle project
- java.lang.StackOverflowError in spring controller
- submit dropdown angularjs spring MVC
Related Questions in MARIADB
- Mariadb max Error while sending QUERY packet PID
- PDO Memory Exhausted
- How to use MariaDB's REGEXP_REPLACE?
- MariaDB/MySQL all of a sudden crashed and won't restart
- MariaDB/MySQL: Get checksum of InnoDB table
- MariaDB password reset not working
- Best Practice for synchronized jobs in Application clusters
- Order by COUNT(something) vs order by #column (sqlzoo example)
- Django in-memory database model creation failure
- MariaDB installed without password prompt
- MySQL/MariaDB - Reset password without DB restart
- workaround for "Too many keys specified; max 64 keys allowed" error in MariaDB / TokuDB?
- Viewing MariaDB column_list result via DBForge
- Maria DB (mysql) installation on Red Hat . How do I start service after installation
- Does Maria DB support ANSI-89 join syntax
Related Questions in SPRING-MYBATIS
- PropertyPlaceholderConfigurers loading after parameterized DataSource bean
- Converting Ibatis to Mybatis
- mybatis foreach with annotations
- How to Pass Array to String to IN Clause Using MyBatis annotation
- mybatis integer data update, no effect
- MyBatis collection property
- @Transaction not working on multi datasource Spring Boot + MyBatis application
- Connections remain in idle status and increase untill reached max connections limit
- how to configure swagger in web.xml
- mybatis-spring & spring boot - Could not resolve type alias issue
- How to specify the character encoding of Mybatis?
- How to use mybatis annotations to implement relation query
- mybatis 3 + spring : Can I put a collection result into two groups based on a column value from the query result
- Spring 2.3.4.RELEASE, Mybatis.Spring.boot 2.1.3 : Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required
- What is resultType for bytea column of postgres while retrieving using mbatis mapper?
Related Questions in MYBATIS-MAPPER
- mybatis 3 + spring : Can I put a collection result into two groups based on a column value from the query result
- What is resultType for bytea column of postgres while retrieving using mbatis mapper?
- Cannot delete a record using Mybatis
- MyBatis update annotation failed - ORACLE ERROR ORA-00933
- MyBatis error converting result into Java records with an association
- Escaping braces from MyBatis value - Oracle
- How to iterate through a dynamic list in MyBatis and access the objects of the list
- MyBatis mapping collection inside association
- How to generalize similar namespaces of mappers in MyBatis?
- mybatis mapper on node express xml regular expression error
- Add a Mapper to cache with java api
- MyBatis proper way of mapping collections
- coalesce mybatis switch case
- Getting error while iterating Map in mybatis
- Ibatis map List<T> into @Result
Related Questions in MYBATIS-CONFIGURATION
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Got the issues..was using SIMPLE Executor type instead of RESUSE