The Power of a simple SET…

The Power of a simple SET…

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…

View On WordPress

Amazon EC2 we got a problem! Instance reachability check failed After Windows Update

Amazon EC2 we got a problem! Instance reachability check failed After Windows Update

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! 

The Problem:

After rebooting I was no longer able to connect to this ec2. Sign in to amazon aws console to see the…

View On WordPress

Java - MYSQL - Prepared Statements - Insert Batch

Java – MYSQL – Prepared Statements – Insert Batch

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");…

View On WordPress