TransactionRequiredException: Executing an update/delete query
Simply adding @Transactional on the method will resolve this issue
July 2011
Convert given excel column name to column Index, ex ‘A=0’, ‘AA=26’
Other day I needed to convert excel spreadsheet column name to column index when having 200+ columns is easier to express as ‘FB’ instead of 157 A = 0 B = 1 AA = 26 AA = 27 FB = 157 This code will work for any number of column names. /** * Convert given …
Convert given excel column name to column Index, ex ‘A=0’, ‘AA=26’ Read More »
StringOutputStream backed by ByteArrayOutputStream
The other day I needed to read output stream directly into a string, but JDK does not provides us with a stream directly for that. There have been numerous discussions on why and why not we should have this build into the JDK, but this was a case where I did need it and knew …
StringOutputStream backed by ByteArrayOutputStream Read More »