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.

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to