InjectionException

[Chetan Raju]

Hello All,

I have deployed a servlet on Sun Java System App Server 9.1. The code snippet for the problem area is

public class GreetingServlet extends HttpServlet {
   [B] @Resource DataSource myDB //already imported javax.sql.DataSource[/B]
    @Override
    public void doGet(
        HttpServletRequest request,
        HttpServletResponse response) throws ServletException, IOException {
        try {
            response.setContentType("text/html");
            response.setBufferSize(8192);
 
            PrintWriter out = response.getWriter();
 
            Connection con = myDB.getConnection();

I am getting a

com.sun.enterprise.InjectionException: Exception attempting to inject Res-Ref-Env-Property: servlets.GreetingServlet/[e-mail]@ resolved as: jndi: servlets.GreetingServlet/myDB@res principal: null@mail: null

I am trying to connect to a MySQL database instance. I have also configured the web.xml for the resource which is a DataSource

<resource-ref>
    <res-ref-name>myDB</res-ref-name>
    <jndi-name>myDB</jndi-name>
    <res-ref-type>javax.sql.DataSource</res-ref-type>
  </resource-ref>

What could be the problem ? Can anyone help ?

[David O'Meara]

Please don't post the same question in multiple forums. It creates duplicate conversations and wastes the time of the people trying to help you.

Thanks,
Dave