sqlshell

Author: rotman
Date: 2007-09-28 14:54:41 +0200 (Fri, 28 Sep 2007)
New Revision: 155

Modified:
   README
Log:
add fix


Modified: README
===================================================================
--- README	2007-09-28 12:53:04 UTC (rev 154)
+++ README	2007-09-28 12:54:41 UTC (rev 155)
@@ -62,6 +62,7 @@
 
 0.3 (Unreleased)
 - focus fix in login dialog
+- fix to stop spooled lines being appended to each other.
 
 FUTURE
 - Improve desc table (to show primary key, references, etc)

Author: roy
Date: 2007-09-28 16:09:32 +0200 (Fri, 28 Sep 2007)
New Revision: 156

Modified:
   pom.xml
Log:
fixed reference to hsqldb jar


Modified: pom.xml
===================================================================
--- pom.xml	2007-09-28 12:54:41 UTC (rev 155)
+++ pom.xml	2007-09-28 14:09:32 UTC (rev 156)
@@ -43,7 +43,7 @@
     <dependency>
       <groupId>hsqldb</groupId>
       <artifactId>hsqldb</artifactId>
-      <version>1.8.0</version>
+      <version>1.8.0.7</version>
     </dependency>
     <dependency>
       <groupId>db</groupId>

Author: roy
Date: 2007-09-30 11:48:08 +0200 (Sun, 30 Sep 2007)
New Revision: 158

Modified:
   pom.xml
Log:
removed oracle dependancy


Modified: pom.xml
===================================================================
--- pom.xml	2007-09-30 09:47:31 UTC (rev 157)
+++ pom.xml	2007-09-30 09:48:08 UTC (rev 158)
@@ -46,12 +46,6 @@
       <version>1.8.0.7</version>
     </dependency>
     <dependency>
-      <groupId>db</groupId>
-      <artifactId>oracle</artifactId>
-      <version>1.4</version>
-      <scope>test</scope>
-    </dependency>
-    <dependency>
       <groupId>junit</groupId>
       <artifactId>junit</artifactId>
       <version>3.8.1</version>

Author: roy
Date: 2007-09-30 11:54:09 +0200 (Sun, 30 Sep 2007)
New Revision: 159

Modified:
   README
Log:
mention changes


Modified: README
===================================================================
--- README	2007-09-30 09:48:08 UTC (rev 158)
+++ README	2007-09-30 09:54:09 UTC (rev 159)
@@ -62,11 +62,13 @@
 
 0.3 (Unreleased)
 - focus fix in login dialog
+- Improve desc table to show primary key
 - fix to stop spooled lines being appended to each other.
+- Improve tab completion for update
 
 FUTURE
-- Improve desc table (to show primary key, references, etc)
-- Improve tab completion for delete and alter table queries
+- Improve desc table (to show references, etc)
+- Improve tab completion for update, delete and alter table queries
 - Highlight the commands to make a distinction between the output and the commands
 - Remember commands over sessions
 - Make it possible to export/import data via xml (I think there is even an xml standard for this)

Author: rotman
Date: 2007-10-02 11:30:44 +0200 (Tue, 02 Oct 2007)
New Revision: 161

Modified:
   README
Log:
mention fix


Modified: README
===================================================================
--- README	2007-10-02 09:24:45 UTC (rev 160)
+++ README	2007-10-02 09:30:44 UTC (rev 161)
@@ -65,6 +65,7 @@
 - Improve desc table to show primary key
 - fix to stop spooled lines being appended to each other.
 - Improve tab completion for update
+- NullPointerException fix when not running from jar.
 
 FUTURE
 - Improve desc table (to show references, etc)

Author: rotman
Date: 2007-10-02 11:34:21 +0200 (Tue, 02 Oct 2007)
New Revision: 162

Added:
   ChangeLog
Modified:
   README
Log:
moved changes per version to ChangeLog


Added: ChangeLog
===================================================================
--- ChangeLog	                        (rev 0)
+++ ChangeLog	2007-10-02 09:34:21 UTC (rev 162)
@@ -0,0 +1,45 @@
+0.3 (Unreleased)
+ * focus fix in login dialog
+ * Improve desc table to show primary key
+ * fix to stop spooled lines being appended to each other.
+ * Improve tab completion for update
+ * NullPointerException fix when not running from jar.
+
+0.2 (17-09-2007)
+ * Search in history (for example by entering '/query' to make the current command the last command with query in it)
+ * \n always tries to execute the command even if you are not at the end of the command
+ * Show tables (show a list of tables that is available for querying)
+ * BUGFIX: handle large results a bit better (memory wise)
+ * BUGFIX: fix tabcompletion when cursor not at the end of the sql string
+ * tab completion improvements
+ * Make columns in select query fit the max result with instead of the max column width
+ * make command help include list of known connections
+ * make spool command include status
+ * edit fixes
+ * help improvements
+ * make all commands match [\s]*[command][\s]*(|;)
+ * typing 'not at the end of a line' and the line becomes too large.. strange things happen...
+ * improved readability of desc table command
+ * desc of not existing table doesn't give an error
+ * replace ~ in ~/* for user home dir (for spool command)
+ * made '@' appear in help as well
+ * Improve desc table to show not null
+ * scroll all the way down when key typed that is not pageup/down
+
+0.1
+ * connection settings via db.properties and input of password in a seperate dialog
+   configuration can be done by editing a simple db.properties file
+ * command history (key up/down)
+ * spool
+ * read sql script files and execute them
+ * (initial) tab completion
+     * when more matches show all matches in the output window
+     * if less then predefined max show matches in a selection window
+     * if only one match select that match
+ * desc table (initial)
+ * page up/down support
+ * info: show info of the current connection
+ * history: shows last executed commands
+ * help: provide some help about the available commands and it's usage
+ * remove prompt at the start of the command after executing to make it easier to copy/paste commands that are devided into multiple lines
+ * added support for 'show tables having column'

Modified: README
===================================================================
--- README	2007-10-02 09:30:44 UTC (rev 161)
+++ README	2007-10-02 09:34:21 UTC (rev 162)
@@ -21,52 +21,8 @@
 TODO
 
 CURRENT FEATURES
-0.1
-- connection settings via db.properties and input of password in a seperate dialog
-  configuration can be done by editing a simple db.properties file
-- command history (key up/down)
-- spool
-- read sql script files and execute them
-- (initial) tab completion
-    - when more matches show all matches in the output window
-    - if less then predefined max show matches in a selection window
-    - if only one match select that match
-- desc table (initial)
-- page up/down support
-- info: show info of the current connection
-- history: shows last executed commands
-- help: provide some help about the available commands and it's usage
-- remove prompt at the start of the command after executing to make it easier to copy/paste commands that are devided into multiple lines
-- added support for 'show tables having column'
+[See ChangeLog]
 
-0.2 (17-09-2007
-- Search in history (for example by entering '/query' to make the current command the last command with query in it)
-- \n always tries to execute the command even if you are not at the end of the command
-- Show tables (show a list of tables that is available for querying)
-- BUGFIX: handle large results a bit better (memory wise)
-- BUGFIX: fix tabcompletion when cursor not at the end of the sql string
-- tab completion improvements
-- Make columns in select query fit the max result with instead of the max column width
-- make command help include list of known connections
-- make spool command include status
-- edit fixes
-- help improvements
-- make all commands match [\s]*[command][\s]*(|;)
-- typing 'not at the end of a line' and the line becomes too large.. strange things happen...
-- improved readability of desc table command
-- desc of not existing table doesn't give an error
-- replace ~ in ~/* for user home dir (for spool command)
-- made '@' appear in help as well
-- Improve desc table to show not null
-- scroll all the way down when key typed that is not pageup/down
-
-0.3 (Unreleased)
-- focus fix in login dialog
-- Improve desc table to show primary key
-- fix to stop spooled lines being appended to each other.
-- Improve tab completion for update
-- NullPointerException fix when not running from jar.
-
 FUTURE
 - Improve desc table (to show references, etc)
 - Improve tab completion for update, delete and alter table queries

Author: rotman
Date: 2007-10-08 15:46:58 +0200 (Mon, 08 Oct 2007)
New Revision: 167

Modified:
   makejars.sh
   sqlshell
Log:
Use sane defaults


Modified: makejars.sh
===================================================================
--- makejars.sh	2007-10-08 12:16:13 UTC (rev 166)
+++ makejars.sh	2007-10-08 13:46:58 UTC (rev 167)
@@ -1,18 +1,23 @@
 #!/bin/bash
+PROJECT=sqlshell
 VERSION=0.2
+
+#cleanup
 rm -Rf release
 mkdir release
 cd release
+
 #create source files
 mkdir source
 cp -Rf ../src source
 cp ../pom.xml source
 cp ../README source
-cp ../sqlshell source
+cp ../${PROJECT} source
 cd source
-rm -Rf `find . -name *.svn`
-tar zcf ../sqlshell-src-$VERSION.tgz .
-zip -r ../sqlshell-src-$VERSION.zip .
+rm -Rf src/www
+find . -name "*.svn" | xargs rm -Rf
+tar zcf ../${PROJECT}-src-${VERSION}.tgz .
+zip -r ../${PROJECT}-src-${VERSION}.zip .
 cd ..
 rm -Rf source
 
@@ -21,19 +26,23 @@
 mvn clean package
 cd release
 mkdir bin
-cp ../sqlshell bin
+cp ../${PROJECT} bin
 cp ../README bin
 cp ../src/main/resources/db.properties bin
-cp ../target/*.jar bin/sqlclient.jar
+cp ../target/*.jar bin/${PROJECT}.jar
 cp -Rf ../lib bin
 cp -Rf ${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar bin/lib
 mkdir bin/db
 cp -Rf ../db/*.script bin/db
 cp -Rf ../db/*.properties bin/db
 cd bin
-rm -Rf `find . -name *.svn`
-tar zcf ../sqlshell-bin-$VERSION.tgz .
-zip -r ../sqlshell-bin-$VERSION.zip .
+find . -name "*.svn" | xargs rm -Rf
+mv sqlshell _sqlshell
+cat _sqlshell | awk '{ gsub("SQLSHELL=","#SQLSHELL="); gsub("##SQLSHELL=","SQLSHELL="); print }' > sqlshell
+chmod +x sqlshell
+rm _sqlshell
+tar zcf ../${PROJECT}-bin-${VERSION}.tgz .
+zip -r ../${PROJECT}-bin-${VERSION}.zip .
 cd ..
 rm -Rf bin
 cd ..

Modified: sqlshell
===================================================================
--- sqlshell	2007-10-08 12:16:13 UTC (rev 166)
+++ sqlshell	2007-10-08 13:46:58 UTC (rev 167)
@@ -15,28 +15,22 @@
 #   limitations under the License.
 
 # Path to java executable
+#JAVA=$(which java)
 JAVA=${JAVA_HOME}/bin/java
-#JAVA=`which java`
 
 # Dir to use as base for relative locations
-#WORKINGDIR=`pwd`
-WORKINGDIR=`pwd`
+WORKINGDIR=$(pwd)
 
 # The directory where the JCurses jar and library are located.
 # Please note that JCurses requires tje jcurses.jar and libjcurses.so to
 # be located in the same directory.
-#JCURSES=${WORKINGDIR}/lib/
 JCURSES=${WORKINGDIR}/lib
 
 # Where to find the SQLShell classes
-#SQLSHELL=${WORKINGDIR}/sqlclient-0.1-SNAPSHOT.jar
-#SQLSHELL=target/classes
-SQLSHELL=sqlclient.jar
+#SQLSHELL=${WORKINGDIR}/sqlshell.jar
+SQLSHELL=target/classes
 
 # Jars providing drivers for the databases to support.
-#DRIVERS="${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar
-#${HOME}/.m2/repository/db/oracle/1.4/oracle-1.4.jar"
-
 DRIVERS="${WORKINGDIR}/lib/hsqldb-1.8.0.jar"
 
 # The classpath to use when running

Author: rotman
Date: 2007-10-08 16:12:12 +0200 (Mon, 08 Oct 2007)
New Revision: 168

Modified:
   /
Log:
Ignore target dir



Property changes on: 
___________________________________________________________________
Name: svn:ignore
   + target

Author: rotman
Date: 2007-10-08 16:34:39 +0200 (Mon, 08 Oct 2007)
New Revision: 169

Modified:
   makejars.sh
   sqlshell
Log:
Make sure that the 'bin' jar has a script that let's a user run and connect without having to modify the script


Modified: makejars.sh
===================================================================
--- makejars.sh	2007-10-08 14:12:12 UTC (rev 168)
+++ makejars.sh	2007-10-08 14:34:39 UTC (rev 169)
@@ -38,7 +38,7 @@
 cd bin
 find . -name "*.svn" | xargs rm -Rf
 mv sqlshell _sqlshell
-cat _sqlshell | awk '{ gsub("SQLSHELL=","#SQLSHELL="); gsub("##SQLSHELL=","SQLSHELL="); print }' > sqlshell
+cat _sqlshell | awk '{ gsub("SQLSHELL=target/classes","#SQLSHELL=target/classes"); gsub("#SQLSHELL=\${WORKINGDIR}:\${WORKINGDIR}/sqlshell.jar","SQLSHELL=${WORKINGDIR}:${WORKINGDIR}/sqlshell.jar"); print }' > sqlshell
 chmod +x sqlshell
 rm _sqlshell
 tar zcf ../${PROJECT}-bin-${VERSION}.tgz .

Modified: sqlshell
===================================================================
--- sqlshell	2007-10-08 14:12:12 UTC (rev 168)
+++ sqlshell	2007-10-08 14:34:39 UTC (rev 169)
@@ -27,7 +27,7 @@
 JCURSES=${WORKINGDIR}/lib
 
 # Where to find the SQLShell classes
-#SQLSHELL=${WORKINGDIR}/sqlshell.jar
+#SQLSHELL=${WORKINGDIR}:${WORKINGDIR}/sqlshell.jar
 SQLSHELL=target/classes
 
 # Jars providing drivers for the databases to support.

Author: rotman
Date: 2007-10-08 16:39:14 +0200 (Mon, 08 Oct 2007)
New Revision: 170

Modified:
   makejars.sh
Log:
include ChangeLog in release archives


Modified: makejars.sh
===================================================================
--- makejars.sh	2007-10-08 14:34:39 UTC (rev 169)
+++ makejars.sh	2007-10-08 14:39:14 UTC (rev 170)
@@ -12,6 +12,7 @@
 cp -Rf ../src source
 cp ../pom.xml source
 cp ../README source
+cp ../ChangeLog source
 cp ../${PROJECT} source
 cd source
 rm -Rf src/www
@@ -28,6 +29,7 @@
 mkdir bin
 cp ../${PROJECT} bin
 cp ../README bin
+cp ../ChangeLog bin
 cp ../src/main/resources/db.properties bin
 cp ../target/*.jar bin/${PROJECT}.jar
 cp -Rf ../lib bin

Author: rotman
Date: 2007-10-08 17:18:39 +0200 (Mon, 08 Oct 2007)
New Revision: 171

Modified:
   sqlshell
Log:
Allow commandline argument and pass that as connection string


Modified: sqlshell
===================================================================
--- sqlshell	2007-10-08 14:39:14 UTC (rev 170)
+++ sqlshell	2007-10-08 15:18:39 UTC (rev 171)
@@ -39,4 +39,4 @@
     CP=${CP}:${DRIVER}
 done
 
-${JAVA} -cp ${CP} nl.improved.sqlclient.SQLShell
+${JAVA} -cp ${CP} nl.improved.sqlclient.SQLShell $@

Author: rotman
Date: 2007-10-08 17:31:38 +0200 (Mon, 08 Oct 2007)
New Revision: 173

Modified:
   README
Log:
Implemented a feature request


Modified: README
===================================================================
--- README	2007-10-08 15:29:40 UTC (rev 172)
+++ README	2007-10-08 15:31:38 UTC (rev 173)
@@ -29,7 +29,6 @@
 - Highlight the commands to make a distinction between the output and the commands
 - Remember commands over sessions
 - Make it possible to export/import data via xml (I think there is even an xml standard for this)
-- Make it possible to open a connection using command line parameters instead of typing 'connect'
 - Add config possibility to config:
   -- command history size
   -- screen history size

Author: rotman
Date: 2007-10-08 17:31:56 +0200 (Mon, 08 Oct 2007)
New Revision: 174

Modified:
   ChangeLog
Log:
implemented direct connect


Modified: ChangeLog
===================================================================
--- ChangeLog	2007-10-08 15:31:38 UTC (rev 173)
+++ ChangeLog	2007-10-08 15:31:56 UTC (rev 174)
@@ -7,6 +7,7 @@
  * Quit with ^D (on empty commandline)
  * Added tab completion for DESC command
  * BUGFIX: fix tab completion when a "keyword" was found as part of a name.
+ * Added possiblity to start SQLShell in a connected state by providing the connectionstring as commandline argument
 
 0.2 (17-09-2007)
  * Search in history (for example by entering '/query' to make the current command the last command with query in it)

Author: rotman
Date: 2007-10-09 10:30:05 +0200 (Tue, 09 Oct 2007)
New Revision: 176

Modified:
   ChangeLog
Log:
Set a date for the 0.1


Modified: ChangeLog
===================================================================
--- ChangeLog	2007-10-08 15:43:13 UTC (rev 175)
+++ ChangeLog	2007-10-09 08:30:05 UTC (rev 176)
@@ -30,7 +30,7 @@
  * Improve desc table to show not null
  * scroll all the way down when key typed that is not pageup/down
 
-0.1
+0.1 (01-08-2007)
  * connection settings via db.properties and input of password in a seperate dialog
    configuration can be done by editing a simple db.properties file
  * command history (key up/down)

Author: rotman
Date: 2007-10-09 10:31:13 +0200 (Tue, 09 Oct 2007)
New Revision: 177

Modified:
   pom.xml
Log:
Set 0.3 final version; Remove hsqldb dependency, Fix Classpath


Modified: pom.xml
===================================================================
--- pom.xml	2007-10-09 08:30:05 UTC (rev 176)
+++ pom.xml	2007-10-09 08:31:13 UTC (rev 177)
@@ -19,9 +19,9 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.3-SNAPSHOT</version>
-  <name>Improved SQLShell</name>
-  <!--url>http://maven.apache.org</url-->
+  <version>0.3</version>
+  <name>SQLShell ~ the improved sqlclient</name>
+  <url>http://sqlshell.sourceforge.org</url>
   <build>
     <defaultGoal>compile</defaultGoal>
     <plugins>
@@ -41,11 +41,6 @@
       <version>0.9.5</version>
     </dependency>
     <dependency>
-      <groupId>hsqldb</groupId>
-      <artifactId>hsqldb</artifactId>
-      <version>1.8.0.7</version>
-    </dependency>
-    <dependency>
       <groupId>junit</groupId>
       <artifactId>junit</artifactId>
       <version>3.8.1</version>

Author: rotman
Date: 2007-10-09 10:31:46 +0200 (Tue, 09 Oct 2007)
New Revision: 178

Modified:
   makejars.sh
Log:
Classpath was fixed, so that affects our awk line


Modified: makejars.sh
===================================================================
--- makejars.sh	2007-10-09 08:31:13 UTC (rev 177)
+++ makejars.sh	2007-10-09 08:31:46 UTC (rev 178)
@@ -1,6 +1,6 @@
 #!/bin/bash
 PROJECT=sqlshell
-VERSION=0.2
+VERSION=0.3
 
 #cleanup
 rm -Rf release
@@ -40,7 +40,7 @@
 cd bin
 find . -name "*.svn" | xargs rm -Rf
 mv sqlshell _sqlshell
-cat _sqlshell | awk '{ gsub("SQLSHELL=target/classes","#SQLSHELL=target/classes"); gsub("#SQLSHELL=\${WORKINGDIR}:\${WORKINGDIR}/sqlshell.jar","SQLSHELL=${WORKINGDIR}:${WORKINGDIR}/sqlshell.jar"); print }' > sqlshell
+cat _sqlshell | awk '{ gsub("SQLSHELL=target/classes","#SQLSHELL=target/classes"); gsub("#SQLSHELL=\${WORKINGDIR}/sqlshell.jar","SQLSHELL=${WORKINGDIR}/sqlshell.jar"); print }' > sqlshell
 chmod +x sqlshell
 rm _sqlshell
 tar zcf ../${PROJECT}-bin-${VERSION}.tgz .

Author: rotman
Date: 2007-10-09 10:32:18 +0200 (Tue, 09 Oct 2007)
New Revision: 179

Modified:
   sqlshell
Log:
this is where the classpath was fixed (not in the pom... duh)


Modified: sqlshell
===================================================================
--- sqlshell	2007-10-09 08:31:46 UTC (rev 178)
+++ sqlshell	2007-10-09 08:32:18 UTC (rev 179)
@@ -27,14 +27,14 @@
 JCURSES=${WORKINGDIR}/lib
 
 # Where to find the SQLShell classes
-#SQLSHELL=${WORKINGDIR}:${WORKINGDIR}/sqlshell.jar
+#SQLSHELL=${WORKINGDIR}/sqlshell.jar
 SQLSHELL=target/classes
 
 # Jars providing drivers for the databases to support.
 DRIVERS="${WORKINGDIR}/lib/hsqldb-1.8.0.jar"
 
 # The classpath to use when running
-CP=${SQLSHELL}:${JCURSES}/jcurses.jar
+CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar
 for DRIVER in ${DRIVERS} ; do
     CP=${CP}:${DRIVER}
 done

Author: rotman
Date: 2007-10-09 11:16:28 +0200 (Tue, 09 Oct 2007)
New Revision: 181

Modified:
   ChangeLog
Log:
Set a release date on the 0.3 release


Modified: ChangeLog
===================================================================
--- ChangeLog	2007-10-09 08:32:47 UTC (rev 180)
+++ ChangeLog	2007-10-09 09:16:28 UTC (rev 181)
@@ -1,4 +1,4 @@
-0.3 (Unreleased)
+0.3 (09-10-2007)
  * focus fix in login dialog
  * Improve desc table to show primary key
  * BUGFIX: fix to stop spooled lines being appended to each other.

Author: rotman
Date: 2007-10-09 11:32:41 +0200 (Tue, 09 Oct 2007)
New Revision: 182

Modified:
   pom.xml
Log:
Ensure that future commits won't be accidentally committed into 0.3 version ;)


Modified: pom.xml
===================================================================
--- pom.xml	2007-10-09 09:16:28 UTC (rev 181)
+++ pom.xml	2007-10-09 09:32:41 UTC (rev 182)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.3</version>
+  <version>0.4-SNAPSHOT</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2007-11-07 12:50:18 +0100 (Wed, 07 Nov 2007)
New Revision: 198

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2007-11-07 11:50:04 UTC (rev 197)
+++ ChangeLog	2007-11-07 11:50:18 UTC (rev 198)
@@ -4,6 +4,8 @@
     * desc
     * execute batch command
     * show
+ * allow enter in pwd field to 'ok' data
+ TODO: flush pwd when username manually set and doesn't match default username
 0.3 (09-10-2007)
  * focus fix in login dialog
  * Improve desc table to show primary key

Author: roy
Date: 2007-12-02 13:49:15 +0100 (Sun, 02 Dec 2007)
New Revision: 202

Modified:
   pom.xml
Log:
change pom so you don't have to manually install jcurses


Modified: pom.xml
===================================================================
--- pom.xml	2007-12-02 12:43:35 UTC (rev 201)
+++ pom.xml	2007-12-02 12:49:15 UTC (rev 202)
@@ -39,6 +39,8 @@
       <groupId>net.sf.jcurses</groupId>
       <artifactId>jcurses</artifactId>
       <version>0.9.5</version>
+      <scope>system</scope>
+      <systemPath>${basedir}/lib/jcurses.jar</systemPath>
     </dependency>
     <dependency>
       <groupId>junit</groupId>

Author: roy
Date: 2008-01-12 12:05:55 +0100 (Sat, 12 Jan 2008)
New Revision: 210

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-01-12 10:58:07 UTC (rev 209)
+++ ChangeLog	2008-01-12 11:05:55 UTC (rev 210)
@@ -4,6 +4,8 @@
     * desc
     * execute batch command
     * show
+    * group by
+    * order by
  * allow enter in pwd field to 'ok' data
  TODO: flush pwd when username manually set and doesn't match default username
 0.3 (09-10-2007)

Author: roy
Date: 2008-01-12 12:08:05 +0100 (Sat, 12 Jan 2008)
New Revision: 211

Modified:
   README
Log:
mention new feature requests


Modified: README
===================================================================
--- README	2008-01-12 11:05:55 UTC (rev 210)
+++ README	2008-01-12 11:08:05 UTC (rev 211)
@@ -24,6 +24,8 @@
 [See ChangeLog]
 
 FUTURE
+- add 'show tables like' support
+- login schreen improvements (select all text on focus)
 - Improve desc table (to show references, etc)
 - Improve tab completion for update, delete and alter table queries
 - Highlight the commands to make a distinction between the output and the commands

Author: roy
Date: 2008-01-12 20:08:46 +0100 (Sat, 12 Jan 2008)
New Revision: 214

Modified:
   ChangeLog
Log:
mention change


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-01-12 19:05:47 UTC (rev 213)
+++ ChangeLog	2008-01-12 19:08:46 UTC (rev 214)
@@ -1,4 +1,5 @@
 0.4
+ * Fix display of time in date column (at least for oracle)
  * Improve tab comnpletion
  * Added tabcompletion for:
     * desc

Author: roy
Date: 2008-01-13 12:04:52 +0100 (Sun, 13 Jan 2008)
New Revision: 218

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-01-13 10:42:47 UTC (rev 217)
+++ ChangeLog	2008-01-13 11:04:52 UTC (rev 218)
@@ -1,4 +1,5 @@
 0.4
+ * Improved speed for displaying large( >200<20000 rows) query results
  * Fix display of time in date column (at least for oracle)
  * Improve tab comnpletion
  * Added tabcompletion for:

Author: roy
Date: 2008-01-14 08:04:24 +0100 (Mon, 14 Jan 2008)
New Revision: 219

Modified:
   pom.xml
Log:
version 0.4


Modified: pom.xml
===================================================================
--- pom.xml	2008-01-13 11:04:52 UTC (rev 218)
+++ pom.xml	2008-01-14 07:04:24 UTC (rev 219)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.4-SNAPSHOT</version>
+  <version>0.4</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2008-01-17 07:39:08 +0100 (Thu, 17 Jan 2008)
New Revision: 223

Modified:
   ChangeLog
Log:
mention change


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-01-14 14:21:08 UTC (rev 222)
+++ ChangeLog	2008-01-17 06:39:08 UTC (rev 223)
@@ -9,6 +9,7 @@
     * group by
     * order by
  * allow enter in pwd field to 'ok' data
+ * fix in replace ~/ with users home dir in spool
  TODO: flush pwd when username manually set and doesn't match default username
 0.3 (09-10-2007)
  * focus fix in login dialog

Author: roy
Date: 2008-01-24 21:45:55 +0100 (Thu, 24 Jan 2008)
New Revision: 224

Modified:
   README
Log:
mention Windows


Modified: README
===================================================================
--- README	2008-01-17 06:39:08 UTC (rev 223)
+++ README	2008-01-24 20:45:55 UTC (rev 224)
@@ -18,7 +18,9 @@
 In the most simple case download the zip or tgz file from the sourceforge website and unzip it to the folder of your liking. Then you can start the programm that is setup to use a simple testdatabase by executing 'sqlshell'. Please note that because of javacurses currently you need to enter the directory in which sqlshell is located before starting it. This is a bug that hopefully we can address really soon.
 
 Windows:
-TODO
+1. Copy or move the dll located in the windows directory to the lib directory (the directory containing jcurses.jar
+2. Change the INSTALLATION_DIR variable in sqlshell.bat file
+3. Start sqlshell.bat
 
 CURRENT FEATURES
 [See ChangeLog]

Author: roy
Date: 2008-01-24 21:46:27 +0100 (Thu, 24 Jan 2008)
New Revision: 225

Modified:
   makejars.sh
Log:
0.4
added windows stuff


Modified: makejars.sh
===================================================================
--- makejars.sh	2008-01-24 20:45:55 UTC (rev 224)
+++ makejars.sh	2008-01-24 20:46:27 UTC (rev 225)
@@ -1,6 +1,6 @@
 #!/bin/bash
 PROJECT=sqlshell
-VERSION=0.3
+VERSION=0.4
 
 #cleanup
 rm -Rf release
@@ -14,6 +14,7 @@
 cp ../README source
 cp ../ChangeLog source
 cp ../${PROJECT} source
+cp ../${PROJECT}.bat source
 cd source
 rm -Rf src/www
 find . -name "*.svn" | xargs rm -Rf
@@ -28,12 +29,14 @@
 cd release
 mkdir bin
 cp ../${PROJECT} bin
+cp ../${PROJECT}.bat bin
 cp ../README bin
 cp ../ChangeLog bin
 cp ../src/main/resources/db.properties bin
 cp ../target/*.jar bin/${PROJECT}.jar
 cp -Rf ../lib bin
-cp -Rf ${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar bin/lib
+cp -Rf ../windows bin
+#cp -Rf ${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar bin/lib
 mkdir bin/db
 cp -Rf ../db/*.script bin/db
 cp -Rf ../db/*.properties bin/db
@@ -43,6 +46,7 @@
 cat _sqlshell | awk '{ gsub("SQLSHELL=target/classes","#SQLSHELL=target/classes"); gsub("#SQLSHELL=\${WORKINGDIR}/sqlshell.jar","SQLSHELL=${WORKINGDIR}/sqlshell.jar"); print }' > sqlshell
 chmod +x sqlshell
 rm _sqlshell
+cp -Rf ../../windows .
 tar zcf ../${PROJECT}-bin-${VERSION}.tgz .
 zip -r ../${PROJECT}-bin-${VERSION}.zip .
 cd ..

Author: roy
Date: 2008-01-24 22:00:21 +0100 (Thu, 24 Jan 2008)
New Revision: 226

Modified:
   pom.xml
Log:
0.5 snapshot


Modified: pom.xml
===================================================================
--- pom.xml	2008-01-24 20:46:27 UTC (rev 225)
+++ pom.xml	2008-01-24 21:00:21 UTC (rev 226)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.4</version>
+  <version>0.5-SNAPSHOT</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2008-01-24 22:01:47 +0100 (Thu, 24 Jan 2008)
New Revision: 227

Modified:
   README
Log:
added new ideas


Modified: README
===================================================================
--- README	2008-01-24 21:00:21 UTC (rev 226)
+++ README	2008-01-24 21:01:47 UTC (rev 227)
@@ -26,6 +26,10 @@
 [See ChangeLog]
 
 FUTURE
+- dump history to file
+- show status (query executing, waiting for input... etc)
+- sort commands in help
+- add key bindings in help
 - add 'show tables like' support
 - login schreen improvements (select all text on focus)
 - Improve desc table (to show references, etc)
@@ -41,4 +45,4 @@
 - Large query results don't show (> 300.000 rows?)
 - 'where x' doesn't autocomplete table names
 - make ctrl+j (for example) auto insert join
-- make ctrl+c abort query
+- make ctrl+a abort query (ctr c quits application... don't know how to catch that)

Author: roy
Date: 2008-01-24 22:02:26 +0100 (Thu, 24 Jan 2008)
New Revision: 228

Modified:
   ChangeLog
Log:
0.4 released


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-01-24 21:01:47 UTC (rev 227)
+++ ChangeLog	2008-01-24 21:02:26 UTC (rev 228)
@@ -1,4 +1,6 @@
-0.4
+-.5
+
+0.4 (2008-01-24)
  * Improved speed for displaying large( >200<20000 rows) query results
  * Fix display of time in date column (at least for oracle)
  * Improve tab comnpletion

Author: roy
Date: 2008-03-02 15:09:51 +0100 (Sun, 02 Mar 2008)
New Revision: 247

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-03-02 14:08:49 UTC (rev 246)
+++ ChangeLog	2008-03-02 14:09:51 UTC (rev 247)
@@ -1,4 +1,16 @@
--.5
+0.5
+ * Allow for commands to start in the background, this will allow to continue
+ reading keyboard input (currently used to abort commands)
+ * Added help to keyboard mappings (pageup/down/end/home, etc)
+ * BUGFIX: Added fixes for mysql, mysql uses lowercase tablenames where oracle uses
+ uppercase. Currenlty SQLShell tries to figure out which one to use
+ automatically
+ * timestamp display fixes
+ * Tabcompletion improvements (fixed deadlock caused by an error in regular
+ expressions api from java)
+ * Improved navigation in edit mode (home/end). It should be more intuitive
+ and usefull now
+ * Removed border of one character to maximize the usage of the screen
 
 0.4 (2008-01-24)
  * Improved speed for displaying large( >200<20000 rows) query results

Author: roy
Date: 2008-03-05 08:29:22 +0100 (Wed, 05 Mar 2008)
New Revision: 251

Modified:
   pom.xml
Log:
version 0.5


Modified: pom.xml
===================================================================
--- pom.xml	2008-03-04 10:52:42 UTC (rev 250)
+++ pom.xml	2008-03-05 07:29:22 UTC (rev 251)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.5-SNAPSHOT</version>
+  <version>0.5</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2008-03-14 13:39:55 +0100 (Fri, 14 Mar 2008)
New Revision: 252

Modified:
   pom.xml
Log:
work on 0.6 started


Modified: pom.xml
===================================================================
--- pom.xml	2008-03-05 07:29:22 UTC (rev 251)
+++ pom.xml	2008-03-14 12:39:55 UTC (rev 252)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.5</version>
+  <version>0.6-SNAPSHOT</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2008-03-18 22:19:11 +0100 (Tue, 18 Mar 2008)
New Revision: 256

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-03-18 21:18:43 UTC (rev 255)
+++ ChangeLog	2008-03-18 21:19:11 UTC (rev 256)
@@ -1,4 +1,8 @@
-0.5
+0.6
+ * Fix desc table for columns containing numbers
+ * Added tab completion for connect @
+
+0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue
  reading keyboard input (currently used to abort commands)
  * Added help to keyboard mappings (pageup/down/end/home, etc)

Author: roy
Date: 2008-04-04 20:43:39 +0200 (Fri, 04 Apr 2008)
New Revision: 260

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-04-04 18:33:05 UTC (rev 259)
+++ ChangeLog	2008-04-04 18:43:39 UTC (rev 260)
@@ -1,6 +1,7 @@
 0.6
  * Fix desc table for columns containing numbers
  * Added tab completion for connect @
+ * Fix tabcompletion when using LIKE comparisons
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-05-19 22:55:11 +0200 (Mon, 19 May 2008)
New Revision: 262

Modified:
   ChangeLog
Log:
some changes for mysql


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-05-19 20:28:44 UTC (rev 261)
+++ ChangeLog	2008-05-19 20:55:11 UTC (rev 262)
@@ -1,4 +1,5 @@
 0.6
+ * Mysql case sensitivity fixes
  * Fix desc table for columns containing numbers
  * Added tab completion for connect @
  * Fix tabcompletion when using LIKE comparisons

Author: roy
Date: 2008-07-23 12:25:10 +0200 (Wed, 23 Jul 2008)
New Revision: 267

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-07-23 09:50:14 UTC (rev 266)
+++ ChangeLog	2008-07-23 10:25:10 UTC (rev 267)
@@ -4,6 +4,8 @@
  * Added tab completion for connect @
  * Fix tabcompletion when using LIKE comparisons
  * Fix for index out of bounds for strings without spaces
+ * Fix for quit on some systems (hardy heron for example)
+ * Added dump/read command to dump (a part of) a table
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-07-31 09:59:52 +0200 (Thu, 31 Jul 2008)
New Revision: 276

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-07-31 07:59:08 UTC (rev 275)
+++ ChangeLog	2008-07-31 07:59:52 UTC (rev 276)
@@ -6,6 +6,7 @@
  * Fix for index out of bounds for strings without spaces
  * Fix for quit on some systems (hardy heron for example)
  * Added dump/read command to dump (a part of) a table
+ * Tab completion case sensitive fix (For example jo<tab> -> Job)
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-08-19 13:05:39 +0200 (Tue, 19 Aug 2008)
New Revision: 288

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-08-19 11:00:11 UTC (rev 287)
+++ ChangeLog	2008-08-19 11:05:39 UTC (rev 288)
@@ -7,6 +7,7 @@
  * Fix for quit on some systems (hardy heron for example)
  * Added dump/read command to dump (a part of) a table
  * Tab completion case sensitive fix (For example jo<tab> -> Job)
+ * Add tab completion to spool command
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-08-23 14:32:57 +0200 (Sat, 23 Aug 2008)
New Revision: 296

Modified:
   pom.xml
Log:
java 6-5 fixes


Modified: pom.xml
===================================================================
--- pom.xml	2008-08-23 12:32:42 UTC (rev 295)
+++ pom.xml	2008-08-23 12:32:57 UTC (rev 296)
@@ -28,8 +28,8 @@
       <plugin>
         <artifactId>maven-compiler-plugin</artifactId>
         <configuration>
-          <source>1.6</source>
-          <target>1.6</target>
+          <source>1.5</source>
+          <target>1.5</target>
         </configuration>
       </plugin>
     </plugins>

Author: roy
Date: 2008-08-24 22:18:29 +0200 (Sun, 24 Aug 2008)
New Revision: 299

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-08-24 20:18:18 UTC (rev 298)
+++ ChangeLog	2008-08-24 20:18:29 UTC (rev 299)
@@ -8,6 +8,7 @@
  * Added dump/read command to dump (a part of) a table
  * Tab completion case sensitive fix (For example jo<tab> -> Job)
  * Add tab completion to spool command
+ * Fix error message in @ command when file could not be read
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-10-12 14:15:13 +0200 (Sun, 12 Oct 2008)
New Revision: 313

Added:
   sqlshell.bat
Log:
windows batch file


Added: sqlshell.bat
===================================================================
--- sqlshell.bat	2008-10-12 11:57:48 UTC (rev 312)
+++ sqlshell.bat	2008-10-12 12:15:13 UTC (rev 313)
@@ -0,0 +1,32 @@
+REM   Copyright 2007 Roy van der Kuil (roy@...) and Stefan Rotman (stefan@...)
+REM
+REM   Licensed under the Apache License, Version 2.0 (the "License");
+REM   you may not use this file except in compliance with the License.
+REM   You may obtain a copy of the License at
+REM
+REM       http://www.apache.org/licenses/LICENSE-2.0
+REM
+REM   Unless required by applicable law or agreed to in writing, software
+REM   distributed under the License is distributed on an "AS IS" BASIS,
+REM   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+REM   See the License for the specific language governing permissions and
+REM   limitations under the License.
+
+REM Dir to use as base for relative locations
+set WORKINGDIR=c:\sqlshell\
+
+REM The directory where the JCurses jar and library are located.
+REM Please note that JCurses requires tje jcurses.jar and libjcurses.so to
+REM be located in the same directory.
+set JCURSES=%WORKINGDIR%\lib
+
+REM Where to find the SQLShell classes
+set SQLSHELL=%WORKINGDIR%\sqlshell.jar
+
+# REM providing drivers for the databases to support.
+set DRIVERS="%WORKINGDIR%\lib\hsqldb-1.8.0.jar"
+
+REM The classpath to use when running
+set CP=%WORKINGDIR%;%SQLSHELL%;%JCURSES%\jcurses.jar;%WORKINGDIR%\lib\charva\charva.jar;%WORKINGDIR%\lib\commons-logging.jar
+
+java -Djava.library.path=%WORKINGDIR%\lib\charva -classpath %CP%;%DRIVERS% nl.improved.sqlclient.charva.SQLShellComponent


Property changes on: sqlshell.bat
___________________________________________________________________
Name: svn:executable
   + *

Author: roy
Date: 2008-10-12 14:15:32 +0200 (Sun, 12 Oct 2008)
New Revision: 314

Modified:
   pom.xml
Log:
0.6 version


Modified: pom.xml
===================================================================
--- pom.xml	2008-10-12 12:15:13 UTC (rev 313)
+++ pom.xml	2008-10-12 12:15:32 UTC (rev 314)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.6-SNAPSHOT</version>
+  <version>0.6</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2008-10-12 15:09:16 +0200 (Sun, 12 Oct 2008)
New Revision: 316

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-10-12 12:30:37 UTC (rev 315)
+++ ChangeLog	2008-10-12 13:09:16 UTC (rev 316)
@@ -1,4 +1,4 @@
-0.6
+0.6 (2008-10-12)
  * Mysql case sensitivity fixes
  * Fix desc table for columns containing numbers
  * Added tab completion for connect @
@@ -9,6 +9,8 @@
  * Tab completion case sensitive fix (For example jo<tab> -> Job)
  * Add tab completion to spool command
  * Fix error message in @ command when file could not be read
+ * Add persistent history
+ * Improved multithreading support by changing (default) toolkit used (charva)
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-10-13 20:40:23 +0200 (Mon, 13 Oct 2008)
New Revision: 318

Modified:
   makejars.sh
Log:
new version


Modified: makejars.sh
===================================================================
--- makejars.sh	2008-10-13 13:30:59 UTC (rev 317)
+++ makejars.sh	2008-10-13 18:40:23 UTC (rev 318)
@@ -1,6 +1,6 @@
 #!/bin/bash
 PROJECT=sqlshell
-VERSION=0.4
+VERSION=0.6
 
 #cleanup
 rm -Rf release
@@ -13,12 +13,13 @@
 cp ../pom.xml source
 cp ../README source
 cp ../ChangeLog source
+cp ../docs/release-${VERSION}.txt source
 cp ../${PROJECT} source
 cp ../${PROJECT}.bat source
 cd source
 rm -Rf src/www
 find . -name "*.svn" | xargs rm -Rf
-tar zcf ../${PROJECT}-src-${VERSION}.tgz .
+#tar zcf ../${PROJECT}-src-${VERSION}.tgz .
 zip -r ../${PROJECT}-src-${VERSION}.zip .
 cd ..
 rm -Rf source
@@ -32,6 +33,7 @@
 cp ../${PROJECT}.bat bin
 cp ../README bin
 cp ../ChangeLog bin
+cp ../docs/release-${VERSION}.txt bin
 cp ../src/main/resources/db.properties bin
 cp ../target/*.jar bin/${PROJECT}.jar
 cp -Rf ../lib bin
@@ -47,7 +49,7 @@
 chmod +x sqlshell
 rm _sqlshell
 cp -Rf ../../windows .
-tar zcf ../${PROJECT}-bin-${VERSION}.tgz .
+#tar zcf ../${PROJECT}-bin-${VERSION}.tgz .
 zip -r ../${PROJECT}-bin-${VERSION}.zip .
 cd ..
 rm -Rf bin

Author: roy
Date: 2008-10-13 20:42:25 +0200 (Mon, 13 Oct 2008)
New Revision: 319

Modified:
   sqlshell
Log:
new startup script


Modified: sqlshell
===================================================================
--- sqlshell	2008-10-13 18:40:23 UTC (rev 318)
+++ sqlshell	2008-10-13 18:42:25 UTC (rev 319)
@@ -22,21 +22,28 @@
 WORKINGDIR=$(pwd)
 
 # The directory where the JCurses jar and library are located.
-# Please note that JCurses requires tje jcurses.jar and libjcurses.so to
+# Please note that JCurses requires the jcurses.jar and libjcurses.so to
 # be located in the same directory.
-JCURSES=${WORKINGDIR}/lib
+JCURSES=${WORKINGDIR}/lib/jcurses
+# The directory where the charva jar and library (dll/so file) are located.
+CHARVA=${WORKINGDIR}/lib/charva
 
 # Where to find the SQLShell classes
-#SQLSHELL=${WORKINGDIR}/sqlshell.jar
-SQLSHELL=target/classes
+SQLSHELL=${WORKINGDIR}/sqlshell.jar
+##SQLSHELL=target/classes
 
 # Jars providing drivers for the databases to support.
 DRIVERS="${WORKINGDIR}/lib/hsqldb-1.8.0.jar"
 
 # The classpath to use when running
-CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar
+#CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar
+#CP=${WORKINGDIR}:${SQLSHELL}:${JCURSES}/jcurses.jar
+CP=${WORKINGDIR}:${SQLSHELL}:${CHARVA}/charva.jar:${WORKINGDIR}/lib/commons-logging.jar
 for DRIVER in ${DRIVERS} ; do
     CP=${CP}:${DRIVER}
 done
 
-${JAVA} -cp ${CP} nl.improved.sqlclient.SQLShell $@
+#Enable the file below to use the jcurses version
+#${JAVA} -cp ${CP} nl.improved.sqlclient.jcurses.SQLShell $@
+#Charva version
+${JAVA} -Djava.library.path=${CHARVA} -cp ${CP} nl.improved.sqlclient.charva.SQLShellComponent $@

Author: roy
Date: 2008-12-22 13:54:27 +0100 (Mon, 22 Dec 2008)
New Revision: 332

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-12-22 12:53:46 UTC (rev 331)
+++ ChangeLog	2008-12-22 12:54:27 UTC (rev 332)
@@ -11,6 +11,10 @@
  * Fix error message in @ command when file could not be read
  * Add persistent history
  * Improved multithreading support by changing (default) toolkit used (charva)
+ * Add description of column in 'show tables having <column>' command
+ * Fix line splitting cursor issues
+ * Added error log file (temporary) which will write a file to your temporary
+ directory
 
 0.5 (2008-03-14)
  * Allow for commands to start in the background, this will allow to continue

Author: roy
Date: 2008-12-22 15:13:50 +0100 (Mon, 22 Dec 2008)
New Revision: 337

Modified:
   sqlshell.bat
Log:
use jcurses on windows


Modified: sqlshell.bat
===================================================================
--- sqlshell.bat	2008-12-22 13:50:19 UTC (rev 336)
+++ sqlshell.bat	2008-12-22 14:13:50 UTC (rev 337)
@@ -29,4 +29,4 @@
 REM The classpath to use when running
 set CP=%WORKINGDIR%;%SQLSHELL%;%JCURSES%\jcurses.jar;%WORKINGDIR%\lib\charva\charva.jar;%WORKINGDIR%\lib\commons-logging.jar
 
-java -Djava.library.path=%WORKINGDIR%\lib\charva -classpath %CP%;%DRIVERS% nl.improved.sqlclient.charva.SQLShellComponent
+java -Djava.library.path=%WORKINGDIR%\lib\charva -classpath %CP%;%DRIVERS% nl.improved.sqlclient.jcurses.SQLShell

Author: roy
Date: 2008-12-24 16:14:20 +0100 (Wed, 24 Dec 2008)
New Revision: 339

Modified:
   pom.xml
Log:
start work on 0.7


Modified: pom.xml
===================================================================
--- pom.xml	2008-12-24 14:53:30 UTC (rev 338)
+++ pom.xml	2008-12-24 15:14:20 UTC (rev 339)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.6.1</version>
+  <version>0.7-SNAPSHOT</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2008-12-24 16:24:37 +0100 (Wed, 24 Dec 2008)
New Revision: 342

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2008-12-24 15:24:23 UTC (rev 341)
+++ ChangeLog	2008-12-24 15:24:37 UTC (rev 342)
@@ -1,4 +1,10 @@
-0.6 (2008-10-12)
+0.7
+ * Commandline input support (currently only supported in charva mode)
+
+0.6.1 (2008-12-24)
+ * Bugfix release for not starting
+
+0.6 (2008-12-23)
  * Mysql case sensitivity fixes
  * Fix desc table for columns containing numbers
  * Added tab completion for connect @
@@ -43,6 +49,7 @@
  * allow enter in pwd field to 'ok' data
  * fix in replace ~/ with users home dir in spool
  TODO: flush pwd when username manually set and doesn't match default username
+
 0.3 (09-10-2007)
  * focus fix in login dialog
  * Improve desc table to show primary key

Author: roy
Date: 2009-01-17 16:19:18 +0100 (Sat, 17 Jan 2009)
New Revision: 356

Modified:
   README
Log:
some improvements/cleanup


Modified: README
===================================================================
--- README	2009-01-17 15:15:31 UTC (rev 355)
+++ README	2009-01-17 15:19:18 UTC (rev 356)
@@ -7,7 +7,9 @@
 
 
 INSTALLATION
-Minimum (tested) requirements: SUN Java 6 and a working operating system for javacurses (http://sf.net/projects/javacurses)
+Minimum (tested) requirements: SUN Java 6 and a working operating system for:
+javacurses (http://sf.net/projects/javacurses)
+or charva (http://www.pitman.co.za/projects/charva/index.html).
 
 Linux:
 Please note that in order to be able to run the improved sqlclient
@@ -26,23 +28,17 @@
 [See ChangeLog]
 
 FUTURE
-- dump history to file
 - show status (query executing, waiting for input... etc)
 - sort commands in help
-- add key bindings in help
 - add 'show tables like' support
 - login schreen improvements (select all text on focus)
 - Improve desc table (to show references, etc)
 - Improve tab completion for update, delete and alter table queries
 - Highlight the commands to make a distinction between the output and the commands
-- Remember commands over sessions
-- Make it possible to export/import data via xml (I think there is even an xml standard for this)
 - Add config possibility to config:
   -- command history size
   -- screen history size
   -- screen colors
   -- additional/external commands
-- Large query results don't show (> 300.000 rows?)
 - 'where x' doesn't autocomplete table names
 - make ctrl+j (for example) auto insert join
-- make ctrl+a abort query (ctr c quits application... don't know how to catch that)

Author: roy
Date: 2009-01-17 16:51:17 +0100 (Sat, 17 Jan 2009)
New Revision: 357

Modified:
   README
Log:
more changes


Modified: README
===================================================================
--- README	2009-01-17 15:19:18 UTC (rev 356)
+++ README	2009-01-17 15:51:17 UTC (rev 357)
@@ -11,14 +11,26 @@
 javacurses (http://sf.net/projects/javacurses)
 or charva (http://www.pitman.co.za/projects/charva/index.html).
 
-Linux:
+Linux
+In the most simple case download the zip file from the sourceforge website
+and unzip it to the folder of your liking. Then you can start sqlshell by entering './sqlshell'.
+The sqlshell batch script tries to detect it's installation directory. If this doesn't work you
+need to manually edit the sqlshell script and change the CURDIR variable. By default it tries
+to start the charva version.
+
+With Charva
+In order to run sqlshell using charva you need to have the charva libraries in the lib folder.
+Currently charva is compiled for windows (32 bits) and linux intel 32 bits and amd 64 bits. If you don't
+own an intel 32 bits, you need to modify the contents of the lib/charva directory.
+
+With JCurses
 Please note that in order to be able to run the improved sqlclient
 with the 'sqlshell' script, the $project/lib dir is required to
-contain the jcurses.jar and libjcurses.so files. Also note that
-jcurses.jar need NOT be a symlink.
+contain the jcurses.jar and libjcurses.so files. 
+Also note that jcurses.jar need NOT be a symlink.
 
-In the most simple case download the zip or tgz file from the sourceforge website and unzip it to the folder of your liking. Then you can start the programm that is setup to use a simple testdatabase by executing 'sqlshell'. Please note that because of javacurses currently you need to enter the directory in which sqlshell is located before starting it. This is a bug that hopefully we can address really soon.
 
+
 Windows:
 1. Copy or move the dll located in the windows directory to the lib directory (the directory containing jcurses.jar
 2. Change the INSTALLATION_DIR variable in sqlshell.bat file

Author: roy
Date: 2009-01-17 16:57:58 +0100 (Sat, 17 Jan 2009)
New Revision: 358

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-01-17 15:51:17 UTC (rev 357)
+++ ChangeLog	2009-01-17 15:57:58 UTC (rev 358)
@@ -1,5 +1,11 @@
 0.7
- * Commandline input support (currently only supported in charva mode)
+ * Commandline input support
+ * Paged command output (no longer out of memory exceptions with large
+ results)
+ * pageup/down bugfix
+ * All kind of sqlcommand parsing fixes in batch ('@') command
+ * Added abort/continue on error options for batch command
+ * Show contents of error file when sqlshell is closed
 
 0.6.1 (2008-12-24)
  * Bugfix release for not starting

Author: roy
Date: 2009-01-25 15:00:26 +0100 (Sun, 25 Jan 2009)
New Revision: 367

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-01-25 13:59:44 UTC (rev 366)
+++ ChangeLog	2009-01-25 14:00:26 UTC (rev 367)
@@ -1,11 +1,14 @@
 0.7
  * Commandline input support
+   * -engine option to switch between charva (default) and jcurses
  * Paged command output (no longer out of memory exceptions with large
  results)
  * pageup/down bugfix
  * All kind of sqlcommand parsing fixes in batch ('@') command
  * Added abort/continue on error options for batch command
  * Show contents of error file when sqlshell is closed
+ * Paint issues in charva
+ * Paint issues in jcurses
 
 0.6.1 (2008-12-24)
  * Bugfix release for not starting

Author: roy
Date: 2009-02-20 21:46:01 +0100 (Fri, 20 Feb 2009)
New Revision: 375

Modified:
   sqlshell
   sqlshell.bat
Log:
fix startup files
removed dll/so file depending on host system (.sh file or bat file)


Modified: sqlshell
===================================================================
--- sqlshell	2009-02-20 20:45:25 UTC (rev 374)
+++ sqlshell	2009-02-20 20:46:01 UTC (rev 375)
@@ -47,7 +47,8 @@
     CP=${CP}:${DRIVER}
 done
 
+#unix source.. cleanup windows dll
+rm ${WORKINGDIR}/lib/jcurses/*.dll
 #Enable the file below to use the jcurses version
 #${JAVA} -cp ${CP} nl.improved.sqlclient.jcurses.SQLShell $@
-#Charva version
 ${JAVA} -Djava.library.path=${CHARVA} -cp ${CP} nl.improved.sqlclient.SQLShell $@

Modified: sqlshell.bat
===================================================================
--- sqlshell.bat	2009-02-20 20:45:25 UTC (rev 374)
+++ sqlshell.bat	2009-02-20 20:46:01 UTC (rev 375)
@@ -13,20 +13,21 @@
 REM   limitations under the License.
 
 REM Dir to use as base for relative locations
-set WORKINGDIR=y:\sqlshell\sqlclient\
+set WORKINGDIR=y:\sqlshell\
 
 REM The directory where the JCurses jar and library are located.
 REM Please note that JCurses requires tje jcurses.jar and libjcurses.so to
 REM be located in the same directory.
-set JCURSES=%WORKINGDIR%\lib
 
 REM Where to find the SQLShell classes
-set SQLSHELL=%WORKINGDIR%\target\sqlshell-0.6.jar
+set SQLSHELL=%WORKINGDIR%\sqlshell.jar
 
-# REM providing drivers for the databases to support.
+REM providing drivers for the databases to support.
 set DRIVERS="%WORKINGDIR%\lib\hsqldb-1.8.0.jar"
 
 REM The classpath to use when running
-set CP=%WORKINGDIR%;%SQLSHELL%;%JCURSES%\jcurses.jar;%WORKINGDIR%\lib\charva\charva.jar;%WORKINGDIR%\lib\commons-logging.jar
+set CP=%WORKINGDIR%;%SQLSHELL%;%WORKINGDIR%\lib\jcurses\jcurses.jar;%WORKINGDIR%\lib\charva\charva.jar;%WORKINGDIR%\lib\commons-logging.jar
 
-java -Djava.library.path=%WORKINGDIR%\lib\charva -classpath %CP%;%DRIVERS% nl.improved.sqlclient.jcurses.SQLShell
+#windows source.. cleanup unix so files
+del %WORKINGDIR%\lib\jcurses\*.so
+java -Djava.library.path=%WORKINGDIR%\lib\charva;%WORKINGDIR%\lib\jcurses -classpath %CP%;%DRIVERS% nl.improved.sqlclient.SQLShell %*

Author: roy
Date: 2009-02-20 21:46:47 +0100 (Fri, 20 Feb 2009)
New Revision: 376

Modified:
   makejars.sh
Log:
make 0.7


Modified: makejars.sh
===================================================================
--- makejars.sh	2009-02-20 20:46:01 UTC (rev 375)
+++ makejars.sh	2009-02-20 20:46:47 UTC (rev 376)
@@ -1,6 +1,6 @@
 #!/bin/bash
 PROJECT=sqlshell
-VERSION=0.6
+VERSION=0.7
 
 #cleanup
 rm -Rf release
@@ -37,7 +37,7 @@
 cp ../src/main/resources/db.properties bin
 cp ../target/*.jar bin/${PROJECT}.jar
 cp -Rf ../lib bin
-cp -Rf ../windows bin
+#cp -Rf ../windows bin
 #cp -Rf ${HOME}/.m2/repository/hsqldb/hsqldb/1.8.0/hsqldb-1.8.0.jar bin/lib
 mkdir bin/db
 cp -Rf ../db/*.script bin/db

Author: roy
Date: 2009-02-20 21:53:57 +0100 (Fri, 20 Feb 2009)
New Revision: 377

Modified:
   ChangeLog
   makejars.sh
   pom.xml
Log:
0.6.2 mainenance release


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-02-20 20:46:47 UTC (rev 376)
+++ ChangeLog	2009-02-20 20:53:57 UTC (rev 377)
@@ -1,4 +1,4 @@
-0.7
+0.6.2 (2009-02-20)
  * Commandline input support
    * -engine option to switch between charva (default) and jcurses
  * Paged command output (no longer out of memory exceptions with large

Modified: makejars.sh
===================================================================
--- makejars.sh	2009-02-20 20:46:47 UTC (rev 376)
+++ makejars.sh	2009-02-20 20:53:57 UTC (rev 377)
@@ -1,6 +1,6 @@
 #!/bin/bash
 PROJECT=sqlshell
-VERSION=0.7
+VERSION=0.6.2
 
 #cleanup
 rm -Rf release

Modified: pom.xml
===================================================================
--- pom.xml	2009-02-20 20:46:47 UTC (rev 376)
+++ pom.xml	2009-02-20 20:53:57 UTC (rev 377)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.7-SNAPSHOT</version>
+  <version>0.6.2</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2009-03-01 17:46:31 +0100 (Sun, 01 Mar 2009)
New Revision: 388

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-03-01 14:22:52 UTC (rev 387)
+++ ChangeLog	2009-03-01 16:46:31 UTC (rev 388)
@@ -1,3 +1,8 @@
+0.7
+ * Rewritten tab completion engine
+   - improved group by and order by
+   - added support for aliases in table names
+
 0.6.2 (2009-02-20)
  * Commandline input support
    * -engine option to switch between charva (default) and jcurses

Author: roy
Date: 2009-09-18 13:55:18 +0200 (Fri, 18 Sep 2009)
New Revision: 417

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-09-18 11:44:47 UTC (rev 416)
+++ ChangeLog	2009-09-18 11:55:18 UTC (rev 417)
@@ -2,6 +2,7 @@
  * Rewritten tab completion engine
    - improved group by and order by
    - added support for aliases in table names
+ * Added initial settings command (to change for the current login session) the horizontal or vertical separator character
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2009-09-26 15:39:06 +0200 (Sat, 26 Sep 2009)
New Revision: 424

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-09-26 13:29:39 UTC (rev 423)
+++ ChangeLog	2009-09-26 13:39:06 UTC (rev 424)
@@ -4,6 +4,8 @@
    - added support for aliases in table names
  * Added initial settings command (to change for the current login session) the horizontal or vertical separator character
  * Added initial support for variables (in settings command.. see 'help set' for more information)
+ * History completion
+ * dump as <filename>  support added
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2009-12-08 10:46:14 +0100 (Tue, 08 Dec 2009)
New Revision: 429

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-12-08 09:45:35 UTC (rev 428)
+++ ChangeLog	2009-12-08 09:46:14 UTC (rev 429)
@@ -6,6 +6,8 @@
  * Added initial support for variables (in settings command.. see 'help set' for more information)
  * History completion
  * dump as <filename>  support added
+ * dump/read progress output added
+ * read autocommit (after every 1000 rows) setting added
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2009-12-17 22:55:24 +0100 (Thu, 17 Dec 2009)
New Revision: 447

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-12-17 21:55:16 UTC (rev 446)
+++ ChangeLog	2009-12-17 21:55:24 UTC (rev 447)
@@ -5,9 +5,12 @@
  * Added initial settings command (to change for the current login session) the horizontal or vertical separator character
  * Added initial support for variables (in settings command.. see 'help set' for more information)
  * History completion
- * dump as <filename>  support added
- * dump/read progress output added
- * read autocommit (after every 1000 rows) setting added
+* Dump / Read updates
+     - dump as <filename>  support added
+     - dump/read progress output added
+     - read autocommit (after every 10,000 rows) setting added
+     - set readAutoCommit=Y; to autocommit after successfull read (and every 10,000 rows)
+     - fix encoding problems
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2009-12-20 16:12:32 +0100 (Sun, 20 Dec 2009)
New Revision: 448

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-12-17 21:55:24 UTC (rev 447)
+++ ChangeLog	2009-12-20 15:12:32 UTC (rev 448)
@@ -8,9 +8,10 @@
 * Dump / Read updates
      - dump as <filename>  support added
      - dump/read progress output added
-     - read autocommit (after every 10,000 rows) setting added
+     - read autocommit (after every 100,000 rows) setting added
      - set readAutoCommit=Y; to autocommit after successfull read (and every 10,000 rows)
      - fix encoding problems
+     - fix for really large files (7934149 rows, 4,9G)
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2009-12-20 16:13:01 +0100 (Sun, 20 Dec 2009)
New Revision: 449

Modified:
   ChangeLog
Log:
mention change


Modified: ChangeLog
===================================================================
--- ChangeLog	2009-12-20 15:12:32 UTC (rev 448)
+++ ChangeLog	2009-12-20 15:13:01 UTC (rev 449)
@@ -11,7 +11,7 @@
      - read autocommit (after every 100,000 rows) setting added
      - set readAutoCommit=Y; to autocommit after successfull read (and every 10,000 rows)
      - fix encoding problems
-     - fix for really large files (7934149 rows, 4,9G)
+     - fix for really large files (tested 7,934,149 rows, 4,9G datafile)
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2010-01-24 14:24:57 +0100 (Sun, 24 Jan 2010)
New Revision: 456

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2010-01-24 13:23:17 UTC (rev 455)
+++ ChangeLog	2010-01-24 13:24:57 UTC (rev 456)
@@ -5,13 +5,15 @@
  * Added initial settings command (to change for the current login session) the horizontal or vertical separator character
  * Added initial support for variables (in settings command.. see 'help set' for more information)
  * History completion
-* Dump / Read updates
+ * Dump / Read updates
      - dump as <filename>  support added
      - dump/read progress output added
      - read autocommit (after every 100,000 rows) setting added
      - set readAutoCommit=Y; to autocommit after successfull read (and every 10,000 rows)
      - fix encoding problems
      - fix for really large files (tested 7,934,149 rows, 4,9G datafile)
+ * Paste long text breaking up into multiple lines fixes
+ * PageUp now shows last row of previous 'page'
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2010-01-24 15:35:18 +0100 (Sun, 24 Jan 2010)
New Revision: 462

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2010-01-24 14:35:05 UTC (rev 461)
+++ ChangeLog	2010-01-24 14:35:18 UTC (rev 462)
@@ -14,6 +14,7 @@
      - fix for really large files (tested 7,934,149 rows, 4,9G datafile)
  * Paste long text breaking up into multiple lines fixes
  * PageUp now shows last row of previous 'page'
+ * Added Set command to change settings and set variables that can be used in queries
 
 0.6.2 (2009-02-20)
  * Commandline input support

Author: roy
Date: 2010-01-28 08:44:16 +0100 (Thu, 28 Jan 2010)
New Revision: 465

Modified:
   /
   ChangeLog
   pom.xml
Log:
0.7 release



Property changes on: 
___________________________________________________________________
Name: svn:ignore
   - target
.BUGS.txt.swp

   + target
.BUGS.txt.swp
.ChangeLog.swp
.swp
.swo
.swm
.swn
.small.dmp.swp
.log.txt.swp
.log.txt.swo
.fix.sed.swp
.fix.swp
.tmp
.Test.java.swp
.test.dtd.swp
.test.xml.swp


Modified: ChangeLog
===================================================================
--- ChangeLog	2010-01-27 08:04:27 UTC (rev 464)
+++ ChangeLog	2010-01-28 07:44:16 UTC (rev 465)
@@ -1,4 +1,4 @@
-0.7
+0.7 (2010-01-28)
  * Rewritten tab completion engine
    - improved group by and order by
    - added support for aliases in table names

Modified: pom.xml
===================================================================
--- pom.xml	2010-01-27 08:04:27 UTC (rev 464)
+++ pom.xml	2010-01-28 07:44:16 UTC (rev 465)
@@ -19,7 +19,7 @@
   <groupId>nl.improved</groupId>
   <artifactId>sqlshell</artifactId>
   <packaging>jar</packaging>
-  <version>0.7-SNAPSHOT</version>
+  <version>0.7</version>
   <name>SQLShell ~ the improved sqlclient</name>
   <url>http://sqlshell.sourceforge.org</url>
   <build>

Author: roy
Date: 2010-03-08 21:34:54 +0100 (Mon, 08 Mar 2010)
New Revision: 469

Modified:
   ChangeLog
Log:
mention changes


Modified: ChangeLog
===================================================================
--- ChangeLog	2010-03-08 20:33:49 UTC (rev 468)
+++ ChangeLog	2010-03-08 20:34:54 UTC (rev 469)
@@ -1,5 +1,6 @@
 0.8
  * Fix using variables in dump command
+ * Added config setting ENTER_AT_END
 
 0.7 (2010-01-28)
  * Rewritten tab completion engine

Author: roy
Date: 2010-05-08 11:49:05 +0200 (Sat, 08 May 2010)
New Revision: 472

Modified:
   README
Log:
more stuff


Modified: README
===================================================================
--- README	2010-05-08 09:48:51 UTC (rev 471)
+++ README	2010-05-08 09:49:05 UTC (rev 472)
@@ -1,5 +1,8 @@
 INTENTION
-The intention of writing this sqlclient/sqlshell is to provide a common interface to different databases we use in our company. But most important is that the interface to a commercial client we use is really not very usefull. Our goal is to add as many features as we can think of to this small utility class so that our daily work is made a lot easier. The initial functionality should contain:
+The intention of writing this sqlclient/sqlshell is to provide a common interface to different databases we use
+in our company. But most important is that the interface to a commercial client we use is really
+not very usefull. Our goal is to add as many features as we can think of to this small utility class
+so that our daily work is made a lot easier. The initial functionality should contain:
 - sql command history (key up/down)
 - tab completion (at least for select queries)
 - execute a sql file (@mystatements.sql)
@@ -20,7 +23,7 @@
 
 With Charva
 In order to run sqlshell using charva you need to have the charva libraries in the lib folder.
-Currently charva is compiled for windows (32 bits) and linux intel 32 bits and amd 64 bits. If you don't
+Currently charva is compiled for windows (32 bits) and linux intel 32 and 64 bits and amd 64 bits. If you don't
 own an intel 32 bits, you need to modify the contents of the lib/charva directory.
 
 With JCurses

Author: roy
Date: 2010-05-08 11:50:38 +0200 (Sat, 08 May 2010)
New Revision: 473

Modified:
   ChangeLog
Log:
mention change


Modified: ChangeLog
===================================================================
--- ChangeLog	2010-05-08 09:49:05 UTC (rev 472)
+++ ChangeLog	2010-05-08 09:50:38 UTC (rev 473)
@@ -1,6 +1,7 @@
 0.8
  * Fix using variables in dump command
  * Added config setting ENTER_AT_END
+ * Fix for databases where after invalid query the connection is in an invalid state (like Postgresql)
 
 0.7 (2010-01-28)
  * Rewritten tab completion engine

Author: roy
Date: 2010-05-08 12:32:22 +0200 (Sat, 08 May 2010)
New Revision: 476

Modified:
   ChangeLog
Log:
mention change


Modified: ChangeLog
===================================================================
--- ChangeLog	2010-05-08 10:31:50 UTC (rev 475)
+++ ChangeLog	2010-05-08 10:32:22 UTC (rev 476)
@@ -2,6 +2,7 @@
  * Fix using variables in dump command
  * Added config setting ENTER_AT_END
  * Fix for databases where after invalid query the connection is in an invalid state (like Postgresql)
+ * Fix case sensitivity in 'show tables having...'
 
 0.7 (2010-01-28)
  * Rewritten tab completion engine