It happens immediately upon connection,the jdbc string is correct. This problem only happens when DIH trying get a connection to mysql,the network and database server are fine. So I guess it caused by some security configuration on the server and that config has blocked the connection. But other app's jdbc connection and Tomcat's JNDI datasource are insusceptible. PS: I use Solr 3.5
Regards. 2012/8/17 Gora Mohanty <g...@mimirtech.com> > On 16 August 2012 14:07, Jienan Duan <jnd...@gmail.com> wrote: > > 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. > [...] > > When does this error happen? Immediately upon connection, > or randomly at some point of time. If the former, double > check your mysql configuration string. > > With Solr 1.4, we occasionally saw DIH connection failures > to the database, but those were rare, probably attributable > to network issues, and largely went away when: > (a) We first moved to a different JDBC driver > (b) Moved from SQL server to mysql. > Is it possible that there are network issues between your live > Solr and the database server? Are you monitoring the load > on the database server, and the volume of network traffic? > > Regards, > Gora > -- ------------------------------------------------------ 不走弯路，就是捷径。 http://www.jnan.org/
