Add Read_ONLY option to DB connection string

[RICK L. PRITCHETT]

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?

Topic

[Arie Klop]

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, 4 months ago by Arie Klop. Reason: jdbc url not fully visible
• This reply was modified 1 year, 4 months ago by Arie Klop.
• This reply was modified 1 year, 4 months ago by Arie Klop.
• This reply was modified 1 year, 4 months ago by Arie Klop.

[Arie Klop]

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

[RICK L. PRITCHETT]

So in the URL format for the Database URL under the “Edit Database Connection”?

jdbc:sqlserver://<server>:<port1433>;DatabaseName=<database>;???????

[Author]

Replies