TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超6個(gè)贊
使用 Reader，延遲訪問結(jié)果集。
try (Reader reader = rs.getNCharacterStream(...)) {
if (reader == null) {
return null;
}
StringWriter writer = new StringWriter();
reader.transferTo(writer);
return writer.toString();
}
try-with-resources 中允許使用 null reader。
transferTo自 java 10 以來就存在，這里有一個(gè)替代方案。
char[] buf = new buf[1024];
for (;;) {
int nread = reader.read(buf);
if (nread == -1) {
break;
}
writer.write(buf, 0, nread);
}
TA貢獻(xiàn)1824條經(jīng)驗(yàn) 獲得超6個(gè)贊
請(qǐng)檢查您的數(shù)據(jù)庫和驅(qū)動(dòng)程序版本。
getString適用于長(zhǎng)度 > 32K 的 LONG 列
例子
SELECT TEXT_LENGTH FROM DBA_VIEWS where owner = 'SYS' and VIEW_NAME= 'DBA_STREAMS_COLUMNS';
TEXT_LENGTH
-----------
36331
這剪斷了
def rs = stmt.executeQuery("SELECT TEXT FROM DBA_VIEWS where owner = 'SYS' and VIEW_NAME= 'DBA_STREAMS_COLUMNS'")
while(rs.next())
{
String txt = rs.getString(1)
println "got txt ${txt.take(10)}...${txt.reverse().take(10).reverse()}, size: ${txt.length()}"
}
回報(bào)
got txt select dis... ) = 0, size: 36331
使用過的版本
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
DriverVersion 12.1.0.2.0
TA貢獻(xiàn)2019條經(jīng)驗(yàn) 獲得超9個(gè)贊
我用 ResultSet.getBinariToString 解決了，該函數(shù)采用 dba_views.text 的所有字符。感謝你所做的一切。
public String getBinaryToString(String columna){
try {
java.io.InputStream is = resultados.getBinaryStream(columna);
int intValueOfChar;
String targetString = "";
while ((intValueOfChar = is.read()) != -1) {
targetString += (char) intValueOfChar;
}
is.close();
return targetString;
} catch (SQLException | IOException ex) {
Logger.getLogger(Base.class.getName()).log(Level.SEVERE, null, ex);
}
return null;
}
舉報(bào)