Announcement Announcement Module
Collapse
No announcement yet.
Oracle RAC: JDBC Extensions with JPA? Oracle -scan config? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle RAC: JDBC Extensions with JPA? Oracle -scan config?

    Our team is trying to configure a connection to an Oracle 11g RAC database using Fast-Connect-Failover.

    1st question: We are currently configured to use JPA: EntityManagerFactory, PersistenceAnnotationBeanPostProcessor. In the Spring Data page under Relational Databases, I see that "JDBC Extensions" and "JPA" are separate. Is there a problem trying to use both?

    2nd question: Our DBA's have configured an Oracle RAC Service so that our connection URL does not call out the individual nodes. e.g.:
    Code:
    url=jdbc:oracle:thin:@dbrac11gdev-scan:1522/CAS11DEV_SRV.qualcomm.com
    That works fine for the connection url; however, we are unsure as to how to set ONS-configuration. Should it refer to the -scan service or do we need to determine the individual nodes? e.g.:
    Code:
    ONS-configuration="dbrac11gdev-scan:6150"
Working...
X