CREATE TABLE Limited (Limit INTEGER);
When I try to create a table like this I get the following exception.
Naming the column "Limit" is not something that can be changed. This
seems like a silly reason to not be able to use H2, can someone
explain how to get around this problem. Thanks.
org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement
CREATE TABLE LIMITED (LIMIT[*] INTEGER);
; expected identifier; SQL statement:
CREATE TABLE Limited (Limit INTEGER);
[42001-79]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSyntaxError(Message.java:139)
at org.h2.command.Parser.readColumnIdentifier(Parser.java:2480)
at org.h2.command.Parser.parseCreateTable(Parser.java:4567)
at org.h2.command.Parser.parseCreate(Parser.java:3410)
at org.h2.command.Parser.parsePrepared(Parser.java:321)
at org.h2.command.Parser.parse(Parser.java:288)
at org.h2.command.Parser.parse(Parser.java:260)
at org.h2.command.Parser.prepareCommand(Parser.java:232)
at org.h2.engine.Session.prepareLocal(Session.java:285)
at org.h2.engine.Session.prepareCommand(Session.java:246)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1063)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
at groovy.sql.Sql.execute(Sql.java:804)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at org.codehaus.groovy.reflection.CachedMethod.invoke
(CachedMethod.java:86)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:230)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:912)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:756)
at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod
(InvokerHelper.java:766)
at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod
(InvokerHelper.java:754)
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN
(ScriptBytecodeAdapter.java:170)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
