Does derby support still work?

Graham Leggett <[email protected]>
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]>
Hi all,

I have been trying to create a table generation script for derby using 
the maven torque:sql goal, but the script produced doesn't seem to be 
valid derby syntax.

Double checking within velocity.log, I see that the derby templates are 
being used to create the database file. However, if I attempt to 
manually run the create database script lines manually against a derby 
database, I get a syntax error as follows:

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.

Is derby still supported by torque v3.3?

Regards,
Graham
--
smime.p7s (application/x-pkcs7-signature, 3.2 KB) - not displayed
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.