Revision 6595
Added by ben leinfelder over 12 years ago
ReplicationServerList.java | ||
---|---|---|
30 | 30 |
import java.sql.PreparedStatement; |
31 | 31 |
import java.sql.ResultSet; |
32 | 32 |
import java.sql.SQLException; |
33 |
import java.sql.Timestamp; |
|
34 |
import java.util.Calendar; |
|
33 | 35 |
import java.util.Date; |
34 | 36 |
import java.util.Vector; |
35 | 37 |
|
... | ... | |
478 | 480 |
// Add this server to xml_table too |
479 | 481 |
try |
480 | 482 |
{ |
483 |
Calendar cal = Calendar.getInstance(); |
|
484 |
cal.set(1980, 1, 1); |
|
481 | 485 |
// Checkout DBConnection |
482 | 486 |
dbConn=DBConnectionPool. |
483 | 487 |
getDBConnection("ReplicationSErverList.addToServerListIfItIsNot"); |
... | ... | |
490 | 494 |
replicate +"', '"+dataReplicate+"','"+ hub + "')");*/ |
491 | 495 |
pStmt = dbConn.prepareStatement("INSERT INTO xml_replication " + |
492 | 496 |
"(server, last_checked, replicate, datareplicate, hub) "+ |
493 |
"VALUES ('" + givenServerName + "', "+ |
|
494 |
DatabaseService.getInstance().getDBAdapter().toDate("01/01/1980","MM/DD/YYYY") + ", '" + |
|
495 |
replicate +"', '"+dataReplicate+"','"+ hub + "')"); |
|
497 |
"VALUES (?, ?, ?, ?, ?, ?)"); |
|
498 |
pStmt.setString(1, givenServerName); |
|
499 |
pStmt.setTimestamp(2, new Timestamp(cal.getTimeInMillis()) ); |
|
500 |
pStmt.setInt(3, replicate); |
|
501 |
pStmt.setInt(4, dataReplicate); |
|
502 |
pStmt.setInt(5, hub); |
|
503 |
|
|
496 | 504 |
pStmt.execute(); |
497 | 505 |
|
498 | 506 |
pStmt.close(); |
Also available in: Unified diff
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5527