0 Replies Latest reply on Feb 19, 2002 9:13 AM by Ondrej Scecina

    Unable to connect to database

    Ondrej Scecina Newbie

      Hi!

      I've used j2ee from Sun and everything worked. Now with jboss-2.4.4 this situation happend:

      In EJB I've got this code:
      private String dbName = "java:comp/env/jdbc/WDesignerDB";

      private void makeConnection() throws NamingException, SQLException {
      InitialContext ic = new InitialContext();
      DataSource ds = (DataSource) ic.lookup(dbName);
      conn = ds.getConnection();
      }

      Sometimes it works, but sometimes (after few calls of EJB bean) it throws exception on getConnection() method calling. I use MySQL (the new one) and mm.mysql JDBC driver (the new one too). The exception returns null getMessage(), so I do not know what is wrong.

      Has anybody same problem?

      Thanx.