0 Replies Latest reply on Sep 28, 2009 6:57 AM by sbutt

    DB connection problem on JBoss/Linux

    sbutt

      Hi Folks,
      I'm having problems in connecting to a mySql DB through JDBC on JBoss.

      I'm using the following code.

      try
       {
       String userName = "admin";
       String password = "m9ad3e";
       String url = "jdbc:mysql://hh-linux1/IntegraDB";
       Class.forName ("com.mysql.jdbc.Driver").newInstance ();
       conn = DriverManager.getConnection (url, userName, password);
       System.out.println ("Database connection established");
      
      
       }
       catch (Exception e)
       {
       e.printStackTrace();
       System.err.println ("Cannot connect to database server");
       }


      It works fine on Windows/Tomcat.

      But when i deploy the .war file on JBoss server running on linux it gives exception.

      java.sql.SQLException: Access denied for user 'admin'@'HH-Linux1.usbeck.de' (using password: YES)
      2009-09-28 12:56:09,844 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
      2009-09-28 12:56:09,844 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
      2009-09-28 12:56:09,844 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700)
      2009-09-28 12:56:09,844 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)
      


      it is even trying to connect to some other server somehow admin'@'HH-Linux1.usbeck.de'?

      Can someone pls help.