访问oracle8i clob字断 提示java.sql.SQLException: 类型长度大于最大值

Question

Connection con = null;
        Statement sm = null;
        DisplaystyleextDto displaystyleextDto = new DisplaystyleextDto();
        System.out.println(
                "displaystyleextFindByStyleid=======================");
        DataSource dataSource = null;
        String sConnStr = "jdbc:oracle:thin:@sea:1521:sea";        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");            con = DriverManager.getConnection(sConnStr, "sea", "sea");
            String strSQL = "select * from displaystyleext where styleid = " +
                            22;
            System.out.println(strSQL);
            sm = con.createStatement();
            ResultSet rsnc =  sm.executeQuery(strSQL);
            while (rsnc.next()) {  
                CLOB cb = (CLOB) rsnc.getClob(1);
                BufferedReader br = new BufferedReader(cb.getCharacterStream());                String s = br.readLine();
                String content = null;
                while (s != null) {
                    content += s;
                    s = br.readLine();
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }

Answer 1

数数错了没有？rsnc.getClob(1); 第一个字段是 CLOB 吗？是不是 styleid？