Creating a connection pool should be a simple and straight forward task in an application server but sometimes it just becomes unnecessarily difficult. That is completely true for creating MySQL connections pools in all versions of GlassFish from 3 onwards.
If you have ever developed a web application you’ll know that most of the code you write is not clever business logic that’s doing complicated calculations but actually fairly simple CRUD (Create, Reuse/Retrieve, Update, Delete) code. Since this is the type of code that gets written all the time it makes sense to know it …
That mouth full of a title sums up quite nicely what I’ve been trying to get working today: a JDBC-ODBC bridge connection to a 32bit Access database running on a 64bit version of Windows 7. Phew, I’m tired just thinking about it.