The only problem is the output.txt file is empty. It doesn't show the results of the sql script that is executed if there are no errors. Is there a way to get the output from running the sql script?
On Feb 1, 12:36 pm, gabjos <[email protected]> wrote: > I did this and it worked > > java -classpath "C:\program files\test\Load\lib\h2.jar" > org.h2.tools.RunScript -url jdbc:h2:tcp://localhost:1521/test -user > <username> -password <password> -script "C:\Documents and Settings > \Desktop\ESS.sql" > "C:\Documents and Settings\Desktop\output.txt" > 2>&1 > > On Jan 30, 1:19 pm, gabjos <[email protected]> wrote: > > > > > How would I put h2 jar in the classpath? > > > On Jan 29, 4:45 pm, Brian <[email protected]> wrote: > > > > Yes, your example should work if your h2 jar file is in the CLASSPATH > > > already > > > > On Jan 29, 10:33 am, gabjos <[email protected]> wrote: > > > > > can I execute this line in a .bat file > > > > java org.h2.tools.RunScript -url jdbc:h2:tcp://localhost:1521/test - > > > > user test_usr -script C:\tmp\ESS.sql > ESS.log- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
