在线等待java.sql.SQLException: ORA-01002: 读取违反顺序错误,请问这是什么错误啊。 按顺序读个字段,这是jdbc的规矩是规矩就得遵守 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 修改后,还是提示:java.sql.SQLException: ORA-01002: 读取违反顺序错误import java.sql.*; import java.io.*; import oracle.jdbc.driver.OracleResultSet;import oracle.sql.CLOB;public class TestOracleClob implements Serializable{ public static void main(String[] args) { //create table test (id integer,content clob); System.out.println("-------------------insert -----------------"); try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.40:1521:A10DB","exam","123456"); String sql="insert into test values(1,empty_clob())"; Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(sql); String sqll="select content from test where id=1 for update"; ResultSet rss=stmt.executeQuery(sqll); if(rss.next()) { CLOB clob = ((OracleResultSet)rss).getCLOB(1); clob.putString(1,"ddddddddddddddddddddddddd676667565jkkkmmmmmmmmmtggddddddddddddddddddddddddddddddddddddd"); sql="update test set content=? where id=1"; PreparedStatement pstmt=con.prepareStatement(sql); pstmt.setClob(1,clob); pstmt.executeUpdate(); pstmt.close(); } String sql12="insert into test values(?,?)"; PreparedStatement pstmt1=con.prepareStatement(sql12); pstmt1.setInt(1,2); pstmt1.setClob(2,oracle.sql.CLOB.empty_lob()); pstmt1.executeUpdate(); String sqll2="select content from test where id=2 for update"; ResultSet rss2=stmt.executeQuery(sqll2); if(rss2.next()) { CLOB clob = ((OracleResultSet)rss2).getCLOB(1); clob.putString(1,"123affffffffffdfdfdfdddddddffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddfff"); String sql1="update test set content=? where id=2"; PreparedStatement pstmt=con.prepareStatement(sql1); pstmt.setClob(1,clob); pstmt.executeUpdate(); pstmt.close(); } //con.commit(); rss.close(); rss2.close(); pstmt1.close(); rs.close(); stmt.close(); con.close(); System.out.println("-------------insert ok-------------"); } catch(Exception e) { System.out.println("insert:"+e); } }} myeclipse问题 重复新开页面问题,急!!! 麻烦大家帮看看为什么总是提示: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'biao' 无效。 求助各位高手,fck编辑器 请问doGET 方式,最多能传多少个参数? 100分 struts2如何导出word文档呢 请求一下webservice 问题 动态刷新 关于localhost和tomcat的问题--在线等 看了7月份程序员《WEB开发框架》的近来聊聊 请教一条插入数据的sql语句(DB2)? 高手(100分):通过javabeans自动生成sql语句的问题?
import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.OracleResultSet;
import oracle.sql.CLOB;public class TestOracleClob implements Serializable
{
public static void main(String[] args)
{
//create table test (id integer,content clob); System.out.println("-------------------insert -----------------");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.40:1521:A10DB","exam","123456");
String sql="insert into test values(1,empty_clob())";
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
String sqll="select content from test where id=1 for update";
ResultSet rss=stmt.executeQuery(sqll);
if(rss.next())
{
CLOB clob = ((OracleResultSet)rss).getCLOB(1);
clob.putString(1,"ddddddddddddddddddddddddd676667565jkkkmmmmmmmmmtggddddddddddddddddddddddddddddddddddddd");
sql="update test set content=? where id=1";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setClob(1,clob);
pstmt.executeUpdate();
pstmt.close();
} String sql12="insert into test values(?,?)";
PreparedStatement pstmt1=con.prepareStatement(sql12);
pstmt1.setInt(1,2);
pstmt1.setClob(2,oracle.sql.CLOB.empty_lob());
pstmt1.executeUpdate();
String sqll2="select content from test where id=2 for update";
ResultSet rss2=stmt.executeQuery(sqll2);
if(rss2.next())
{
CLOB clob = ((OracleResultSet)rss2).getCLOB(1);
clob.putString(1,"123affffffffffdfdfdfdddddddffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdddfff");
String sql1="update test set content=? where id=2";
PreparedStatement pstmt=con.prepareStatement(sql1);
pstmt.setClob(1,clob);
pstmt.executeUpdate();
pstmt.close();
}
//con.commit();
rss.close();
rss2.close();
pstmt1.close();
rs.close();
stmt.close();
con.close();
System.out.println("-------------insert ok-------------");
}
catch(Exception e)
{
System.out.println("insert:"+e);
}
}
}