1 files changed, 49 insertions, 0 deletions
diff --git a/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/db/IPreparedStatementCache.java b/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/db/IPreparedStatementCache.java
new file mode 100644
index 0000000000..978ac2b178
--- /dev/null
+++ b/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/db/IPreparedStatementCache.java
@@ -0,0 +1,49 @@
+/**
+ * Copyright (c) 2004 - 2009 Eike Stepper (Berlin, Germany) and others.
+ * All rights reserved. This program and the accompanying materials
+ * are made available under the terms of the Eclipse Public License v1.0
+ * which accompanies this distribution, and is available at
+ * http://www.eclipse.org/legal/epl-v10.html
+ *
+ * Contributors:
+ *    Eike Stepper - initial API and implementation
+ *    Stefan Winkler - 271444: [DB] Multiple refactorings https://bugs.eclipse.org/bugs/show_bug.cgi?id=271444
+ */
+package org.eclipse.emf.cdo.server.db;
+
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+
+/**
+ * @noextend This interface is not intended to be extended by clients.
+ * @noimplement This interface is not intended to be implemented by clients.
+ * @author Stefan Winkler
+ * @since 2.0
+ */
+public interface IPreparedStatementCache
+{
+  public void setConnection(Connection connection);
+
+  public PreparedStatement getPreparedStatement(String sql, PSReuseProbability reuseProbability);
+
+  public void releasePreparedStatement(PreparedStatement ps);
+
+  /**
+   * An enum for the degree of probability to which a prepared statement is reused later on. This is used for managing
+   * the cache of prepared statements so that statements which are more likely reused are kept in the cache longer. Rule
+   * of thumb:
+   * <ul>
+   * <li>For global statements which are used regularly (such as lookup object in cdo_objects) use {@value #MAX}.
+   * <li>For constant object-specific statements which are used regularly use {@value #HIGH}.
+   * <li>For object-specific statements which are assembled from constants which are used regularly use {@value #MEDIUM}.
+   * <li>For all other dynamic statements, like queries, use {@value #LOW}
+   * </ul>
+   * 
+   * @author Stefan Winkler
+   * @since 2.0
+   */
+  public static enum PSReuseProbability
+  {
+    MAX, HIGH, MEDIUM, LOW;
+  }
+}