lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jienan Duan <jnd...@gmail.com>
Subject Re: MySQL Exception: Communications link failure WITH DataImportHandler
Date Thu, 16 Aug 2012 08:37:31 GMT
Hi all:
I have resolved this problem by configuring a jndi datasource in tomcat.
But I still want to find out why it throw an exception in DIH when I
configure datasource in data-configure.xml but a jndi resource.

Regards.

2012/8/16 Jienan Duan <jnduan@gmail.com>

> Hi all:
> I'm using DataImportHandler load data from MySQL.
> It works fine on my develop machine and online environment.
> But I got an exception on test environment:
>
>> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
>>> Communications link failure
>>
>>
>>> The last packet sent successfully to the server was 0 milliseconds ago.
>>> The driver has not received any packets from the server.
>>
>>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>
>>         at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>
>>         at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>
>>         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>
>>         at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
>>
>>         at
>>> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
>>
>>         at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
>>
>>         at
>>> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2132)
>>
>>         ... 26 more
>>
>> Caused by: java.net.ConnectException: Connection timed out
>>
>>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>>
>>         at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
>>
>>         at
>>> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
>>
>>         at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
>>
>>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
>>
>>         at java.net.Socket.connect(Socket.java:529)
>>
>>         at java.net.Socket.connect(Socket.java:478)
>>
>>         at java.net.Socket.<init>(Socket.java:375)
>>
>>         at java.net.Socket.<init>(Socket.java:218)
>>
>>         at
>>> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
>>
>>         at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
>>
>>         ... 27 more
>>
>> This make me confused,because the test env and online env almost
> same:Tomcat runs on a Linux Server with JDK6,MySql5 runs on another.
> Even I wrote a simple JDBC test class it works,a jsp file with JDBC code
> also works.Only DataImportHandler failed.
> I'm trying to read Solr source code and found that it seems Solr has it's
> own ClassLoader.I'm not sure if it goes wrong with Tomcat on some specific
> configuration.
> Dose anyone know how to fix this problem? Thank you very much.
>
> Best Regards.
>
> Jienan Duan
>
> --
> ------------------------------------------------------
> 不走弯路,就是捷径。
> http://www.jnan.org/
>
>


-- 
------------------------------------------------------
不走弯路,就是捷径。
http://www.jnan.org/

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message