title: Why does executeUpdate() function not work? Give steps to solve in a normal project rather than a maven based project
body: <p>CODE:</p>
  
  <pre><code>/*
   * To change this license header, choose License Headers in Project Properties.
   * To change this template file, choose Tools | Templates
   * and open the template in the editor.
   */
  package aaa;
  import static aaa.DB.geom;
  import static aaa.DB.getConnection;
  import java.sql.DriverManager;
  import java.sql.Connection;
  import java.sql.PreparedStatement;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Statement;
  
  public class JDBCExample {
  
    public static void main(String[] argv) throws SQLException {
  
  
  
      try {
  
        Class.forName("org.postgresql.Driver");
        // Class.forName("com.mysql.jdbc.Driver");
  
      } catch (ClassNotFoundException e) {
  
        System.out.println("Where is your PostgreSQL JDBC Driver? " +
          "Include in your library path!");
        e.printStackTrace();
        return;
  
      }
  
      System.out.println("PostgreSQL JDBC Driver Registered!");
  
      Connection connection = null;
  
      try {
  
        connection = DriverManager.getConnection(
          "jdbc:postgresql://localhost:5432/postgres", "postgres",
          "abc");
  
      } catch (SQLException e) {
  
        System.out.println("Connection Failed! Check output console");
        e.printStackTrace();
        return;
  
      }
  
      if (connection != null) {
        System.out.println("You made it, take control your database now!");
  
        //Connection conn = getConnection();
  
  
        connection.setAutoCommit(false);
        Statement s = null;
        try {
          s = connection.createStatement();
        } catch (Exception e) {
          System.out.println("statmnt connection not works");
        }
        PreparedStatement ss = connection.prepareStatement("SELECT * FROM nodes_road_geoms");
        try {
          ss.executeUpdate();
        } catch (Exception e) {
          System.out.println("statmnt excute update connection not works: ");
          e.printStackTrace();
        }
        String query = "CREATE TABLE COMPANY(ID INT );";
  
        ResultSet r = s.executeQuery(query);
        connection.commit();
      } else {
        System.out.println("Failed to make connection!");
      }
    }
  
  }
  </code></pre>
  
  <p>RUN:</p>
  
  <pre><code>-------- PostgreSQL JDBC Connection Testing ------------
  
  PostgreSQL JDBC Driver Registered!
  
  You made it, take control your database now!
  
  Exception in thread "main" java.lang.NoSuchMethodError: 
  
  org.postgresql.core.BaseConnection.getPreferQueryMode()Lorg/postgresql/jdbc/PreferQueryMode;
      at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:151)
      at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
      at aaa.JDBCExample.main(JDBCExample.java:69)
  C:\Users\Dell\AppData\Local\NetBeans\Cache\8.2\executor-snippets\run.xml:53: Java returned: 1
  BUILD FAILED (total time: 0 seconds)
  </code></pre>
  
  <p>QUESTION:Give me steps to solve it since database is connected already! What is the core of the problem?
  The problem is that if database postgresql connected then why not insert into database. The tables are also available and seen from netbeans. There needs to be a way to solve this run time exception issue when there is a query execution... So I needed step by step details to make it correct.</p>
  
  <p><img src="https://i.stack.imgur.com/vV2kh.png" alt="the pgAdmin shows the nodes_road_geoms column same as the netbeans shows up"></p>