dbLink « Oracle « JPA Q&A

  1. JPA Q&A
  2. Oracle
  3. dbLink




1. Hibernate with Oracle dbLink    forum.hibernate.org

Since you can use database objects over Oracle database links with jdbc, and Hibernate just generates jdbc, there shouldn't be a problem. I haven't tried it, so I don't know if Hibernate would choke on the @ string when specifying the database table for a class. You could get around this by setting up a synonym in the database to hide ...

2. Oracle DBLink    forum.hibernate.org

Thank you Steve! My DBA is not willing to go the SYNONYM approach, since there will be too many objects to maintain. If we still have other syntex issues, I will try to push this approach again. My second question from last email, if DBlink is totally transparent, then session/transaction (2PC maybe)/RI for the two data sources can be handled by ...

3. ORA-12705-error when using dbLink in Oracle    forum.hibernate.org

Newbie Joined: Thu Jan 12, 2006 8:31 am Posts: 4 Can anybody help me with the following problem: We have an oracle database called DWS with a dblink to another oracle database DCP. We don't have any problem reading data from the DWS-database, but reading from DCP doesn't work. We always get the following error: java.sql.SQLException: ORA-12705: invalid or unknown NLS ...