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/
