Index: topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java
diff -u topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.14 topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.15
--- topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java:1.14	Mon Aug  8 12:18:30 2005
+++ topia/src/java/org/codelutin/topia/persistence/PersistenceStorageJDBC.java	Mon Aug  8 14:00:16 2005
@@ -23,10 +23,10 @@
  * Created: 20 juillet 2005 15:25:06 CEST
  *
  * @author Benjamin POUSSIN <poussin@codelutin.com>
- * @version $Revision: 1.14 $
+ * @version $Revision: 1.15 $
  *
- * Last update: $Date: 2005/08/08 12:18:30 $
- * by : $Author: thimel $
+ * Last update: $Date: 2005/08/08 14:00:16 $
+ * by : $Author: dessard $
  */
 
 package org.codelutin.topia.persistence;
@@ -202,7 +202,9 @@
         SQL_ORACLE.setProperty(SQL_CREATE_TABLE_MANAGEMENT,
         "CREATE TABLE management (id varchar(100), longdate number(21), class varchar(255), isNew number(1), isDeleted number(1), schemaVersion number(21), constraint management_pk PRIMARY KEY (id, longdate))");
         SQL_ORACLE.put(SQL_CREATE_TABLE_DATA,
-        "CREATE TABLE data (id varchar(100), longdate number(21), field varchar(100), val blob, type varchar(255), constraint data_pk PRIMARY KEY (id, longdate, field))");
+        "CREATE TABLE data (id varchar(100), longdate number(21), field varchar(100), value blob, type varchar(255), constraint data_pk PRIMARY KEY (id, longdate, field))");
+        SQL_ORACLE.put(SQL_GET_ALL_ID,
+        		"SELECT DISTINCT(id) FROM management WHERE (longdate in (" + Util.SQL_IDS_KEY + ") OR (longdate>0 AND longdate<=?)) AND id NOT IN (SELECT id FROM management WHERE isDeleted=0 AND (longdate in (" + Util.SQL_IDS_KEY + ") OR (longdate>0 AND longdate<=?)))");
 
         SQL_DERBY.put(SQL_CREATE_TABLE_MANAGEMENT, "CREATE TABLE management (id VARCHAR(50), longdate bigint, class LONG VARCHAR, isNew integer, isDeleted integer, schemaVersion bigint, PRIMARY KEY (id, longdate))");
         SQL_DERBY.put(SQL_CREATE_TABLE_DATA, "CREATE TABLE data (longdate bigint, field varchar(100), value blob, type LONG VARCHAR, PRIMARY KEY (id, longdate, field))");