mysql - How to read values from .property file in servlet? -
this question has answer here:
i trying connect database using values config .properties file. every time gives file not found exception. same code works in core java.
properties prop = new properties(); inputstream input = null; try { input = new fileinputstream("prop/config.properties"); // load properties file prop.load(input); string ipaddress=prop.getproperty("com.mysql.ipaddress"); string portno=prop.getproperty("com.mysql.portno"); string dbname=prop.getproperty("com.mysql.dbname"); string user=prop.getproperty("com.mysql.user"); string password=prop.getproperty("com.mysql.password"); // property value , print out system.out.println(ipaddress); system.out.println(portno); system.out.println(dbname); system.out.println(user); system.out.println(password); try {class.forname("com.mysql.jdbc.driver");} catch (classnotfoundexception e) {e.printstacktrace();} try { connection connection2 = drivermanager.getconnection("jdbc:mysql://"+ipaddress+":"+portno+"/"+dbname,user,password); statement stmt1=connection2.createstatement(); resultset resultset1=stmt1.executequery("select * main_countt order 1 desc"); while(resultset1.next()) { system.out.println("hello"); system.out.print("<option id='"+resultset1.getstring(1)+"' >"+resultset1.getstring(2)+"</option>"); } } catch(exception e) { e.printstacktrace(); } } catch (ioexception ex) { ex.printstacktrace(); } { if (input != null) { try { input.close(); } catch (ioexception e) { e.printstacktrace(); } } } exception getting:
java.io.filenotfoundexception: prop\config.properties (the system cannot find path specified) @ java.io.fileinputstream.open(native method) @ java.io.fileinputstream.<init>(unknown source) @ java.io.fileinputstream.<init>(unknown source) @ test.servlet1.service(servlet1.java:44) @ javax.servlet.http.httpservlet.service(httpservlet.java:722) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:304) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:240) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:164) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:462) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:164) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:100) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:562) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:395) @ org.apache.coyote.http11.http11processor.process(http11processor.java:250) @ org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:188) @ org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:166) @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:302) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source)
it seems trying access wrong path. try put full path (absolute path):
c:/.../prop/conf...
Comments
Post a Comment