In my code, during the multiple calls to Updater.performCurrentUpdate(), I get a warning message about FindAllRings.startRingSearch() written to the console - see below for console output and code.
Is this warning something to worry about, does this affect the integrity of the updated chemistry table. Will some required data be missing from the new chemistry database or can I trust the message "Tables have been recalculated successfully."
...
...
...
...
WARNING: Timeout reached in ringsearch.
WARNING: Timeout reached in ringsearch.
package toyJChem;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import chemaxon.jchem.db.Updater;
import chemaxon.util.ConnectionHandler;
public class JChemDemo_upgrade
{
private static Connection connection;
private static ConnectionHandler conn_handler;
/**
* Test that JChem tables are automatically updated correctly when moving from version 5.2.6/5.4.1.1 to 5.6.0.3
*
* @param args
* @throws Exception
*/
public static void main (String[] args) throws Exception
{
init();
try
{
System.out.println("=======Start upgrade==============");
String message = "";
Updater ud = new Updater( conn_handler );
Updater.UpdateInfo ui = null;
ui = ud.getNextUpdateInfo();
while (ui != null)
{
System.out.println ("");
System.out.println("========================");
System.out.println("Update:before");
System.out.println (ui.message);
checkpointDatabase();
message = ud.performCurrentUpdate();
System.out.println("Update:result = " + message);
System.out.println("========================");
System.out.println ("");
ui = ud.getNextUpdateInfo();
}
shutdownDatabase();
}
catch (SQLException sqle)
{
System.out.println("Problem updating : " );
System.out.println("toString() = : " + sqle);
sqle.printStackTrace();
}
}
private static void init() throws Exception
{
connection = ConnectionFactory.getConnection();
conn_handler = ConnectionFactory.getHandler();
}
public static void checkpointDatabase() throws SQLException
{
Statement s = connection.createStatement();
s.execute("CHECKPOINT");
s.close();
}
public static void shutdownDatabase() throws SQLException
{
Statement s = connection.createStatement();
s.execute("SHUTDOWN");
s.close();
}
}