title: Output SQL query results to flat-file with Java
body: <p>Is there an easy or straightforward way in Java to output the results of a DB Query to a file (either csv, tab, etc).  Perhaps even in Hibernate?</p>
  
  <p>I know that a query results can be dumped to a flat file on the DB Server.  I am looking for a way that an application can run a query and get those results into a file.</p>
  
  <p>I realize one option is to just iterate over the result set and output the records one row at a time separating with a delimiter.  But if there is a built in way, or a Hibernate way - that would be much better!</p>
  
  <p>What I am really looking for was a way to do this in code (like - when an application is running). That way a server could take a query, run it against the database, send the output to a flat-file.</p>
  
  <p>The server sending the query doesn't really need the file itself, just to know it worked.  So if there is SQL (for an Oracle DB) that could redirect the output to a flat-file in a directory that the Oracle DB Server has access to - that would work too.  I don't really have to actually write the file in the Java Server - just trigger the file creation based on the query it has.</p>
  
  <p>Hopefully that makes sense.</p>