Additionally! I am just trying the option to restore and backup from
a script but we don't always keep the lobs.db files folder (probably
should, but only one table uses a blob and once it has been processed
we don't care about it) so when I try and run the equivalent of:
java org.h2.tools.Script -url jdbc:h2:~/test -user sa -script test.zip
-options compression zip
I get a missing lobs exception :
Exception in thread "main" org.h2.jdbc.JdbcSQLException: File not
found: "C:\gemini\h2\demo-database.lobs.db\1.t33.lob.db"; SQL
statement:
SCRIPT TO 'backup.zip' compression zip [90124-141]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.openFile(Database.java:443)
at org.h2.value.ValueLob.getInputStream(ValueLob.java:610)
at
org.h2.command.dml.ScriptCommand.writeLobStream(ScriptCommand.java:
350)
at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:
264)
at org.h2.command.CommandContainer.query(CommandContainer.java:
80)
at org.h2.command.Command.executeQuery(Command.java:132)
at
org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:172)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
at org.h2.tools.Script.processScript(Script.java:112)
at org.h2.tools.Script.runTool(Script.java:98)
at org.h2.tools.Script.main(Script.java:50)
I can't delete the problem table rows either for the same reason.
Can I run backup scripts on each table seperately somehow and exclude
my "problem" table?
Cheers
Mat
On Aug 25, 10:05 am, UncleTupelo <[email protected]> wrote:
> Good Morning,
>
> I am getting various "rowCount expected " errors since I upgraded the
> h2 jar file from 1.2.121 to 1.2.141. I can connect to the db fine
> and most things still seem to work, but various inserts don't.
>
> If I run :
>
> select * from information_schema.settings where name = 'CREATE_BUILD';
>
> I get:
>
> NAME VALUE
> ------------ --------
> CREATE_BUILD 121
>
> Do I need to do some kinda upgrade here? It doesn't appear the file
> structure of h2 has altered between these versions so I didn't think I
> would have to.
>
> The java application stack trace look like:
>
> 09:10:17.491 [btpool0-7 ] WARN
> org.hibernate.util.JDBCExceptionReporter - SQL Error: 50000, SQLState:
> HY000
> 09:10:17.491 [btpool0-7 ] ERROR
> org.hibernate.util.JDBCExceptionReporter - General error:
> "java.lang.RuntimeException: rowCount expected 214 got 183
> LEDGER.LEDGER_IX1"; SQL statement:
> update "LEDGER" set VERSION=?, CLIENT_ID=?, REFERENCE=?, NAME=?,
> CURRENCY_CODE=?, SCHEDULE_TYPE=?, SCHEDULE_VALUE=?,
> EXPORT_DELIVERY_TYPE=?, LATEST_LEDGERUPDATE_ID=? where ID=? and
> VERSION=? [50000-141]
> GeminiCentral : 09:10:17.491 [btpool0-7 ]
> Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: could not update:
> [com.hpdsoftware.gemini.database.domain.Ledger#10]
>
> Any help appreciated.
>
> Cheers
>
> Mat
--
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.
