1 files changed, 85 insertions, 0 deletions
diff --git a/offapi/com/sun/star/sdbc/TransactionIsolation.idl b/offapi/com/sun/star/sdbc/TransactionIsolation.idl
new file mode 100644
index 000000000000..426027be9a04
--- /dev/null
+++ b/offapi/com/sun/star/sdbc/TransactionIsolation.idl
@@ -0,0 +1,85 @@
+/*************************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2000, 2010 Oracle and/or its affiliates.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * This file is part of OpenOffice.org.
+ *
+ * OpenOffice.org is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License version 3
+ * only, as published by the Free Software Foundation.
+ *
+ * OpenOffice.org is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU Lesser General Public License version 3 for more details
+ * (a copy is included in the LICENSE file that accompanied this code).
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * version 3 along with OpenOffice.org.  If not, see
+ * <http://www.openoffice.org/license.html>
+ * for a copy of the LGPLv3 License.
+ *
+ ************************************************************************/
+#ifndef __com_sun_star_sdbc_TransactionIsolation_idl__
+#define __com_sun_star_sdbc_TransactionIsolation_idl__
+
+ module com {  module sun {  module star {  module sdbc {
+
+
+/** distinguishes different possible transaction isolation levels.
+ */
+published constants TransactionIsolation
+{
+
+    /** indicates that transactions are not supported.
+     */
+    const long NONE                 =  0;
+
+    /** Dirty reads, non-repeatable reads and phantom reads can occur.
+             This level allows a row changed by one transaction to be read
+             by another transaction before any changes in that row have been
+             committed (a "dirty read").  If any of the changes are rolled back,
+             the second transaction will have retrieved an invalid row.
+     */
+    const long READ_UNCOMMITTED     =  1;
+
+    /** Dirty reads are prevented; non-repeatable reads and phantom
+             reads can occur.  This level only prohibits a transaction
+             from reading a row with uncommitted changes in it.
+     */
+    const long READ_COMMITTED       =  2;
+
+    /** Dirty reads and non-repeatable reads are prevented; phantom
+             reads can occur.  This level prohibits a transaction from
+             reading a row with uncommitted changes in it, and it also
+             prohibits the situation where one transaction reads a row,
+             a second transaction alters the row, and the first transaction
+             rereads the row, getting different values the second time
+             (a "non-repeatable read").
+     */
+    const long REPEATABLE_READ      =  4;
+
+    /** Dirty reads, non-repeatable reads and phantom reads are prevented.
+             This level includes the prohibitions in
+             <code>REPEATABLE_READ</code>
+             and further prohibits the
+             situation where one transaction reads all rows that satisfy
+             a WHERE condition, a second transaction inserts a row that
+             satisfies that WHERE condition, and the first transaction
+             rereads for the same condition, retrieving the additional
+             "phantom" row in the second read.
+     */
+    const long SERIALIZABLE         =  8;
+};
+
+//=============================================================================
+
+}; }; }; };
+
+/*===========================================================================
+===========================================================================*/
+#endif