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
