I need to execute the below commands though mysql scheduler to refresh the full-text indexes in a table –
ALTER TABLE some_table DROP INDEX full_text;
ALTER TABLE some_table ADD FULLTEXT INDEX full_text (description) VISIBLE;
But this locks down the table which does not quite fails the tomcat 9.0 connection pooling but the entire http requests fails across all the web projects deployed. I can see in the tomcat logs the background queries to the connection pool works just fine.
I have to restart the tomcat server after which everything works fine.
the connection pool string –
<Resource name="myDatasource" auth="Container" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000" username="username" password="password"
driverClassName="com.mysql.cj.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mydb?useOldAliasMetadataBehavior=true"/>
I have another simple mysql connection below which never fails although –
if(con1 == null || con1.isClosed()) {
Class.forName("com.mysql.cj.jdbc.Driver");
con1=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","username","password");
}
You need to sign in to view this answers
Leave feedback about this