Agfdhyk

A little background: I am making an Android application that will remain offline most of the time. The application will need to sync with a MS SQL server database when it connects to wifi. The on-board database is SQLite. I am also very new to Java/Android development so I apologize if I'm missing the obvious somewhere.

I am able to make transactions with MS SQL server quite well using the JTDS driver however when I am querying the MS SQL server, I end up with a ResultSet object that I have to loop through one row at a time. Is there a tool/method out there than can simply insert all rows from a ResultSet into a SQLite database table?

I am currently using the standard:

ArrayList<ArrayList<String>> table = new ArrayList<>(); // a list of lists to represent a table

ArrayList<String> row = new ArrayList<>(); // a list to represent a row of the table



Class.forName("net.sourceforge.jtds.jdbc.Driver"); 



conn = DriverManager.getConnection(connectionString);

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery(query);

ResultSetMetaData meta = rs.getMetaData();



while (rs.next())

{

     row = new ArrayList<>();



     for (int i = 1; i < meta.getColumnCount() + 1; i++) // load data into List

     {

         row.add(rs.getString(i));

     }



     table.add(row);

 }

From here I was going to loop through my list and add each row one by one to the SQLite database table. This seems inefficient to me. Was just looking for a better way to copy table from MS SQL Server to SQLite on an Android device.