How to create a new table from Java using JDBC Statement in simple steps: connect, get the statement, execute and close.

• Read more

JDBC Statement vs PreparedStatement with example. Comparison between around SQL Injection using SELECT query.

• Read more

How to connect to MySQL database with MySQL JDBC driver. Get a new connection using DriverManager class.

• Read more

In a application you can have resources that are limited or time consuming to create a new one. e.g. a connection to a database, a new thread. A solution is to create a the limited resource once and reuse it. To address this problem the object pool pattern was introduced. The object pool design will have the mechanism to create a new object to keep the objects and to destroy the objects if necessary.

• Read more

If you are using a dedicated server with a few GB of RAM then you will not have this problem. But if you are running cloud computing with small virtual server like vultr.com then you may end up in this problem: the mysql/mariadb server will run out of memory.

• Read more

Probably all of us who works on daily basis with Linux servers faces this "problem": login with putty on remote server with user and password for one hundred time a day. A solution would be to save the username and the password, so one step to do the job. Of course this is not a secure way to do it, but is suitable for test servers and also from personal computers.

• Read more