[Sqlshell-svn] /devel/src/main/java/nl/improved/sqlclient

[SVN by r. <sv...@ca...>]

Author: roy
Date: 2008-07-23 22:57:12 +0200 (Wed, 23 Jul 2008)
New Revision: 268

Modified:
   src/main/java/nl/improved/sqlclient/AbstractSQLShellWindow.java
Log:
fix error in read.. not reading first row everytime


Modified: src/main/java/nl/improved/sqlclient/AbstractSQLShellWindow.java
===================================================================
--- src/main/java/nl/improved/sqlclient/AbstractSQLShellWindow.java	2008-07-23 10:25:10 UTC (rev 267)
+++ src/main/java/nl/improved/sqlclient/AbstractSQLShellWindow.java	2008-07-23 20:57:12 UTC (rev 268)
@@ -1434,7 +1434,7 @@
                 PreparedStatement pstmt = c.prepareStatement(query);
                 SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMddHHmmss");
                 for (int nodeNr = 0; nodeNr < nodeList.getLength(); nodeNr++) {
-                    Element row = (Element) nodeList.item(0); // row
+                    Element row = (Element) nodeList.item(nodeNr); // row
                     NodeList columns = row.getElementsByTagName("col");
                     for (int colNr = 0; colNr < columns.getLength(); colNr++) {
                         Element column = (Element) columns.item(colNr);
@@ -1447,6 +1447,7 @@
                                 pstmt.setDate(colNr+1, new Date(formatter.parse(nodeValue).getTime()));
                             }
                         } else {
+                            //debug(nodeNr +" ? "+column.getTextContent());
                             pstmt.setString(colNr+1, column.getTextContent());
                         }
                     }