[Thaw-dev] r12217 - trunk/apps/Thaw/src/thaw/plugins/index

[jfle...@freenetproject.org]

Author: jflesch
Date: 2007-03-19 08:39:19 +0000 (Mon, 19 Mar 2007)
New Revision: 12217

Modified:
   trunk/apps/Thaw/src/thaw/plugins/index/DatabaseManager.java
   trunk/apps/Thaw/src/thaw/plugins/index/Index.java
Log:
Modify DatabaseManager.getNextId() implementation

Modified: trunk/apps/Thaw/src/thaw/plugins/index/DatabaseManager.java
===================================================================
--- trunk/apps/Thaw/src/thaw/plugins/index/DatabaseManager.java 2007-03-19 
07:53:09 UTC (rev 12216)
+++ trunk/apps/Thaw/src/thaw/plugins/index/DatabaseManager.java 2007-03-19 
08:39:19 UTC (rev 12217)
@@ -238,18 +238,16 @@
                }
        }

-
        public static int getNextId(Hsqldb db, String table) {
                        try {
                                PreparedStatement st;

-                               st = 
db.getConnection().prepareStatement("SELECT id FROM "+
-                                                                        
table+" ORDER BY id DESC "+
-                                                                        " 
LIMIT 1");
+                               st = 
db.getConnection().prepareStatement("SELECT IDENTITY()+1 FROM "+
+                                                                        table);
                                ResultSet res = st.executeQuery();

                                if (res.next())
-                                       return (res.getInt("id") + 1);
+                                       return res.getInt(1);
                                else
                                        return 1;


Modified: trunk/apps/Thaw/src/thaw/plugins/index/Index.java
===================================================================
--- trunk/apps/Thaw/src/thaw/plugins/index/Index.java   2007-03-19 07:53:09 UTC 
(rev 12216)
+++ trunk/apps/Thaw/src/thaw/plugins/index/Index.java   2007-03-19 08:39:19 UTC 
(rev 12217)
@@ -18,6 +18,7 @@
 import javax.swing.JOptionPane;
 import javax.swing.tree.MutableTreeNode;
 import javax.swing.tree.TreeNode;
+
 import javax.xml.parsers.DocumentBuilder;
 import javax.xml.parsers.DocumentBuilderFactory;
 import javax.xml.transform.OutputKeys;