List/Grid Tag Archives: MySQL
Spring MVC: Security with MySQL and Hibernate
Spring has a lot of different modules. All of them are useful for the concrete purposes. Today I’m going to talk about Spring Security. This module provides flexible approach to manage ...
Caveats With MySQL Pagination
We’ve all done pagination – it’s sensible for both lists in the UI and for processing data in batches. “SELECT (columns) FROM table LIMIT X, Y”. Possibly “SELECT (columns) ...
MySql connections autodrop after a certain hours
MySql is configured to drop any connection which has been Idle for more than 8 hours. What is the implication of this? After you return to your deployed app after a gap of 8 hours (If ...
Getting started with Quartz Scheduler on MySQL database
Here are some simple steps to get you fully started with Quartz Scheduler on MySQL database using Groovy. The script below will allow you to quickly experiment different Quartz configuration ...
Debugging SQL query in MySQL
Recently I started writing SQL query for analyzing and debugging the production code. But I was surprised to see that some queries takes longer time to execute to achieve the same output. ...
Load or Save Image using Hibernate – MySQL
This tutorial will walk you throughout how to save and load an image from database (MySQL) using Hibernate. Requirements For this sampel project, we are going to use:Eclipse ...
Arquillian with NetBeans, WebLogic 12c, JPA and a MySQL Datasource
You probably followed my posts about testing more complex scenarios with embedded GlassFish (Part I / Part II). Next on my list of things to do was to get this setup working with latest ...
Configuring MyBatis 3
MyBatis is a very popular and also most efficient SQL mapping framework. MyBatis is available for both in java as well as .net language. MyBatis is not really an alternative of Hibernate ...
Arquillian with NetBeans, GlassFish embedded, JPA and a MySQL Datasource
This is an, let’s call it accidental post. I was looking into transactional CDI observers and playing around with GlassFish embedded to run some integration tests against it. ...
Hibernate autocommit commands force MySQL in excessive disk I/O
Dear All, I am sure many of you use Hibernate and MySQL, I use it here and there myself. Generally the programming model is nice, but it is no secret that plain JDBC can be a lot faster. ...
