Oracle CLOB 大字段转String的问题

Question

Oracle version 9.2

Driver version  ojdbc6.jar

执行以下代码，无法读取出字符串：

public void testReadClob() throws Exception {
		MyOperation st = new MyOperation();
		Connection conn = st.getConnection();
		PreparedStatement ps = conn
				.prepareStatement("SELECT * FROM STUDENT WHERE ID = 64");
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			Clob clob = rs.getClob("DEMO");
			
			String detailinfo = "";
			int i = 0;
		    if(clob != null){
		     InputStream input = clob.getAsciiStream();
		     int len = (int)clob.length();
		     byte by[] = new byte[len];
		     while(-1 != (i = input.read(by, 0, by.length))){
		      input.read(by, 0, i);
		     }
		     detailinfo = new String(by);
		     System.out.println(detailinfo);
		    }
			 

	
		}
		rs.close();ps.close();
		conn.close();
	}

错误记录：

 

Answer 1

驱动问题！ Oracle驱动的有些方法有问题啊，使用起来。

Answer 2

没表述清楚，应该是当CLOB 字段的值大于1G 时