I am trying to setup a database for my servlet applications. Right now I am trying to set up MySQL, but it seems that it is quite cumbersome to set up. Is there any other free database I can set easily? Also, I am using Tomcat for my servlet container how would I go about connecting my app and the database? This is all under win 2000. Thanks for your help.
I've not used the current version, but I can vouch that previous versions were easy to install (essentially just put a jar file somewhere in a classpath and maybe tweak a small configuration file). Give it a try!
The thing with mySQL that I always found frustrating is their docs. They are complete. And by complete, I mean a single HTML file has EVERYTHING you could possibly want to know about mySQL. Which makes the task of finding what you want a bit daunting.
It was a head-scratcher for me to get things set up, because they don't seem to have a nice 10 step summary of "how to get this up and running". I do recall finding something like that eventually, but it was buried quite a ways into the big huge HTML file.
What's the specific problem you're having with mySQL? Once it's up, it's fun to play with.
Well, I don't have a specific problem per say. I am just trying to set it up and play with it. The problem was that when I was reading the accompanying document for Connector/J it was a little vague and didn't tell me much. Thanks for the link, Mike!
The only thing I would have to add to this is you can either put the .jar file in your $HOME/WEB-INF/lib which will make it local to your web application of you can put it in $CATALINA_HOME/common/lib which will make it global to all webapps. Just a side note if you are going to use this JDBC driver in javax.naming. you need to put it in common/lib/*.jar and reload tomcat. Hope this helps some.