The required -user argument is: -user '""', that is single quotes surrounding the empty double quotes. No -password argument is required.
PS F:\> java -cp b:/h2.jar org.h2.tools.Script -url jdbc:h2:file:junk -user '""' -script backup/junk.sql or PS F:\> java -cp b:/h2.jar org.h2.tools.Script -url jdbc:h2:file:junk -user '""' -script backup/junk.zip -options compression zip if you want it zipped On Wednesday, August 28, 2013 10:26:08 AM UTC-7, Peter wrote: > > h2-1.3.173.jar > Windows 7, Powershell and Cmd > > I created a H2 database in a java pgm without a username or password. The > file opens fine in H2 console (or anything else) by just leaving the > username and password fields blank but I cannot get Script or Shell to open > it correctly. The issue seems to be how to correctly specify blank user > name and password. Are these supported in the Script and Shell command line > tools? > > For example, when I try to run the following cmd in a Powershell (or cmd) > window in the same directory as the h2 db file, I get Wrong user name or > password error. > > PS F:\> java -cp b:/h2.jar org.h2.tools.Script -url jdbc:h2:file:test-db > -script backup/test-db.2013.08.28.sql > Exception in thread "main" org.h2.jdbc.JdbcSQLException: Wrong user name > or password [28000-173] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:331) > at org.h2.message.DbException.get(DbException.java:171) > at org.h2.message.DbException.get(DbException.java:148) > at org.h2.message.DbException.get(DbException.java:137) > at org.h2.engine.Engine.validateUserAndPassword(Engine.java:302) > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:147) > at org.h2.engine.Engine.createSession(Engine.java:122) > at org.h2.engine.Engine.createSession(Engine.java:28) > at > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:313) > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) > at org.h2.Driver.connect(Driver.java:73) > at java.sql.DriverManager.getConnection(DriverManager.java:579) > at java.sql.DriverManager.getConnection(DriverManager.java:221) > at org.h2.tools.Script.execute(Script.java:157) > at org.h2.tools.Script.execute(Script.java:136) > at org.h2.tools.Script.runTool(Script.java:104) > at org.h2.tools.Script.main(Script.java:53) > > > Using -user "" -password "" does not seem to work either: > > PS F:\> java -cp b:/h2.jar org.h2.tools.Script -url jdbc:h2:file:test-db > -user ""-password "" -script backup/test-db.2013.08.28.sql > Exception in thread "main" org.h2.jdbc.JdbcSQLException: Wrong user name > or password [28000-173] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:331) > at org.h2.message.DbException.get(DbException.java:171) > at org.h2.message.DbException.get(DbException.java:148) > at org.h2.message.DbException.get(DbException.java:137) > at org.h2.engine.Engine.validateUserAndPassword(Engine.java:302) > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:147) > at org.h2.engine.Engine.createSession(Engine.java:122) > at org.h2.engine.Engine.createSession(Engine.java:28) > at > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:313) > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) > at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) > at org.h2.Driver.connect(Driver.java:73) > at java.sql.DriverManager.getConnection(DriverManager.java:579) > at java.sql.DriverManager.getConnection(DriverManager.java:221) > at org.h2.tools.Script.execute(Script.java:157) > at org.h2.tools.Script.execute(Script.java:136) > at org.h2.tools.Script.runTool(Script.java:104) > at org.h2.tools.Script.main(Script.java:53) > > The database file is definitely being found as I get a lock error if I > keep it open in Console and try one of the above. > Thanks for the help, Peter > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
