Add Read_ONLY option to DB connection string

This topic has 3 replies, 2 voices, and was last updated 1 year, 1 month ago by RICK L. PRITCHETT.

Creator

Topic
August 9, 2023 at 11:38 am #120723

RICK L. PRITCHETT
Participant

I am needing to specify to connect to our ready-only DB node. Has anyone else had to do this and can you share the how-to if so?
Creator

Topic

Viewing 1 reply thread

Author

Replies
- August 10, 2023 at 2:15 am #120725
  Arie Klop
  Participant
  If you mean the sql server (secondary) readonly node, you can use ‘ApplicationIntent=ReadOnly’ in your db connection.
  
  Like so:
  jdbc:sqlserver://SQLservername:1433;DatabaseName=DB;ApplicationIntent=ReadOnly;
  
  I only used this in a Java UPOC, but it should work in your regular JDBC thread as well.
  - This reply was modified 1 year, 1 month ago by Arie Klop. Reason: jdbc url not fully visible
  - This reply was modified 1 year, 1 month ago by Arie Klop.
  - This reply was modified 1 year, 1 month ago by Arie Klop.
  - This reply was modified 1 year, 1 month ago by Arie Klop.
  - August 10, 2023 at 2:27 am #120730
    
    Arie Klop
    Participant
    
    because wordpress won’t show the full url, here its pasted broken up by the semicolon:
    
    jdbc:sqlserver://SQLservername:1433;
    DatabaseName=DB;
    ApplicationIntent=ReadOnly;
    
    This should be one single string without line breaks when you fill it in in Cloverleaf
- August 10, 2023 at 12:33 pm #120732
  
  RICK L. PRITCHETT
  Participant
  
  So in the URL format for the Database URL under the “Edit Database Connection”?
  
  jdbc:sqlserver://<server>:<port1433>;DatabaseName=<database>;???????
Author

Replies

Viewing 1 reply thread

You must be logged in to reply to this topic.