Mercurial > dive4elements > framework
diff artifact-database/src/main/java/de/intevation/artifactdatabase/h2/CollectionAccessUpdateTrigger.java @ 305:f33401ea2a6c
Artifact database: Refactorized the usage of dialect independent SQL to be reusable.
artifacts/trunk@2412 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 28 Jul 2011 10:19:35 +0000 |
| parents | 16cd059945e5 |
| children |
line wrap: on
line diff
--- a/artifact-database/src/main/java/de/intevation/artifactdatabase/h2/CollectionAccessUpdateTrigger.java Wed Jul 27 13:51:30 2011 +0000 +++ b/artifact-database/src/main/java/de/intevation/artifactdatabase/h2/CollectionAccessUpdateTrigger.java Thu Jul 28 10:19:35 2011 +0000 @@ -6,7 +6,9 @@ import java.sql.SQLException; import java.sql.PreparedStatement; -import de.intevation.artifactdatabase.SQL; +import de.intevation.artifactdatabase.DBConfig; + +import de.intevation.artifactdatabase.db.SQL; import org.apache.log4j.Logger; @@ -16,8 +18,7 @@ private static Logger logger = Logger.getLogger(CollectionAccessUpdateTrigger.class); - public static final String COLLECTIONS_TOUCH_TRIGGER_FUNCTION = - SQL.get("collections.touch.trigger.function"); + public String COLLECTIONS_TOUCH_TRIGGER_FUNCTION; public void init( Connection conn, @@ -29,6 +30,12 @@ ) throws SQLException { logger.debug("CollectionAccessUpdateTrigger.init"); + setupSQL(DBConfig.getInstance().getSQL()); + } + + protected void setupSQL(SQL sql) { + COLLECTIONS_TOUCH_TRIGGER_FUNCTION = + sql.get("collections.touch.trigger.function"); } public void fire(