Sorry if this has been answered but i am not able to find it. I am trying
to export just one table using the Script Utility. The command i am using
is
java -cp "h2-1.2.147.jar" org.h2.tools.Script -url jdbc:h2:sample5 -user
default_user -password default_password -options table
'dailyshiftcatgorysales'
The error i get is
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Syntax error in
SQL statement "SCRIPT TO 'backup.sql' TABLE[*] 'dailyshiftcatgorysales'
"; SQL statement:
SCRIPT TO 'backup.sql' table 'dailyshiftcatgorysales' [42000-147]
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.message.DbException.getSyntaxError(DbException.java:179)
at org.h2.command.Parser.getSyntaxError(Parser.java:480)
at org.h2.command.Parser.prepareCommand(Parser.java:229)
at org.h2.engine.Session.prepareLocal(Session.java:425)
at org.h2.engine.Session.prepareCommand(Session.java:374)
at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1056)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:165)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:153)
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 have no clue to what i am doing wrong.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
