How to show open database connections in MySQL
How to show open database connections in MySQL using show status
and show processlist
command.
Thread Semaphore and Mutex in Java
Thread Semaphore and Mutex in Java. Semaphore restrict the access to a resource for limited numbers of threads while mutex restricts the access to a single thread.
How to generate tables from entities using EclipseLink
How to generate entities from tables using EclipseLink. Simple example using one-to-one database relationship. @MappedSuperclass example included
How to define one-to-one relationship in MySQL
How to define one-to-one relationship in MySQL using the foreign key and unique property to limit the row count from the child table
How to parse Google Search result in Java
How to parse Google Search result in Java using URLConnection and a regular expression to parse the response. Can be used to check the Google SERP position.
How to delete a record using JDBC PreparedStatement
How to delete a record using JDBC PreparedStatement to avoid SQL injection.