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

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

Author: roy
Date: 2009-12-16 11:12:50 +0100 (Wed, 16 Dec 2009)
New Revision: 438

Modified:
   src/main/java/nl/improved/sqlclient/commands/DumpCommand.java
Log:
fix help
small other fixes in error handling


Modified: src/main/java/nl/improved/sqlclient/commands/DumpCommand.java
===================================================================
--- src/main/java/nl/improved/sqlclient/commands/DumpCommand.java	2009-12-16 10:04:43 UTC (rev 437)
+++ src/main/java/nl/improved/sqlclient/commands/DumpCommand.java	2009-12-16 10:12:50 UTC (rev 438)
@@ -164,7 +164,7 @@
                 }
                 hd.endElement("", "", "row");
                 rowCount++;
-                if (rowCount % 1000 == 0) {
+                if (rowCount % 10000 == 0) {
                     output(Integer.toString(rowCount)+" rows written");
                 }
             }
@@ -172,7 +172,7 @@
             hd.endDocument();
 
         } catch (SAXException ex) {
-            Logger.getLogger(AbstractSQLShellWindow.class.getName()).log(Level.SEVERE, null, ex);
+            throw new IllegalStateException("Failed to create dump (" + fileName + "): " + ex.toString(), ex);
         } catch (TransformerConfigurationException e) {
             throw new IllegalStateException("Failed to create xml handler: " + e.toString(), e);
         } catch (SQLException e) {
@@ -212,7 +212,7 @@
 
     @Override
     public CharSequence getHelp() {
-        return "tablename [where clause]\n" + "For example: dump users where role=\'manager\';\n\n" + "See \'read\' for options to read the dump file back into the table";
+        return "[as filename] tablename [where clause]\n" + "For example: dump users where role=\'manager\';\n\n" + "See \'read\' for options to read the dump file back into the table";
     }
 
     @Override