Author: [log in to unmask]
Date: Tue Apr 21 17:27:51 2015
New Revision: 2778
Log:
Use SQL function to get created value.
Modified:
java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseConditionsManager.java
Modified: java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseConditionsManager.java
=============================================================================
--- java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseConditionsManager.java (original)
+++ java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseConditionsManager.java Tue Apr 21 17:27:51 2015
@@ -296,7 +296,7 @@
int collectionId = -1;
try {
statement = this.connection.prepareStatement(
- "INSERT INTO collections (table_name, log, description, created) VALUES (?, ?, ?, ?)",
+ "INSERT INTO collections (table_name, log, description, created) VALUES (?, ?, ?, NOW())",
Statement.RETURN_GENERATED_KEYS);
statement.setString(1, tableName);
if (log == null) {
@@ -309,7 +309,6 @@
} else {
statement.setString(3, description);
}
- statement.setDate(4, new java.sql.Date(Calendar.getInstance().getTime().getTime()));
statement.execute();
resultSet = statement.getGeneratedKeys();
resultSet.next();
|