java - Table missing error while maaping MySQL view to hibernate -
i trying map mysql view hibernate. when getting , table missing error while starting application. view create algorithm = undefined definer = `mydbadmin`@`%` sql security definer view `reservation_transaction_view` select convert( concat(`apst`.`tid`, _utf8'-', `apst`.`roomindex`, _utf8'-', `apst`.`rid`) using utf8) `id`, `apst`.`tid` `transactionid`, `apst`.`roomindex` `room no`, `apst`.`pid` `paymentid`, `apst`.`rid` `reservationid` `agent_payment_sub_transaction` `apst` (`apst`.`rid` <> 0) group `apst`.`tid` , `apst`.`roomindex` the mapping <?xml version="1.0"?> <hibernate-mapping> <class name="com.abc.def.entity.reservationtransactionview" table="reservation_transaction_view" catalog="abcd"> <id name="id" type="string" /> <property name="transactionid" type="java.la...