一例ORA-03115: unsupported network
2018-08-09 本文已影响23人
yahzon
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
错误代码:
String sql = "...";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setInt(1, intValue);
List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();
ResultSet rs = stmt.executeQuery(sql);
错误原因:
ResultSet rs = stmt.executeQuery(sql); 里面不能再写参数了,sql多余。
正确代码:
String sql = "...";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setInt(1, intValue);
List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();
ResultSet rs = stmt.executeQuery();