关于sql server与db2的数据转换问题(急!)
在程序中将sql server中的数据写入db2中的相应表格字段中,如何将sql server中的image字段写入db2中(定义何种数据类型?如何写入?)。或是有没有其它的方法或工具可以转换?以下是我的过程:
String sql2 = "create table district2(zxid BIGINT, minx decimal(8), miny double, maxx double, maxy double, shape blob(16), AREA double, PERIMETER double, GRPH char(16), TYPE BIGINT, CNAME char(60), ENAME char(100))";
statement.executeUpdate(sql2);
String sql1 = "select zxid, minx, miny, maxx, maxy, shape, AREA, PERIMETER, GRPH, TYPE, CNAME, ENAME from district";
String sql = null;
try{
ResultSet rs = ds2.staStatement.executeQuery(sql1);
while(rs.next()){
rs.next();
zxid = rs.getLong("zxid");
minx = rs.getDouble("minx");
maxx = rs.getDouble("miny");
miny = rs.getDouble("maxx");
maxy = rs.getDouble("maxy");
shape = rs.getBytes("shape");
area = rs.getDouble("AREA");
perimeter = rs.getDouble("PERIMETER");
grph = rs.getString("GRPH");
type = rs.getLong("TYPE");
cname = rs.getString("CNAME");
ename = rs.getString("ENAME");
sql = "insert into district2(zxid,minx,miny,maxx,maxy,AREA,PERIMETER,GRPH,TYPE,CNAME,ENAME) values("+zxid+","+minx+","+miny+","+maxx+","+maxy+","+area+","+perimeter+",'"+grph+"',"+type+",'"+cname+"','"+ename+"')";
ds.staStatement.executeUpdate(sql);
}
}catch(Exception ex){
ex.printStackTrace();
System.out.println("Select Error!");
}
在插入shape(原来是image格式)时出错,提示遇到非法字符‘【’,打印shape时为[B@43!4