db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vandahl ...@apache.org>
Subject Re: Does derby support still work?
Date Sat, 23 Aug 2008 15:23:45 GMT
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.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message