Tag Archives: howto

Snapshotting PostgreSQL databases with templates using Spring JDBC

Nowadays with the rise of more and more complex systems software testing is more important then ever. This not only includes unit testing but also integration-, end to end- and acceptance tests. For some of these test scenarios it is important to have a defined state of your database which could be reproduced in example […]
Posted in coding, english, Java | Also tagged , , , , , | Leave a comment

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. […]
Posted in coding, english, howto, Java | Also 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 […]
Posted in coding, english, howto, Java, Tools | Also 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 […]
Posted in Allgemein, coding, english, howto, Java | Also tagged , , , , , | Leave a comment

My git svn workflow

Using a remote subversion repository with git locally requires some adoptions to the local git usage compared to working in a pure git environment. The reason for this is that the remote subversion don’t know about many of the concepts the local git supports (local branches or multiple local commits before checkin for example). Because […]
Posted in coding, english, git, howto, Tools | Also tagged , , , , , , | Leave a comment