Recently, I installed a new local MySQL Server with the purpose to log debug messages.
But because I had to log a lot of messages disk space became an issue. So I decided to create an event to clear these messages hourly.
I spent a lot of time trying to understand why the code worked fine in a single execution, but when the same code was inside the event it was not working when the schedule was…
The day started awesomly.
I logged in into my amazon EC2 instance, that I use at work, for beta testing the software before production, and everything was ok.
Then evil Windows came into play and greeted me with a message for updating the system.
So I did! And everything went wrong!
After rebooting I was no longer able to connect to this ec2. Sign in to amazon aws console to see the…
dbConnection.setAutoCommit(false);//commit trasaction manually String insertTableSQL = "INSERT INTO DBUSER" + "(USER_ID, USERNAME, CREATED_BY, CREATED_DATE) VALUES" + "(?,?,?,?)";
PreparedStatement = dbConnection.prepareStatement(insertTableSQL); preparedStatement.setInt(1, 101); preparedStatement.setString(2, "mkyong101"); preparedStatement.setString(3, "system");…