[
https://issues.apache.org/jira/browse/SOLR-8064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shawn Heisey closed SOLR-8064.
------------------------------
Resolution: Invalid
The way you have specified ApplicationIntent is an XML attribute. In order for
that to work, the Solr dataimport handler code would need to have explicit
support for that attribute. That's not going to happen -- the setting is only
applicable to the Microsoft JDBC driver. Because it's not a generic JDBC
setting applicable to all drivers, Solr has no support for it. All
driver-specific parameters can be specified on the connection URL -- full
flexibility is preserved even though Solr doesn't recognize those parameters.
Attributes like url, user, and password are applicable to a wide range of JDBC
drivers, so they have first-class support in the dataimport handler config.
If you change the "url" attribute so that it includes the connection parameter
like [~shalinmangar] mentioned, I believe you will get the behavior you are
after. I found this information using a simple Internet search:
{noformat}
url="jdbc:sqlserver://server;databaseName=TestDatabase;applicationIntent=ReadOnly"
{noformat}
As Shalin said, this is a question for the mailing list first. This issue
tracker is for confirmed bugs and feature requests. Your situation is not a
bug, it is a usability question, and actually has nothing at all to do with
Solr -- it's a setting on the Microsoft JDBC driver. Whenever you have
something you believe is a bug or want to make a feature request, you should
ask the mailing list first, to make sure it's really a bug or that the feature
you are wanting cannot be accomplished in another way.
> Solr Data Import handler with ApplicationIntent=ReadOnly
> --------------------------------------------------------
>
> Key: SOLR-8064
> URL: https://issues.apache.org/jira/browse/SOLR-8064
> Project: Solr
> Issue Type: Improvement
> Components: contrib - DataImportHandler
> Affects Versions: 5.0
> Reporter: Aniket Khare
> Priority: Blocker
> Labels: easyfix
>
> I am trying to use dataImportHandler with following connection string where I
> have added paramter as ApplicationIntent=ReadWrite which will automatically
> redirect the SQL connection to ReadOnly node.
> <dataSource type="JdbcDataSource"
> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> url="jdbc:sqlserver://server;databaseName=TestDatabase"
> ApplicationIntent="Readonly"
> user="Username"
> password="Password"/>
> I guess the DataImportHandler does not support this feature yet and because
> of that I am blocked for the Production push.
> Could you please help?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
