Servlet get NullPointerException for DataBase Connection object
Hello evryone
I wrote the code which insert data to database and it work in console application
But when I used in servlet I receive NullPointerException
The result in browser:
java.lang.NullPointerException
database.PersonTable.insert(PersonTable.java:27)
mytest.ServletTest.doGet(ServletTest.java:27)
PersonTable.java
Code:
package database;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class PersonTable {
private static final String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String DB_CONNECTION = "jdbc:oracle:thin:@172.16.78.200:1631:pnatest";
private static final String serverAddress = "172.16.78.200";
private static final String portMap = "1631";
private static final String dbSid = "pnatest";
String url ="jdbc:oracle:thin:@"+serverAddress+":"+portMap+":"+dbSid;
String id ="test_1";
String pass ="test_1";
public int insert()throws SQLException {
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
String insertSQL = "INSERT INTO PERSON (ID,FNAME, LNAME) VALUES (?,?, ?)";
dbConnection = getDBConnection();
preparedStatement = dbConnection.prepareStatement(insertSQL);
int result = 0;
try {
preparedStatement.setString(1,"5");
preparedStatement.setString(2, "Raje");
preparedStatement.setString(3, "rock");
result = preparedStatement.executeUpdate();
preparedStatement.close();
dbConnection.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
if (preparedStatement != null) {
preparedStatement.close();
}
if (dbConnection != null) {
dbConnection.close();
}
}
return result;
}
private Connection getDBConnection() {
Connection dbConnection = null;
try {
Class.forName(DB_DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
dbConnection = DriverManager.getConnection(DB_CONNECTION, id, pass);
} catch (SQLException e) {
System.out.print("here");
e.printStackTrace();
}
return dbConnection;
}
Servlet Code:doGet Method
Code:
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PersonTable pt = new PersonTable();
try {
pt.insert();
} catch (SQLException sql){
sql.printStackTrace();
}
Thanks in advance
Re: Servlet get NullPointerException for DataBase Connection object
I find it
In tomcat library I didnot define jdbc for database connectivty
thanks
