I am a new java programmer and having issues with Servlets without use of JSP. I made a simple java application with a SingletonDBConnect class that makes a connection to Access.mdb or MAMP db without any issues and will return a connection object to run any type of statements I like.
The problem is that I created a dynamic web project and made a simple servlet, I brought all the other classes that run my DB code but When I try to call my singleton class that establishes and returns a connection from inside the servlet it doesnt make the connection. I tried this several ways, everything works fine if I dont use the servlet but trying to call the singleton class to simply get a conn object back, it doesn't work. I dont want to write all my connection code inside my servlet in any way or any statement code, I would simply like to call different java classes I made and get the conn, stmt etc back and use it in the servlet. Can someone tell me how or if its even possible. Below is my code that returns NULL connection but w/o servlet use it works wonders....
@WebServlet("/DBServlet")
public class DBServlet extends HttpServlet {
private static Connection conn=null;
public void init(){
SingletonDBConnect.getInstance().setDBType(DBTypeEnum.Access);
conn= SingletonDBConnect.getInstance().getConnection();
SingletonDBConnect.getInstance().close();
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
PrintWriter pen= resp.getWriter();
if(conn==null){
pen.write("Not connected");
}else
pen.write("Its working");
}
}
