2 Replies Latest reply on Feb 10, 2018 5:11 PM by Ed Hourigan

    Cannot connect to a mysql/mariadb - wildfly 11

    Ed Hourigan Newbie

      I am trying to move from tomcat standalone to wildfly 11.

      I am stuck trying to get connectivity to a mariadb ( fka mysql ).

       

      I followed all the steps to install the mysql-connector-java-5.1.45.jar file

      NOTE: mariadb version is 10.2.9-3

       

      Updated  standalone.xml to setup the datasource.

      I event used the admin console to test the datasource connectivity and it reports "success".

       

      However, in my java class derived from HttpServlet, and exception is thrown trying to connect to the mariadb:

       

      org.h2.jdbc.JdbcSQLException: Table "TESTME" not found; SQL statement:

       

      Why is wildfly using the "h2" database instead of mysql connection class?

       

      Here is my java code:

           try {

          Context initCtx = new InitialContext();

          System.out.println("Call lookup context for java:/comp/env ...");

          Context envCtx  = (Context) initCtx.lookup("java:comp/env");

        

          System.out.println("Call lookup for DataSource jdbc/TEST_DATABASE ...");

          /* lookup using the jndi-name */

          ds = (DataSource) envCtx.lookup("jdbc/TEST_DATABASE");

          System.out.println("ValidateUser: DataSource Ready!");

          System.out.println(ds.toString());

          try {

          m_mysql_conn = ds.getConnection();

          System.out.println("ListService: Got Connection OK!");

          }

          catch (Exception x)

          {

          System.out.println("ListService: getConnection:EXCEPTION - " + x );

       

       

          }

          }

          catch (Exception e)

          {

          System.out.println("EXCEPTION - " + e );

          e.printStackTrace();

          throw e;

          }

       

               java.sql.Connection conn = m_mysql_conn;

       

       

      // This line throws the exception

       

                  PreparedStatement pst = conn.prepareStatement("Select  field1, field2, from test_table where field1=? and field2=?");