Hi Guys, This is a semi-Linux question... Sorry about that
I've (thanks to Ramon) managed to install Tomcat on my home server. Now, obviously, I want to be able to use Databases in conjunction with JSP.
The first thing I tried was ODBC. I downloaded a program called unixODBC and setup a datasource called kvcom, pointing to a database on the local MySQL server. I tested it using the included DataManager and it worked.
Then I designed the site on my local machine using a WYSIWYG editor (yes, I admit, I'm a fool. Not only that, it's a windows based WYSIWYG editor! Sorry, but I simply couldn't find anything better then Dreamweaver MX). Anyway, Whilst working on the site, I have to specify a connection to use, so that DW will show me the database structure and I can simply drag and drop fields. When I tell DW to conenct to a datasource using the driver on the server, it spits out an "unspecified error" message. So, I setup a datasource on my local PC too and tell it to connect to that, and then it works. Thing is, when I then upload the site to the server and deploy the application, Tomcat spits out a nullpointer exception.
After that failed, I swore. Then, I tried the other method, i.e. using the JDBC MySQL driver (which everyone on the net seems to recommend). I downloaded the driver and put it in the commons/lib directory of Tomcat and in the jre/lib/ext on both my machine and the server. When I try to connect to the one on my machine, it doesn't find the class and when I try to connect to the one on the server, the same unspecified error is spat out.
Is this a Linux thing, a tomcat thing, or a me being stupid thing? Keith
