title: How to test/verify database table loaded by jdbc against data file?
body: <p>Hi I am creating table using schema file and loading table from data file through jdbc. I am doing batch upload using <code>PreparedStatement</code> and <code>executeBatch</code>. Data file contents look like the following structure:</p>
  
  <pre><code>key  time   rowid  stream
  X    11:40   1      A
  Y    3:30    2      B 
  </code></pre>
  
  <p>Now I am able to load successfully table in database. But I would like to test/verify that same table loaded into database against this same data file. how do I do it? How do compare table in database with data file? I am new to JDBC. Please guide. Thanks in advance.</p>