Connection con = DBCon.getOracle();
String area;
for(int i=0;i<999;i++){
String sql = "update CUS_HIGHVOLT_METERVAL2 set area = ? where id = "+i;
PreparedStatement stmt =con.prepareStatement(sql) ;
Random r=new Random();
int e =r.nextInt(10);
if(e == 0){
area = "济南";
}else if(e == 1){
area = "青岛";
}else if(e == 2){
area = "淄博";
}else if(e == 3){
area = "枣庄";
}else if(e == 4){
area = "聊城";
}else if(e == 5){
area = "济宁";
}else if(e ==6){
area = "莱芜";
}else if(e == 7){
area = "烟台";
}else if(e == 8){
area = "威海";
}else if(e == 9){
area = "日照";
}else {
area = "泰安";
}
System.out.println(area);
stmt.setString(1, area);
stmt.executeUpdate(sql);
stmt.close();
}
con.commit();
}
Exception in thread "main" java.sql.SQLException: ORA-03115: unsupported network datatype or representation at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1451)
at DB.update.main(update.java:58)
求指教,我找不出什么错误来捏
String area;
for(int i=0;i<999;i++){
String sql = "update CUS_HIGHVOLT_METERVAL2 set area = ? where id = "+i;
PreparedStatement stmt =con.prepareStatement(sql) ;
Random r=new Random();
int e =r.nextInt(10);
if(e == 0){
area = "济南";
}else if(e == 1){
area = "青岛";
}else if(e == 2){
area = "淄博";
}else if(e == 3){
area = "枣庄";
}else if(e == 4){
area = "聊城";
}else if(e == 5){
area = "济宁";
}else if(e ==6){
area = "莱芜";
}else if(e == 7){
area = "烟台";
}else if(e == 8){
area = "威海";
}else if(e == 9){
area = "日照";
}else {
area = "泰安";
}
System.out.println(area);
stmt.setString(1, area);
stmt.executeUpdate(sql);
stmt.close();
}
con.commit();
}
Exception in thread "main" java.sql.SQLException: ORA-03115: unsupported network datatype or representation at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1451)
at DB.update.main(update.java:58)
求指教,我找不出什么错误来捏
改成stmt.executeUpdate();
参见
http://www.coderanch.com/t/304540/JDBC/java/java-sql-SQLException-ORA-unsupported
这里已经设置了sql,下面执行的时候不需要
stmt.executeUpdate(sql);
改成stmt.executeUpdate();