java - database is not connected after tomcat restart it require reload project -
i have struts2 web application runs on sub domain http://www.abc.example.com.
when tomcat restart, domain , sub-domains started , connected database 1 struts2 application runs on http://www.abc.example.com not connected database till application not reloaded again tomcat manager. using phpmyadmin database , using jdbc connectivity connect that.
my database connection class is-
import java.util.hashmap; import java.sql.connection; import java.util.map; import javax.sql.datasource; import com.mysql.jdbc.jdbc2.optional.mysqldatasource; public class connectionresource { public static map<string, datasource> sessionmap=new hashmap<string, datasource>(); private static string driver = "com.mysql.jdbc.driver"; private static string port = "3306"; private static connection connection = null; private static string ip = "localhost"; private static string user = "root"; private static string password = "123456"; private static mysqldatasource datasource=null; /** * @return ip */ public static string getip() { return ip; } /** * @param ip ip set */ public static void setip(string ip) { connectionresource.ip = ip; } /** * @return user */ public static string getuser() { return user; } /** * @param user user set */ public static void setuser(string user) { connectionresource.user = user; } /** * @return password */ public static string getpassword() { return password; } /** * @param password password set */ public static void setpassword(string password) { connectionresource.password = password; } private static datasource createdatasource(string db) throws exception{ string url="jdbc:mysql://"+ip+":"+port+"/"+db+""; datasource = new mysqldatasource(); datasource.seturl(url); datasource.setuser(user); datasource.setpassword(password); return datasource; } public static connection getconnection(string db){ try{ if(sessionmap.get(db)!=null){ return sessionmap.get(db).getconnection(); }else{ datasource ds=createdatasource(db); sessionmap.put(db, ds); return ds.getconnection(); } }catch(exception e){ e.printstacktrace(); } return null; } } what problem?
according mention feel not deploy. please mention more details correct problem have.
Comments
Post a Comment