- I have the below servlet code.
- While printing the below line in console, it should be printed in red color. "*Connection name "+cname+" already exists. Please try with another name". how to get this.
My servlet code:
try{ Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); con =DriverManager.getConnection("jdbc:oracle:thin:@"+host+":"+port+"/"+service,username,password); con.setAutoCommit(false); if(con!=null){ if(key == null){ out.println("Connected Successfully"); String rootPath=request.getSession().getServletContext().getRealPath("/"); System.out.println(rootPath); String propPath=rootPath+"/WEB-INF/"; PrintWriter out1 = new PrintWriter(new BufferedWriter(new FileWriter(propPath+"importedDB.properties", true))); out1.println(cname+"=jdbc:oracle:thin:@"+host+","+port+","+service+","+username+","+password); out1.close(); } else{ out.println("*Connection name "+cname+" already exists. Please try with another name"); } }else{ out.println("Error in getting connection"); } }catch(Exception e){ e.printStackTrace(); }
access databaseandwrite some text in consolein yourservlet!!!