Can't run test_runner.bat

[john1234]

Hello,

i have download smartgwt trial version. When i start test_runner.bat after a while i get the following error

=== 2014-07-13 03:05:39,987 [main] DEBUG SQLConnectionManager - About to close J
DBCConnection with hashcode "31568925"
Exception in thread "main" java.sql.SQLSyntaxErrorException: user lacks privileg
e or object not found: BATCHRUN
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
        at com.isomorphic.sql.SQLDriver.getPreparedStatement(SQLDriver.java:907)

        at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:833)
        at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:791)
        at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:961)
        at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.ja
va:571)
        at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1963)
        at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:44
4)
        at com.isomorphic.sql.SQLDataSource.executeAdd(SQLDataSource.java:397)
        at com.isomorphic.datasource.DataSource.execute(DataSource.java:1544)
        at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.
java:723)
        at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:6
58)
        at com.isomorphic.application.AppBase.execute(AppBase.java:491)
        at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2534)
        at com.isomorphic.autotest.BatchRunDao.add(BatchRunDao.java:73)
        at com.isomorphic.autotest.TestRunner.createBatchRunRecord(TestRunner.ja
va:340)
        at com.isomorphic.autotest.TestRunnerLauncher.launch(TestRunnerLauncher.
java:355)
        at com.isomorphic.autotest.TestRunnerLauncher.launch(TestRunnerLauncher.
java:765)
        at com.isomorphic.autotest.TestRunner.main(TestRunner.java:146)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: B
ATCHRUN
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.SchemaManager.getTable(Unknown Source)
        at org.hsqldb.ParserDQL.readTableName(Unknown Source)
        at org.hsqldb.ParserDQL.readRangeVariableForDataChange(Unknown Source)
        at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
        at org.hsqldb.ParserCommand.compilePart(Unknown Source)
        at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
        at org.hsqldb.Session.compileStatement(Unknown Source)
        at org.hsqldb.StatementManager.compile(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)
        ... 20 more

Any help? Thanks in advance!

[Isomorphic]

See the FAQ at the bottom of the TestRunner docs http://www.smartclient.com/smartgwt/...estRunner.html

Q: When I run TestRunner, TestRunner fails reporting that DataSource BatchRun or TestResult cannot be found.

[john1234]

Can you give me a step-by-step instructions on how i can import the data you mention? I don't see any folder "showcase/tools/adminConsole.jsp".

[Isomorphic]

You can call SC.openDataSourceConsole() from any SmartGWT project

[john1234]

When i try to run "http://localhost:8080/tools/adminConsole.jsp?target=dsImporter" from SmartGWT i get the following exception

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to load class for JSP
	org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:599)
	org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:141)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.lang.ClassNotFoundException: org.apache.jsp.tools.adminConsole_jsp
	java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	java.security.AccessController.doPrivileged(Native Method)
	java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:134)
	org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
	org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:597)
	org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:141)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.
Apache Tomcat/5.5.23

[john1234]

bump
+10chars