一例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();
上一篇 下一篇

猜你喜欢

热点阅读