Category Archives: howto

Integrating Flyway with Java EE and using its datasource

Flyway is my favourite tool when it comes to database migrations because its convention over configuration approach makes it fairly easy to use while bootstrapping and configuration is reduced to a minimum. For those of you who don’t know anything about database migration tools (evolutionary database design) in short the concept is to track SQL scripts […]
Also posted in coding, english, Java, Tech | Tagged , , , , , , | 3 Comments

Removing Excel rows with POI

When generating Excel Sheets it is sometimes necessary to remove rows which match a given criteria afterwards. The first idea for this would be to use removeRow(Row row) but this has the problem that it deletes all the row contents and leaves the empty row in your sheet which is probably not what you want. […]
Also posted in coding, english, Java | Tagged , , , , | Leave a comment

Solution for the IntelliJ issue on macOS Sierra

Jetbrains has come up with a solution for the scrolling problem with IntelliJ IDEA based IDEs under macOS Sierra. They released a modified JDK8 which hast to be set as boot JDK for IntelliJ. You can download the JDK here. For setting it as the boot JDK you need to got to action menu. This […]
Also posted in Apple, english, Java, macOS, Tools | Tagged , , , , , , , | Leave a comment

eclipse workspace in use

As I’m a huge fan of IntelliJ IDEA I don’t use eclipse very often during the last years but I have a dedicated project where I need to regularly use for creating deployments and connect with some remote test servers. So I have to deal with eclipse and its problems, too. A recurring problem for […]
Also posted in coding, english, Java, Tools | Tagged , , , , | Leave a comment

Using CellUtil with POI to avoid too many cell styles in Excel

When you create Excel documents with the popular Apache POI library it is possible that you encounter a problem where Excel tells you there are “Too many different cell formats”. A possible source for this is that you probably have a loop structure in which you define a new cell style for every cell you […]
Also posted in Allgemein, coding, english, Java | Tagged , , , , , , | Leave a comment