Skip to content

Category Archives: Java

Java and JDBC for Oracle DBAs – Part 5: Spring-Boot, JdbcTemplate & DB migration (Using FlywayDB)

Today we’ll be looking at Spring-boot and a tools which developers use to migrate databases, FlywayDB. We’ll also look at how you can automate grants towards our two roles (which we created in part 3) whenever new tables are created. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java (JDK), Eclipse and Maven […]

Posted 25 July 2018 † Lasse Jenssen § Oracle ‡ Comments (0) °

Java and JDBC for Oracle DBAs – Part 4: Your first JDBC Application

This is the fourth blog in this blog series which I have called “Java & JDBC for Oracle DBAs”. Now we are finally ready to start to develop towards the Oracle database we created in part 1, and schemas we created in part 3. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java […]

Posted 21 July 2018 † Lasse Jenssen § Oracle ‡ Comments (0) °

Java and JDBC for Oracle DBAs – Part 3: Git, Oracle schemas and your first Java application

Finally we have come to the point where we start to create some Java code. First we’ll install Git, the most widely used modern version control system. We’ll continue to download some code from GitHub to create our Oracle schemas, and then we’ll create a very simple – but our first – Java application. We’ll […]

Posted 18 July 2018 † Lasse Jenssen § Oracle ‡ Comments (0) °

Java and JDBC for Oracle DBAs – Part 2: Java, Eclipse, Maven & JDBC

Today I’ll continue with my series on creating an Java and JDBC test application for Oracle DBAs. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java (JDK), Eclipse and Maven (this) Part 3: Git, Oracle schemas and your first Java application Part 4: Your first JDBC Application Part 5: Spring-boot, JdbcTemplate & DB migration […]

Posted 17 July 2018 † Lasse Jenssen § Oracle ‡ Comments (0) °

Java and JDBC for Oracle DBAs – Part 1: Oracle Database in Docker

Working together with Java developers I sometimes have to test aspects of the JDBC programming. When cooperating with the Java developers it is also very convenient to know some Java. In this blog series I’ll describe how you can build your own Java test application, and how you can get a little more acquainted with […]

Posted 14 July 2018 † Lasse Jenssen § Oracle ‡ Comments (0) °

Java (JPA): Improve statement caching efficiency with IN clause parameter padding

A nice little feature for handling queries with IN-lists, if you are using JPA. There are other and maybe better ways to solve this, but the solution described in the this blog could be worth a look into: How to improve statement caching efficiency with IN clause parameter padding

Posted 30 May 2018 † Lasse Jenssen § Hibernate ‡ Comments (0) °

Java: JDBC roundtrips are expensive

SQL Daily just tweeted about the fact that JDBC roundtrips are expensive. This is something many developers either forget or do not know. I have seen so many chatty applications killing the application performance, and the database performance. Toon Koppelaars have performed some excellent presentations showing this. Lukas Eder have also written some nice articles […]

Posted 28 April 2018 † Lasse Jenssen § Performance ‡ Comments (0) °

Java: Nice article about Java, Time and Dates

I really enjoyed the following article about Java, Time and Dates: https://yawk.at/java.time/ From the article: An introduction to java.time Time is a complex topic. Many programmers are unfamiliar with the difficulties and common bugs associated with time. This has in the past lead to time APIs that allowed “sloppy” code which can lead to bugs in […]

Posted 28 April 2018 † Lasse Jenssen § ‡ Comments (0) °