CLOB and BLOB data type - retrieval failing on getCharacterStream and getBinaryStream calls on result set

95 views
Skip to first unread message

Sanjeev Sharma

unread,
Jul 31, 2012, 5:37:34 PM7/31/12
to h2-da...@googlegroups.com
Here is the exception trace:

org.h2.jdbc.JdbcSQLException: File not found: "C:/Users/ssharma/AppData/Local/Temp/v360-780471439001691522.lobs.db/4.t19.lob.db" [90124-168]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:169)
    at org.h2.message.DbException.get(DbException.java:146)
    at org.h2.engine.Database.openFile(Database.java:458)
    at org.h2.value.ValueLob.getInputStream(ValueLob.java:627)
    at org.h2.value.ValueLob.getReader(ValueLob.java:620)
    at org.h2.value.ValueLob.getString(ValueLob.java:550)
    at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:275)
    at com.infovista.v360mig.v360.Vista360Migration.migrateData(Vista360Migration.java:211)
    at com.infovista.v360mig.v360.Vista360Migration.performDataMigration(Vista360Migration.java:53)

The h2 is embedded mode and accessed using jdbc:file url.

I am stuck with this issue.  Let me know.
Thanks in advance.

Reply all
Reply to author
Forward
0 new messages