aspose file tools*
The moose likes JDBC and the fly likes Need mysql configuration and setup details Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need mysql configuration and setup details" Watch "Need mysql configuration and setup details" New topic
Author

Need mysql configuration and setup details

Mayilsamy Annamalai
Ranch Hand

Joined: Sep 18, 2010
Posts: 35

Could any one can give me the servlet , jsp and mysql connectivity, mysql configuration and setup details documentation or tutorial??
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39865
    
  28
Have you searched anywhere?

Moving discussion to our databases forum.
Jelle Klap
Bartender

Joined: Mar 10, 2008
Posts: 1824
    
    7

In the context of Servlets, it would probably be best and easiest to configure the "MySQL connectivity" in the servlet container / application server.
How that works exactly is container dependent. If you can tell us which container you are using we'll take it from there


Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life.
Mayilsamy Annamalai
Ranch Hand

Joined: Sep 18, 2010
Posts: 35

Thanks for your reply. I'm using the Tomcat server. And could you explain me or give me any link to study about how to use eclipse for servlet and jsp!!
Awaiting for your reply!!
Jelle Klap
Bartender

Joined: Mar 10, 2008
Posts: 1824
    
    7

I'm going to assume Tomcat 7, but there's similar documentation available online for earlier versions.
This is the server documentation index.
What your looking for is the JDBC Datasource section. It should contain an entry on how to configure a MySQL data source that uses DBCP for connection pooling.
It might be useful to read the JNDI resources section first though.

As for using Eclipse to develop Servlets and JSP pages, you'd probably want to have a look at the Web Tools Platform. Documetation can be found here.
 
Don't get me started about those stupid light bulbs.
 
subject: Need mysql configuration and setup details