Auto-increment / jboss 3.2.1 / Hypersonic

[webguy]

Hi, I'm just messing about with the Jboss-ejb-workbook from O'reilly, and I'm changing one of the entitybeans to use a auto-increment, with the Hypersonic SQL database.

I've added the <auto-increment/> and

<!-- retrieves generated key of the record inserted into hsql db -->
<entity-command name="hsqldb-fetch-key"
class="org.jboss.ejb.plugins.cmp.jdbc.hsqldb.JDBCHsqldbCreateCommand"/>

to the jbosscmp-jdbc.xml

I'm getting the error "Template not found" in the console when I deploy it to Jboss.

I'm guessing I'm missing a jar in the servers/default/lib?
That right? What one?

2 more questions on key generation. Is there a classes with Jboss that I can use to do

a)HIGH-LOW
b)GUID/UUID

I'm guessing uuid-key-generator.sar has something to do with that..

Also if I want to plugin a custom class that does generation, what do I need to do?

Thanks WG

[webguy]

Ok here is an update. It seems you need to overwrite the defult Hypersonic settings adding the pk-template .

In addition the XML declaration for the DTD (jboss-jdbc 3.2) need to be commented out as the it doesn't include the pk entity and will cause deployment to fail, with a XML Validation error.

You can just use <entity-command name="hsqldb-fetch-key"/> in place of the longer declaration as above..