I am using Castor with Hypersonic. Castor expects the Tables to be created outside the scope of the appServer. Otherwise queries will fail odviuosly. I know how to do this with Oracle but not with Hypersonic? [Default] Nested error: java.sql.SQLException: Table not found: ROOM in statement [SELECT Room.name,Room.description,Occu pant.name FROM Room LEFT OUTER JOIN Occupant ON (Room.name=Occupant.name)] while executing SELECT Room.name,Room.descrip tion,Occupant.name FROM Room LEFT OUTER JOIN Occupant ON (Room.name=Occupant.name) [Default] java.sql.SQLException: Table not found: ROOM in statement [SELECT Room.name,Room.description,Occupant.name FROM Room LEFT OUTER JOIN Occupant ON (Room.name=Occupant.name)] [Default] at org.hsql.Trace.getError(Trace.java:124) Thanks, Paul. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user