I have two databases and I need to copy data from one table and put it in a table in the other database
I tried doing whatever ive done below but it shows an error
Connection to SQLite has been established.
Exception in thread "main" org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column:)
What I have tried:
ResultSet rs = null;
Statement st = null;
String SEL_QUERY = "select TID,Artikullit,Sasiat,cmimit,totalt from T1";
String UPDATE_QUERY = "insert into Shitja (TSID,Artikullis,Sasias,cmimis,totals) values(?,?,?,?,?)";
String DELETE_QUERY = "delete from T1";
try {
conn.setAutoCommit(false);
st = conn.createStatement();
pst = conn.prepareStatement(SEL_QUERY);
rs = pst.executeQuery();
pst1 = conn.prepareStatement(UPDATE_QUERY);
while (rs.next()) {
int TID = rs.getInt("TID");
System.out.println(" TID : " + TID);
pst1.setInt(1, TID);
pst1.addBatch();
String Artikullit = rs.getString("Artikullit");
System.out.println(" Artikullit : " + Artikullit);
pst1.setString(2, Artikullit);
pst1.addBatch();
String Sasiat = rs.getString("Sasiat");
System.out.println(" Sasiat : " + Sasiat);
pst1.setString(3, Sasiat);
pst1.addBatch();
String cmimit = rs.getString("cmimit");
System.out.println(" cmimit : " + cmimit);
pst1.setString(4, cmimit);
pst1.addBatch();
String totalt = rs.getString("totalt");
System.out.println(" totalt : " + totalt);
pst1.setString(5, totalt);
pst1.addBatch();
}
pst1.executeBatch();
st.execute(DELETE_QUERY);
conn.commit();
conn.close();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}