import java.sql.*;
import com.microsoft.sqlserver.jdbc.SQLServerResultSet;
public class transfer {

   public static void main(String[] args) {

      // Create a variable for the connection string.
      String connectionUrl0 = "jdbc:sqlserver://hostname:1433;" +
         "databaseName=aaa;user=bbbb;password=cccc";

      // Declare the JDBC objects.
      Connection con0 = null;
      Statement stmt = null;
      ResultSet rs = null;

      try {
         // Establish the connection.
         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
         con0 = DriverManager.getConnection(connectionUrl0);

         // Create and execute an SQL statement that returns some data.
         String SQL = "SELECT * FROM " +args[ 0 ];//dbo.phototag";
         String delimiter = ",";//"@" ;//args[1];
         stmt = con0.createStatement(SQLServerResultSet.TYPE_SS_SERVER_CURSOR_FORWARD_ONLY, +
                        SQLServerResultSet.CONCUR_READ_ONLY);
         //PreparedStatement pstmt = con0.prepareStatement(SQL,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
         stmt.setFetchSize(1000);
         rs = stmt.executeQuery(SQL);
         //rs=pstmt.executeQuery();

         ResultSetMetaData rsmd = rs.getMetaData();
         int ncols = rsmd.getColumnCount();

         // Iterate through the data in the result set and display it.
         int count = 0;
         long t = System.currentTimeMillis();
        StringBuilder sb = new StringBuilder(1000000);

         while (rs.next()) {

            sb.append(rs.getString(1));
            for(int i=2;i<=ncols;i++)
            {
              sb.append(delimiter+rs.getString(i));
            }
            sb.append("\n");

            System.out.print(sb);
            if ((++count)%100000==0) 
            {
              long dt = (System.currentTimeMillis()-t);
              double speed  = count*1000./dt;
              double elaps = ((354254163.-count)/speed)/3600;
              double elaps1 = ((long)(elaps*100) )/100.;
              System.err.println("Time: " + dt / 1000. + "s "+
                "Processed: " + count+" records "+
                "Speed: " + (int)speed +"rec/s "+
                "Rem: " + elaps1+ " h");
            }
            sb.setLength( 0 );
         }
      }

      // Handle any errors that may have occurred.
      catch (Exception e) {
         e.printStackTrace();
      }
      finally {
         if (rs != null) try { rs.close(); } catch(Exception e) {}
         if (stmt != null) try { stmt.close(); } catch(Exception e) {}
         if (con0 != null) try { con0.close(); } catch(Exception e) {}
      }


}
}