SmallSQL Database

This version include the follow bug fixes:- Fix bugs with the methods isBeforeFirst(), isFirst(), isLast() and isAfterLast(). The problems occur mostly with empty ResultSets and together with ORDER BY or GROUP BY.- Fix the scrolling of scrollable ... [More] , updatable ResultSets with inserted rows.- Signal inserted and rollbacked rows as deleted (method rowDeleted()).- A NullPointerException with flag create=true was fixed.- Check the range of the parsed date time parts now.- Double columns in a table are now prevented. It was possible with CREATE TABLE and ALTER TABLE to create doubled columns.- Unicode characters are possible in JDBC URL parameters now.- The method getPropertyInfo is implemented now. (0 comments) [Less]

This version include the follow bug fixes: - Fix bugs with the methods isBeforeFirst(), isFirst(), isLast() and isAfterLast(). The problems occur mostly with empty ResultSets and together with ORDER BY or GROUP BY. - Fix the scrolling of scrollable ... [More] , updatable ResultSets with inserted rows. - Signal inserted and rollbacked rows as deleted (method rowDeleted()). - A NullPointerException with flag create=true was fixed. - Check the range of the parsed date time parts now. - Double columns in a table are now prevented. It was possible with CREATE TABLE and ALTER TABLE to create doubled columns. - Unicode characters are possible in JDBC URL parameters now. - The method getPropertyInfo is implemented now. [Less]

This version of the SmallSQL Database supports ALTER TABLE. And it include the follow bug fixes and changes: - STUFF as alias for the INSERT SQL function added. - A reading bug of DateTime values with daylight saving was fixed. - A SQL parser bug ... [More] with cross joins and aliases was fixed. Now also the second table can have an alias (bug 1624376). - Support for the method relative, absolute, isBeforeFirst and isFirst for Scrollable ResultSets with ORDER BY was added (bug 1625080). - Now a "SELECT TOP 0 ..." returns 0 rows instead of all rows (bug 1629244). - A bug with LIKE and the wildcard % at end of the pattern was fixed (bug 1647564). - The driver ignores now right blanks if a CHAR value is compared with a VARCHAR value (bug 1654121). [Less]

This version of the SmallSQL Database supports ALTER TABLE.And it include the follow bug fixes and changes:- STUFF as alias for the INSERT SQL function added.- A reading bug of DateTime values with daylight saving was fixed.- A SQL parser bug with ... [More] cross joins and aliases was fixed. Now also the second table can have an alias (bug 1624376).- Support for the method relative, absolute, isBeforeFirst and isFirst for Scrollable ResultSets with ORDER BY was added (bug 1625080).- Now a "SELECT TOP 0 ..." returns 0 rows instead of all rows (bug 1629244).- A bug with LIKE and the wildcard % at end of the pattern was fixed (bug 1647564).- The driver ignores now right blanks if a CHAR value is compared with a VARCHAR value (bug 1654121). (0 comments) [Less]

This version of the SmallSQL Database supports ALTER TABLE. And it include the follow bug fixes and changes: - STUFF as alias for the INSERT SQL function added. - A reading bug of DateTime values with daylight saving was fixed. - A SQL parser bug ... [More] with cross joins and aliases was fixed. Now also the second table can have an alias (bug 1624376). - Support for the method relative, absolute, isBeforeFirst and isFirst for Scrollable ResultSets with ORDER BY was added (bug 1625080). - Now a "SELECT TOP 0 ..." returns 0 rows instead of all rows (bug 1629244). - A bug with LIKE and the wildcard % at end of the pattern was fixed (bug 1647564). - The driver ignores now right blanks if a CHAR value is compared with a VARCHAR value (bug 1654121). [Less]

This version of the SmallSQL Database supports ALTER TABLE.And it include the follow bug fixes and changes:- STUFF as alias for the INSERT SQL function added.- A reading bug of DateTime values with daylight saving was fixed.- A SQL parser bug with ... [More] cross joins and aliases was fixed. Now also the second table can have an alias (bug 1624376).- Support for the method relative, absolute, isBeforeFirst and isFirst for Scrollable ResultSets with ORDER BY was added (bug 1625080).- Now a "SELECT TOP 0 ..." returns 0 rows instead of all rows (bug 1629244).- A bug with LIKE and the wildcard % at end of the pattern was fixed (bug 1647564).- The driver ignores now right blanks if a CHAR value is compared with a VARCHAR value (bug 1654121). (0 comments) [Less]

This version of the SmallSQL Database include a Command Line interface/tool. You can start it with: java -jar smallsql.jar Now you does not need a GUI tool to make some changes on the database. And it include the follow bug fixes: - A ... [More] ConcurrentModificationException was fixed on Connection.close(). - A call of getMoreResults() has not change the results from getUpdateCount() and getResultSet(). [Less]

This version of the SmallSQL Database include a Command Line interface/tool. You can start it with:java -jar smallsql.jarNow you does not need a GUI tool to make some changes on the database.And it include the follow bug fixes:- A ... [More] ConcurrentModificationException was fixed on Connection.close().- A call of getMoreResults() has not change the results from getUpdateCount() and getResultSet(). (0 comments) [Less]

This version of the SmallSQL Database include a Command Line interface/tool. You can start it with:java -jar smallsql.jarNow you does not need a GUI tool to make some changes on the database.And it include the follow bug fixes:- A ... [More] ConcurrentModificationException was fixed on Connection.close().- A call of getMoreResults() has not change the results from getUpdateCount() and getResultSet(). (0 comments) [Less]

This version of the SmallSQL Database include a Command Line interface/tool. You can start it with: java -jar smallsql.jar Now you does not need a GUI tool to make some changes on the database. And it include the follow bug fixes: - A ... [More] ConcurrentModificationException was fixed on Connection.close(). - A call of getMoreResults() has not change the results from getUpdateCount() and getResultSet(). [Less]