I created a web project in eclipse with database connection using mysql and for connection I used the following code :
public Connection dbConnect() throws Exception{
System.out.println("Listing all table name in Database!");
// strConnect = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & gDatabase_Name & ";Data Source=" & gServer_name
// gADOConnection.Open strConnect
Connection con=null;
String url = "jdbc:mysql://localhost:3306/";
String db = "employee";
String driver1 = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "welcome";
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=DriverManager.getConnection ( url+db,user,pass );
System.out.println("end of testDbconnect");
}catch(Exception e){
e.printStackTrace();
}
return con;
}
}
I is running fine but when I made war of it and deployed on
tomcat its not connecting to database.
Can anyone tell me the reason? Why its happening so?