My most recent project required me to use JDBC to connect to the database server on an OS/400 server. I had a heck of a time finding drivers, going around and around again on IBM’s site. The client probably had the drivers, but they were relying on us to tell them what went where and [...]

In my previous post, I gave an example of code on how to use Spring’s JDBCTemplate to call a stored procedure and process a returned result set using the simple query. Here’s the code to do the same with overriding Spring’s StoredProcedure class. The advantage in this method is that using the declareParameter method can [...]

Recently, I was using Spring‘s JDBCTemplate for my Data Access Layer (DAL). I had a stored procedure that returned a result set, and had to spend quite a bit of search time finding an example of how to process it. I managed to work it out using both the method of overriding Spring’s StoredProcedure and [...]