How do you create test? Is it definitely a table? (not a view?)
Can you provide a complete example? Cheers Kerry On Tue, Feb 16, 2010 at 9:04 AM, gabjos <[email protected]> wrote: > sorry i put the wrong error message here is the error: > > truncate table test > > Cannot truncate PUBLIC.test [90106-63] > org.h2.jdbc.JdbcSQLException: Cannot truncate PUBLIC.test [90106-63] > at org.h2.message.Message.getSQLException(Message.java:89) > at org.h2.message.Message.getSQLException(Message.java:93) > at org.h2.message.Message.getSQLException(Message.java:71) > at org.h2.command.ddl.TruncateTable.update(TruncateTable.java:30) > at org.h2.command.CommandContainer.update(CommandContainer.java: > 64) > at org.h2.command.Command.executeUpdate(Command.java:122) > at org.h2.server.TcpServerThread.process(TcpServerThread.java: > 241) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:97) > at java.lang.Thread.run(Unknown Source) > > at org.h2.engine.SessionRemote.done(SessionRemote.java:289) > at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java: > 164) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155) > at org.h2.server.web.WebThread.getResult(WebThread.java:1392) > at org.h2.server.web.WebThread.query(WebThread.java:1054) > at org.h2.server.web.WebThread.process(WebThread.java:375) > at org.h2.server.web.WebThread.processRequest(WebThread.java:131) > at org.h2.server.web.WebThread.run(WebThread.java:158) > > On Feb 15, 2:49 pm, Thomas Mueller <[email protected]> > wrote: > > Hi, > > > > > That is exactly what I type > > No, you wrote: > > > > TRUNCATE TABLE FROM test > > not > > TRUNCATE TABLE test > > > > By the way, consider upgrading to a more recent version of H2. You are > > using version 1.0.63. > > > > Regards, > > Thomas > > -- > 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]<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.
