[elicia]

Hello good people,
Seems like such a simple thing, but I can't find good instructions on it!
New to eclipse, I set up a project on Eclipse 3.4 and Tomcat; I set up the mysql database and see the tables ; but when I browse to the project and try to log in, the log in doesn't work, so I assume I don't know how to point the project to the database.
Thanks!

[jwenting]

RTFM. If it's not in the manual and you can't figure it out without for yourself, the tool is the wrong one for you.

[hmausolf]

That's the reason why I really like forums like this one.

I'm into programming for nearly 30 years, and sometimes I fail to find the solution for a problem which is easier to solve than I expected. When I'm desperate enough, I might ask some forum for help and every so often I find someone who shows me the tree inside the forest. I wonder if there is anybody out there who never asked a question that seemed too easy to answer to some others.

I think rudeness as we found it in jwentings answer is at the very least unpolite and is definetily not the intention of this forum, is it?

[EZapata]

Your problem description is too vague and does not contain enough information for anyone to see what you are asking.

From what I read, you run the application and try to log in, but the login fails. Maybe the application is taking your userid/password and looking it up in database and not finding match?

Or maybe, application cannot connect to database to verify userid/password?

Is the application connecting to the database at all?

Any error messages?

There is not much information in your original post to even try to respond.

[djhill]

I agree. I just joind this forum, and if that is the quality and tone of response I can expect from the MODERATOR I doubt I'll be spending much time here. He might at least have provided a link to the topic in the, er, FM.

elicia (if you're even bothering to follow this thread after being flamed),
You need to create a datasource configuration for Tomcat. The contents vary by database, but at minimum you need to specify the driver name and the URL for the database, just as you would when using driver manager. Define a resource ref for the datasource in your web.xml so you can look it up by its JNDI name from your application code. You'd then call getConnection() on the returned datasource, optionally providing an id and password (the datasource could provide these, too).

You should be able to find many samples on he web if you search "tomcat MySQL datasource".

If you just want to access the database from within eclipse (rather than from a web application) you'll find that more straightforward with WTP (Ganymede) or MyEclipse than vanilla eclipse. To get your feet wet you might play around with an apache derby database first (install the plugins, then right-click on your project and look for the "Apache Derby... Add Apache Derby Nature" selection in the context menu).

Good luck!

[elicia]

Thanks guys! Thanks to you I was able to get it working. There are good people in the world, unlike the childish moderator.

[djhill]

Great! Have fun...