tomcat and db connectivity

[salil misra]

hello,this is salil misra

this has become a big headache for me ...
i am trying to develop my project and trying to get db connectivity

i am using following :

1) tomcat 5
2) my sql db

i want to know :

1) i want to use a type 4 jdbc driver
2) for db connectivity what all to configure in the web.xml file


this is a request i have ben stuck on this for many days now please do provide answers to my questions its very much important for me

[Sachin Joshi]

You need to download MySQL driver jar file from

MySQL Connector

Keep this jar in your tomcat -> webapps/<YourApp>/WEB-INF/lib directory.

And use JDBC API to connect to MySQL.

Make sure your MySQL database is up up and running.

You can find some Example code about how to connect using JDBC thin driver
[ August 26, 2008: Message edited by: Sachin Joshi ]

[Kalyan Ram]

Salil, if you do as the Sachin says you don't have to configure anything in the web.xml.

OTOH, if you want to configure MySQL as JNDI resource then check Tomcat's documentation or click here -> mysql datasource in tomcat

regards
Kalyan
[ August 26, 2008: Message edited by: Kalyan Ram ]

[Harmandeep Singh]

Nothing is to be done in the web.xml file.
Connectivity coding is to be written in java class.

It as below:

 
 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
public class JdbcExample2 {
 
  public static void main(String args[]) {
    Connection con = null;
 
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      con = DriverManager.getConnection("jdbc:mysql:///test",
        "root", "secret");
 
      if(!con.isClosed())
        System.out.println("Successfully connected to " +
          "MySQL server using TCP/IP...");
 
    } catch(Exception e) {
      System.err.println("Exception: " + e.getMessage());
    } finally {
      try {
        if(con != null)
          con.close();
      } catch(SQLException e) {}
    }
  }
}
 
   

I hope it will help you.

With regards
From
Harmandeep Singh