Skip to main content

Posts

Showing posts with the label JDBC

Howto setup a MySQL Connector/J 5.1 for Tomcat on Linux

Again, I'm not switching to Java. :) For clarity, I'm helping one of my online buddies to setup and use Ruby even as I write this. This work was something I had to do for a Rails project which used JSPs and stuff with a MySQL database over JDBC. The application setup was quite interesting calling JSPs to work with a Rails webapp. Actually the following things are found on the Internet. I cannot remember all the sources I looked at, but one was the MySQLs own documentation and Apache Tomcat documentations. So if this works (which in my case did), credit should not be mine. :) Here's the setup. GNU/Linux (in my case CentOS 5, although should work with any Linux distro) Apache Tomcat (5.5.25, should work with Tomcat 5.5 range) Sun JDK (1.6.0_04) MySQL (5.0.22) MySQL Connector/J (5.1) 1. I assume that Java is setup ( See my previous post for more details on setting up Java manually), and your MySQL is running on the same host on port 3306. Please replace your actual settings i...