Install ODBC Driver under Ubuntu

Question

I have the latest version of MySQL and NetBeans installed on my system. I also have the iODBC driver manager installed. I need help with installing an ODBC driver and creating a DSN for my JSP project. I know how to create and configure a DSN under Windows. But I can't figure out how to do this under Ubuntu. Neither am I able to install an ODBC driver. How to do these?

Answer 1

I realized that it was easier to use MySQL Connector/J for the connection as @Oli described.