title: Create table syntax not working in hsql
body: <p>I am new to hsqldb. I am developing simple application to get the some input from user. So Searched for embedded database and found hsqldb is the solution for my requirement.</p>
  
  <p>I have some create table syntax but it throws exception.</p>
  
  <p>(This Query executed by using Netbeans Database services)</p>
  
  <p>Query :</p>
  
  <pre><code>CREATE TABLE  company (
    comp_name varchar(100) NOT NULL,
    comp_id int(40) NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (comp_id)
  );
  </code></pre>
  
  <p>or </p>
  
  <pre><code>CREATE TABLE  company (
    comp_name varchar(100) NOT NULL,
    comp_id int(40) NOT NULL IDENTITY
  );
  </code></pre>
  
  <p>hsql db throws the error :</p>
  
  <pre><code>Error code -5581, SQL state 42581: unexpected token: ( : line: 3
  Line 2, column 1
  
  Execution finished after 0 s, 1 error(s) occurred.
  </code></pre>
  
  <p>Kindly help me out..</p>
  
  <p>Thanks in Advance..</p>
  
  <p>Cheers...!</p>