tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: JDBC Fails to connect to SQL Server
Date Mon, 02 Feb 2015 15:12:16 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Aniket,

On 2/2/15 3:09 AM, Aniket Bhoi wrote:
> On Fri, Jan 30, 2015 at 10:37 PM, Christopher Schultz < 
> chris@christopherschultz.net> wrote:
> 
>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
>> 
>> Aniket,
>> 
>> On 1/30/15 10:01 AM, Aniket Bhoi wrote:
>>> I have Apache Solr hosted on Tomcat 6.
>>> 
>>> There have been no changes to the code on Tomcat
>>> whatsoever.However for the last few days I now see this error
>>> in the Log files:
>>> 
>>> SEVERE: Full Import failed Throwable occurred: 
>>> org.apache.solr.handler.dataimport.DataImportHandlerException: 
>>> Unable to execute query: SELECT ID, ENTRY_TYPE_REF,
>>> PROFILE_REF, ITEM_REF, TITLE, ABSTRACT, SOLUTION,
>>> SOLUTION_HTML, FREE_TEXT, DATE_UPDATED, ENTRY_TYPE,
>>> PROFILE_TYPE, SERVICE_TYPE FROM INFRA_KO_V Processing Document
>>> # 1
>>> 
>>> [snip]
>>> 
>>> *Caused by: com.microsoft.sqlserver.jdbc.SQLServerException:
>>> The driver could not establish a secure connection to SQL
>>> Server by using Secure Sockets Layer (SSL) encryption. Error:
>>> "SQL Server did not return a response. The connection has been
>>> closed.".* at
>>> 
>> com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
>>>
>>>
>>
>> 
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1412)
>> 
>> 
>> What does your <Resource> definition look like in either
>> server.xml or (better) context.xml?
>> 
>> - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment:
>> GPGTools - http://gpgtools.org
> 
> 
> 
> Thanks Jeff,
> 
> Let me check if there has been any such problem.
> 
> Hi Chris,
> 
> I do not have the resource configured in either context.xml or in 
> server.xml,its in Solr's data-config.xml,its picked up from there
> during data import.
> 
> <dataSource type="JdbcDataSource" 
> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
> url="jdbc:sqlserver://xxx-xxx:1433;databaseName=xxx" user="xxx" 
> password="xxx"/>

Then this has nothing to do with Tomcat: you are using Solr's
configuration with Microsoft's JDBC driver. You might get some help
here due to the general nature of connection pools, firewalls, etc.,
but this isn't a Tomcat problem.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: GPGTools - http://gpgtools.org

iQIcBAEBCAAGBQJUz5PQAAoJEBzwKT+lPKRYd4UP/2Vajfe7n8bFGGWsIDTC0J5O
8o+xgf5Hfcp8oPVYcV0vXy1M1Ugb5cBSvDBOHpkCvCShR9wJXXyh/KFjA9amiM7A
D3Fn/LSumTDkjM/U/rOmiPBQfe5p+EBeDh8xEK7DV0O55cvJ2cgKWuNiRpU6uQ3a
elAxnPOyl4Ekv/pzrykFnKMsqQbzAyO7j+4EDwfAD9//bpM0QWeUHJwyA3h/r4aE
5zfasvfwa/ZnKx5teQeUy9bpYmIFwPshS+VH85Gc+D8x4yQ+Oq8U1cp9H3tKctDo
HBUqs/Of7UsqqWD8Jvkl3t/T7QZgJLbx56f6VCCykUYBerivpSI9oK/MZFtlK6Nv
TQPMs5u6TnDfFRLoogRER6C+xIJWXmJukb2WpoyDkhVZWEwnzvGnVyarXP7TNa9m
C0Wm/2xozTkziDWpkS1oJ1/nT4zWTqX6uR8415leQ0mU4V9g1gQUouap7Ja1WrRN
0FArAC+XcT3estl/nIIAT9P3zHVYq2TKs9FNMTJBCaHCfxu4SV/ZaZzJOEZiTe0d
wnTXIu4Vw6cdGGjpZjQPP3sDrCAX6pvukQX6IwOLmhjr0Kvo/OUoZslQdSLt48nL
r26yEA+7iLybqZvJ3SDB8XnpnQyvcuJXmpfQjqqy1blEKfXGhsaItdWP+5/ZBxDH
MUr2jmJ2WajRD+EhmROo
=yyhZ
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message