Jump to content
Changes to the Jaspersoft community edition download ×
  • RAC Cluster SCAN connection string - Owner vs User Schemas


    Jim W

    Issue Description

    We have a database that has an Owner and a User schema. We do not want the data source to connect to the owner for potential security reasons. In our testing environment we use a 2 node RAC cluster.  We are trying to access the database using the SCAN name so that the work will be divided among both nodes. When we try to create a Domain from the Data Source the user schema has access (SELECT, INSERT, UPDATE, DELETE) on the table but does not expand the table to show the fields. From SQL*Plus this user can view that table using: owner.table_name user.table_name table_name because a synonym exists for the user table. However, when creating a Domain connected to the user schema, none of the fields inside the table show up. If we connect to the owner schema it works and if we connect to a node directly instead of using the SCAN name we can use the user or owner schema.

    Resolution

    Use this connection string syntax

    jdbc:tibcosoftware:oracle://HOSTNAME:PORT;ServiceName=SERVICENAME.

    Ref. Case 00062361


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...