[Middlegen-user] more on deploying airline sample in JBoss

[k***@keysolutions.com]

Finally figured out how to deploy a Hypersonic database on JBoss.
1. copy hsqldb-service.xml to hsqldb-airline-service.xml in
jboss\server\default\deploy
2. edit hsqldb-airline-service.xml
3. remove the last mbean or you'll get a duplicate mbean error when it
deploys
4. rename hsqldbDS to "airline.database" to make it work like the
Weblogic sample
5. change the jndiname tag value from DefaultDS to "airline.database"
6. copy the hsqldb.jar from JBoss into the Middlegen samples\lib
directory because
the Middlegen hsqldb.jar file is ancient and incompatible w/ JBoss'
included
Hypersonic jar (I'll file a bug report as well). You'd think
Hypersonic would be backwards
compatible but the JBoss Hypersonic can't read the Middlegen
Hypersonic's
database.
7. modify build.xml in middlegen\sample to run DatabaseManager instead
of
DatabaseManagerSwing (the latest Hypersonic version doesn't have Swing
version
that works)

Agghhh. Middlegen isn't compatible w/ the 1.6.1 version of Hypersonic
that
comes with JBoss (latest 3.04 w/ apache). Middlegen can't find any
primary/foreign
key relationships.

The latest version of Hypersonic is 1.7.1. Downloaded it and placed
it in the
appropriate Middlegen and JBoss directories. Looks like the
Hypersonic folks
didn't include some icons so the Swing version of the DB manager
doesn't run.
Middlegen builds and deploys, but then Jboss can't find some entities
when you
hit the overview page:
17:01:40,546 ERROR [Engine] ActionServlet: Can't find entity
javax.ejb.FinderException: Unknown query: public abstract
java.util.Collection airline.interfaces.ReservationLocalHome.findAll()
throws javax.ejb.FinderException at
org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.getQueryCommand(JDBCQueryManager.java:56)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:38)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:549)


Has anyone gotten middlegen to work w/ the latest Hypersonic and
JBoss? I'm
running the latest middlegen from CVS.


ken