Java blog

I need to monitor how much time takes an execution of a PL/SQL procedure. The procedure name together with its execution start and end times...

So my applications display as a nice table the data stored in a database. After filtering and highlighting the displayed data, the users of ...

The weekend and holidays should be excluded. It is easy to exclude weekends, but the holiday are specific to each place and should be store...

There is no official tool to export data from Oracle to MySQL database. Recurrently I need to copy a huge table from the source Oracle to My...

Often I need to leave overnight a long-running Java application. This is done with help of nohup command that blocks SIGHUP signals to the...

Unfortunately, in MySQL there are no decent export tools similar to Data Pump in Oracle. Luckily one can copy either the entire database dat...

To convert a varchar value into int : update TEMP set PATIENT_ID=cast(PATIENT_ID_ORIG as UNSIGNED); To convert a varchar value into date...

I just want to note down and share a useful link https://github.com/maaaaz/sqldeveloperpassworddecryptor with a python script that not only...

Even though I do it regularly, I always forget the commands. To display the current user and the current schema: SELECT sys_context('U...

In any other server one simply puts any jar into the library folder to make included in the classpath. In contrast, in Wildfly there is no s...

The max length of a string seems to equal Integer.MAX_VALUE. However, a string literal length in Java is represented by two bytes implying t...

Changing the default tiny font size By default the letters in SQL developer or Data integrator are hardly visible. The steps to increase th...

To add a datasource connecting to Oracle database, save the Oracle driver ojdbc7.jar into CATALINA_HOME/lib . Then add a line with the conn...

Often I need to convert unicode text, e.g. French, into English letters. The general way to remove diacritical marks is to decompose charact...

Backbone is a tiny and very flexible library for REST-based front end such as single page applications. But I did not find many examples of ...

I do not know why the conversion between Date and LocalDate is so complicated and ugly. But I have to do it increasingly often. So this note...

It should be registered as a singleton in the Application subclass. public class CORSResponseFilter implements ContainerResponseFilter { ...

While transforming between Java classes and JSON, Jackson library considers both its own annotations and the conventional JAXB annotations. ...

This post is based on the Google documentation on Google's OAuth 2.0 authentication , where OpenID Connect seems to be the most pertinen...

A shot note on POST requests: public InputStream post(String url, String params) throws IOException { URL u = new URL(url); HttpURL...