java - 在 Java 中将 Blob 转换为 bytea

Question

我在 postgresql 数据库中工作，我需要仅使用 java 代码将 MYSQL Blob 数据类型转换为 PostgreSQL bytea，有什么办法可以做到这一点吗？

Answer 1

//(assuming you have a ResultSet named RS)
PreparedStatement psMySql = connMySql.prepareStatement("select myBlob from myTable where ...");
Blob blob = rs.getBlob("myBlob");

int blobLength = (int) blob.length();  
byte[] blobAsBytes = blob.getBytes(1, blobLength);

PreparedStatement psPostresql = connPostgresql.prepareStatement("INSERT INTO myNewTable VALUES (?, ?)");
psPostresql.setString(1, myId);
psPostresql.setBytes(2, blobAsBytes);
psPostresql.executeUpdate();

//release the blob and free up memory.
blob.free();