Hi Thomas:
I am having almost a similar issue with Clobs. I am trying to migrated my
application form V1 to V2 and in the process reading the clob from V1 and
altering it and putting it into V2 of my application. The H2 that we use is
in embedded mode. So in my scenario V1 is stopped - the H2 database is
accessed via jdbc:file url and the V2 is accessed via jdbc:tcp url. The
code that goes over the result set and does rs.getCharacterStream is
failing.
Here is the 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)
-- This line calls rs.getCharacterStream(index)
at
com.infovista.v360mig.v360.Vista360Migration.performDataMigration(Vista360Migration.java:53)
What should I be doing to get this working.
Thanks
Sanjeev
On Wednesday, December 7, 2011 2:21:16 PM UTC-6, Thomas Mueller wrote:
>
> Hi,
>
> This bug is now fixed in the trunk. Thanks for reporting this issue,
> and thanks a lot for the test case!
>
> Regards,
> Thomas
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/5UdHSqdD-1oJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
