Hello

I use Hibernate and Spring. In the past I only worked with 1 database. Now I have to combine 2 databases, so I created a Database Link in Oracle, called 'LINK_CIB'.

When I execute the query "select * from entiteit@LINK_CIB" in Oracle SQL Developer, I get all the rows in the table entiteit.

I also want to use this link in my application, so I tried this:

getHibernateTemplate().findByNamedParam("from Entiteit@LINK_CIB where cibNr_ID=:cibNr_ID","cibNr_ID",cibNr_ID);

and the class Entiteit

@Entity
@Table(name="entiteit@LINK_CIB")
@Cache(usage=CacheConcurrencyStrategy.READ_ONLY)
public class Entiteit {
...
}

but I get the error unexpected char: '@' [from Entiteit@LINK_CIB where cibNr_ID=:cibNr_ID]

Can someone help me with this problem?
barbara

I think you should be using "from Entiteit where cibNr_ID=:cibNr_ID" instead of "from Entiteit@LINK_CIB where cibNr_ID=:cibNr_ID"

Try setting up a view onto the remote table instead.


--
Stephen Souness

Thanks Sounie!

I created the view Entiteit 'SELECT * FROM Entiteit@LINK_CIB' and referred in my code to Entiteit and it works!

barbara

Another option would be to create synonyms to the remote tables in the Oracle schema. e.g. CREATE SYNONYM ENTITEIT FOR ENTITEIT@LINK_CIB;