Re: Does derby support still work?

Thomas Vandahl <[email protected]>
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]>
Graham Leggett wrote:
> ij> CREATE TABLE property ( property_id INTEGER NOT NULL, key VARCHAR 
> NOT NULL, value VARCHAR, PRIMARY KEY(property_id));
> ERROR 42X01: Syntax error: Encountered "key" at line 1, column 55.

What this tells you is that a column name "key" is not valid in Derby. 
You should choose another name. Although you might succeed creating a 
valid SQL file by patching some templates, Village will barf at you when 
you want to insert something.

> Is derby still supported by torque v3.3?

It sure is.

Bye, Thomas.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.