java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:ORCL
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.hsp.utils.SqlHelper.getConnection(SqlHelper.java:67)
at com.hsp.utils.SqlHelper.executeQuery(SqlHelper.java:130)
at com.base.userservice2nd.checkUser(userservice2nd.java:15)
at cn.checkServlet.doGet(checkServlet.java:34)
at cn.checkServlet.doPost(checkServlet.java:46)
java.lang.NullPointerException
at com.hsp.utils.SqlHelper.executeQuery(SqlHelper.java:131)
at com.base.userservice2nd.checkUser(userservice2nd.java:15)
at cn.checkServlet.doGet(checkServlet.java:34)
at cn.checkServlet.doPost(checkServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
uj5u.com熱心網友回復：
oracle.propertiesdbUserName=scott
dbPassword=tiger
dbDriver=oracle.jdbc.driver.OracleDriver
dbUrl= jdbc:oracle:thin:@localhost:1521:ORCL
SqlHelper.java
[code=javastatic
{
try
{
//從dbinfo.properties
pp = new Properties();
fis=SqlHelper.class.getClassLoader().getResourceAsStream("oracle.properties");
//fis = new FileInputStream();
pp.load(fis);
url = pp.getProperty("dbUrl");
driver = pp.getProperty("dbDriver");
username = pp.getProperty("dbUserName");
passwd = pp.getProperty("dbPassword");
Class.forName(driver);
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
try
{ fis.close();}
catch(IOException e) {e.printStackTrace();}
fis = null;//垃圾回收站上收拾
} ][/code]
uj5u.com熱心網友回復：
oracle驅動ojdbc14.jar包已經buildpathuj5u.com熱心網友回復：
換成ojdbc6.jar，除了報上面的錯誤外，還報java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver 錯。uj5u.com熱心網友回復：
目標資料庫的版本是多少？從錯誤上看，還是沒找到合適的驅動包。
確認ojdbc6.jar是否在對應的path下
uj5u.com熱心網友回復：
我用的是oracle11g,jar包放在web-inf下的lib目錄uj5u.com熱心網友回復：
沒有合適的資料庫驅動，建議你先別急，到百度上下載一個11g對應的資料庫驅動。然后在explises中通過加載外部包加載那個驅動。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/104856.html
標籤：開發