Hi, Newer version of H2 store the LOB object in the database file. You seem to use the newest version of H2, but with an old database file, or with the "lob in database" setting disabled. Is there a reason to keep the LOBs in separate files? If not, I suggest to create a new database (see "migration" in the docs), with the default settings.
Regards, Thomas On Tuesday, July 31, 2012, Sanjeev Sharma wrote: > 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]<javascript:_e({}, 'cvml', > '[email protected]');> > . > To unsubscribe from this group, send email to > [email protected] <javascript:_e({}, 'cvml', > 'h2-database%[email protected]');>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
