- String com1 = "INSERT INTO ProteinLog " + "(JobID, IP, DataBegin, DataEnd, FinalStatus, ExecutionStatus, Protein)"
- + " VALUES ('" + id + "','" + ip + "','" + job.getStartingTimeStr() + "','" + job.getEndTimeStr() + "','" + finalstatus
- + "','" + execstatus + "','" + protein + "');";
- session.execute(com1);
- if (execstatus.equals("OK")) {
- String com2 = "INSERT INTO ProteinData " + "(jobtime, JobID, ExecTime, Protein)" + " VALUES (" + job.getStartingDate() + ",'" + id
- + "'," + job.getExecutionTime() + ",'" + protein + "');";
- session.execute(com2);
-
+ String ProgramName = job.getProgramName();
+ String ProgramVersion = job.getProgramVersion();
+
+ String com1 = "INSERT INTO ProteinLog (JobID, IP, DataBegin, DataEnd, FinalStatus, ExecutionStatus, Protein, ProgramName, ProgramVersion) VALUES ('"
+ + id
+ + "','"
+ + job.getIP()
+ + "','"
+ + job.getStartingTimeStr()
+ + "','"
+ + job.getEndTimeStr()
+ + "','"
+ + finalstatus
+ + "','" + execstatus + "','" + protein + "','" + ProgramName + "','" + ProgramVersion + "');";
+ ResultSet insert = execute(com1);
+ if (null == insert) {
+ System.out.println("CassandraWriter.FormQueryTables: couldn't insert into ProteinLog");
+ // return 0;
+ }
+ if (finalstatus.equals("OK")) {
+ String com2 = "INSERT INTO ProteinData " + "(jobtime, JobID, ExecTime, Protein)" + " VALUES (" + job.getStartingDate()
+ + ",'" + id + "'," + job.getExecutionTime() + ",'" + protein + "');";
+ if (null == execute(com2)) {
+ System.out.println("CassandraWriter.FormQueryTables: couldn't insert into ProteinData");
+ // return 0;
+ }
+