In postgresql – selecting maximum for each group, we saw the actual stored function.  That was the easy part.  Then there was dealing with Postgresql and JDBC.  I encountered a few surprises while doing this. Calling the stored function I expected to use JDBC’s CallableStatement since I was calling a stored procedure.  Nope.  The proper [...]

I’m looking at writing integration tests for the back end of JavaRanch‘s JForum install. A few “pesky” requirements/constraints Multiple developers all over the word have their own local test databases filled with data in different states.  The tests must work for everyone.  Ideally they won’t leave data floating around either. The tests must use PostgreSQL.  [...]

Live from the JavaOne conference again, this time attending a session about enhancements to the JDBC specification 4.1. Four members of the JDBC specification team have presented a number of useful enhancements due in the upcoming version of JDBC. Some of these features may not make it into 4.1, but will be in future versions [...]