Below is a solution:
String query = "SELECT NOME, IMAGEM FROM LR_TABLE WHERE ID = 1";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
try {
String nome = null;
while (rs.next()) {
nome = rs.getString("nome");
byte longRaw[] = rs.getBytes("imagem");
InputStream stream = new ByteArrayInputStream(longRaw);
PreparedStatement ps = conn.prepareStatement("INSERT INTO LR_TABLE (ID, NOME, IMAGEM) VALUES (21, ?, ?)");
ps.setString(1, nome);
ps.setBinaryStream(2, stream);
ps.execute();
ps.close();
}
Okay, cool then put the solution.
– LR10