On 3/14/2016 2:31 AM, Adi@GTN wrote:
> Am using the below config details in order to connect the database, and pull
> the query but in the connection details it is mentioned as
> authenticateMethod=ntlm, am bit confused here am not sure what is this
> authentication method, now am not able to connect the database so am not
> able to debug and understand what is the username it is being used in-order
> to connect the database. Can anyone help me understanding and give some
> inputs on how to debug.
>
> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> url="jdbc:sqlserver://localhost;databaseName=testdb;integratedSecurity=true;responseBuffering=adaptive;selectMethod=direct;;authenticationMethod=ntlm;"
> batchsize="1" readnonly="true"/>
I'm not an expert on SQL Server, and honestly I hope that I never am.
>From what I have been able to determine with Google, the
integratedSecurity option (which you have) should pull the credentials
from the user on the Windows machine that is running Solr. Note that if
you figure out how to install Solr as a service and use the System or
Network user to run it, this probably is NOT going to do what you want.
You might need to remove the authenticationMethod parameter entirely,
and if that doesn't work, you're going to need to consult Microsoft
about how to properly use their JDBC driver. You also might want to
consult the logs from SQL Server to determine what credentials it is
seeing, as well as the Solr server log to see whether any errors are
logged there.
Note that you have mistyped the batchSize and readOnly parameters.
These parameter names are case sensitive and readOnly is misspelled.
You should probably remove the batchsize parameter entirely, and fix
readOnly. The problem that most people are trying to avoid with
batchSize is controlled in a different way:
http://wiki.apache.org/solr/DataImportHandlerFaq#I.27m_using_DataImportHandler_with_MS_SQL_Server_database_with_sqljdbc_driver._DataImportHandler_is_going_out_of_memory._I_tried_adjustng_the_batchSize_values_but_they_don.27t_seem_to_make_any_difference._How_do_I_fix_this.3F
Thanks,
Shawn
