title: Get a BigInt value from a resultset (oracle db) in java
body: <p>I want to get a BigInt value from oracle database in jdbc. <code>getBigInt()</code> or <code>getBigInteger()</code> does not work like <code>getInt()</code>. Here is the code snippet:</p>
  <pre><code>public List&lt;Employee&gt; getAllEmployees()
  {
      List&lt;Employee&gt; employeeList = new ArrayList&lt;Employee&gt;();
      try
      {
          //typical jdbc coding
          Connection conn = DBUtil.getConnection();
          Statement st = conn.createStatement();
          ResultSet rs = st.executeQuery(&quot;SELECT * FROM employee1&quot;);
          while(rs.next())
          {
              Employee employee = new Employee(rs.getString(&quot;emp_id&quot;), rs.getString(&quot;name&quot;), rs.getBigInt(&quot;emp_mob&quot;));
              employeeList.add(employee);
          }
          DBUtil.closeConnection(conn);  //close connection
      }
      catch(Exception e)
      {
          e.printStackTrace();
      }
      
      return employeeList;
  }
  </code></pre>
  <p><strong>emp_mob column in the table contains big integer values.</strong></p>