|
|
|
запись в BLOB на ORACLE
|
|||
|---|---|---|---|
|
#18+
Есть код db_con.setAutoCommit(false); sql = "select content from a where id = " + id + " for update"; rs = st.executeQuery(sql); if (rs.next()) { blob = ((oracle.jdbc.driver.OracleResultSet)rs).getBLOB(1); blob.putBytes(1L, data); } rs.close(); При попытке записать в BLOB поле получаю ошибку [04.10.06 06:50:04] Invocation exception: ORA-22990: LOB locators cannot span transactions (java.sql.SQLException: ORA-22990: LOB locators cannot span transactions ) java.sql.SQLException: ORA-22990: LOB locators cannot span transactions at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.v8TTILob.receiveReply(v8TTILob.java:991) at oracle.jdbc.ttc7.v8TTILob.write(v8TTILob.java:249) at oracle.jdbc.ttc7.TTC7Protocol.lobWrite(TTC7Protocol.java:2365) at oracle.sql.LobDBAccessImpl.putBytes(LobDBAccessImpl.java:304) at oracle.sql.BLOB.putBytes(BLOB.java:367) at aktif$docmanager$doc1$html.run(aktif$docmanager$doc1$html.java:1490) В чем проблемма? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.10.2004, 20:22 |
|
||
|
|

start [/forum/topic.php?desktop=1&fid=59&tid=2153636]: |
0ms |
get settings: |
11ms |
get forum list: |
20ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
80ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
31ms |
get tp. blocked users: |
1ms |
| others: | 235ms |
| total: | 396ms |

| 0 / 0 |
