H2 Shell throws NumberFormatException

[GoogleCodeExporter]

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)

java -cp h2-1.2.132.jar org.h2.tools.Shell -url jdbc:h2:test

Welcome to H2 Shell 1.2.132 (2010-03-21)
Exit with Ctrl+C
Commands are case insensitive; SQL statements end with ';'
help or ?      Display this help
list           Toggle result list / stack trace mode
maxwidth       Set maximum column width (default is 100)
show           List all tables
describe       Describe a table
history        Show the last 20 statements
quit or exit   Close the connection and exit

sql> ;
Exception: java.lang.NumberFormatException: For input string: ""
java.lang.NumberFormatException: For input string: ""
    at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
    at java.lang.Integer.parseInt(Integer.java:468)
    at java.lang.Integer.parseInt(Integer.java:497)
    at org.h2.tools.Shell.promptLoop(Shell.java:270)
    at org.h2.tools.Shell.runTool(Shell.java:136)
    at org.h2.tools.Shell.main(Shell.java:74)
Connection closed

What is the expected output? What do you see instead?

sql> ;
(Update count: 0, x ms)

What version of the product are you using? On what operating system, file
system, and virtual machine?

h2-1.2.132.jar

Do you know a workaround?

input at least a white space.

How important/urgent is the problem for you?

not so important.

In your view, is this a defect or a feature request?

defect

Best Regards

Original issue reported on code.google.com by litail...@gmail.com on 4 Apr 2010 at 7:12

[GoogleCodeExporter]

Thanks! I will fix it in the next release.

Original comment by thomas.t...@gmail.com on 4 Apr 2010 at 7:22

• Changed state: Accepted

[GoogleCodeExporter]

Fixed in version 1.2.133

Original comment by thomas.t...@gmail.com on 10 Apr 2010 at 8:46

• Changed state: Fixed