Java DB Application Netbeans

[DavidG24]

hey guys,

I am trying to create a basic Java DB application using netbeans and am using the Apache Derby Database so that I can easily embed the database into the application.

Anyways I have created a database, and am now trying to insert a few tables into it using the SQL command window,

I've tried the following
Create Table _AARDVARK ( Words varchar(200) not null , _AARDVARK numeric(4,2) not null , _ANIMAL numeric(4,2) not null , _ANT numeric(4,2) not null , _ANTEATER numeric(4,2) not null , _MUSIC numeric(4,2) not null , _NOSE numeric(4,2) not null , _UGLY numeric(4,2) not null , _DICTIONARY numeric(4,2) not null , _FUR numeric(4,2) not null , _SHELL numeric(4,2) not null , _ZOO numeric(4,2) not null , primary key (Words) ) ;



which generates the error :
Error code -1, SQL state 42X01: Syntax error: Encountered "_" at line 1, column 14.


I can't see what I'm doing wrong here in terms of the SQL (it works for a MySQL Database)
Any ideas ??

David

ps I'm using the built in driver
org.apache.derby.jdbc.ClientDriver

[r035198x]

Did you check in the Apache Derby manual to see if _ is allowed as first character of object names then?

[DavidG24]

<SOLVED>

....yeah that would be the intelligent thing to do

Feeling like an idiot,

Cheers,

David