Cópia de tabela

java.sql.SQLException: Column count doesn’t match value count at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)

at copia.main(copia.java:26)

import java.sql.*;

public class copia {

public static void main(String args[]) {

Connection con1;

Connection con2;

String query1 = “select * from fut where pais = ‘Albania’”;

Statement state1;

PreparedStatement ps;

int i;

int linhas;

try {

Class.forName(“org.postgresql.Driver”);

con1 = DriverManager.getConnection(“jdbc:postgresql://localhost/postgres”, “postgres”, “peposa”);

state1 = con1.createStatement();

ResultSet rs = state1.executeQuery(query1);

ResultSetMetaData rsmd = rs.getMetaData();

Class.forName(“com.mysql.jdbc.Driver”);

con2 = DriverManager.getConnection(“jdbc:mysql://localhost/futebol”, “root”, “peposa”);

int cont = rsmd.getColumnCount();

while (rs.next()) {

for (i = 1; i <= cont; i++) {

System.out.print(rs.getString(i));

}

String query2 = “insert into fut values(” + i + “)”;

ps = con2.prepareStatement(query2);

linhas = ps.executeUpdate();

}

state1.close();

con1.close();

con2.close();

}

catch (ClassNotFoundException e) {

System.out.println(“Driver perdido”);

}

catch (SQLException ex) {

System.out.println(“Query perdida”);

ex.printStackTrace();

}

}

}