Have you double checked if the case of the table name is having any affect on this? In the descriptor you have the table name as 'PERSON' but in your create statement it is 'person'.
It is a while since I have used Hypersonic but this is the first thing that jumps out at me from your post.
Thank you for your suggestion. I tried making everything the same case unfortunately it made no difference. :-((
I solved this problem so thought I'd round off in case anyone ever has the same issue.
In the hypersonic documentation, it states that you need to create a table with the text attribute in order to make it persistant and not a memory-only table:
create [B]text[/B] table person
pid varchar not null primary key,
However, this seems to cause Jboss to not recognize the table. Removing the 'text' solved the problem. So either the documentation is incorrect (or I dont understand it) or Jboss does something under the covers to make the table permanent when accessing it.