dynamobi/dynamobi — Issue #352: [FRG-422] sqllineClient displays full stack trace on error
Author: dynamobi-build
Created: 2011-12-30 03:09:33+00:00
State: open
Labels: FRG, Statement Processing

[reporter="ksecretan", created="Tue, 14 Jun 2011 16:27:52 -0500 (GMT-05:00)"]
If a command is run through sqllineEngine, only the top-level error message is displayed which is what we want by default. However, if farragoServer is run and the command passed through sqllineClient, the full stack trace is printed. None of the !set options affect this behavior.

$ ./sqllineEngine

Connecting to jdbc:farrago:

Connected to: Eigenbase Data Management System (version 0.0.0.14371)

Driver: FarragoJdbcDriver (version 0.0)

Autocommit status: true

Transaction isolation: TRANSACTION_REPEATABLE_READ

sqlline version 1.0.8-eb by Marc Prud'hommeaux

0: jdbc:farrago:> select * from sys_root.dba_schemas;

Error: From line 1, column 15 to line 1, column 34: Table 'SYS_ROOT.DBA_SCHEMAS' not found (state=,code=0)

$ ./sqllineClient

Connecting to jdbc:farrago:http://localhost;sessionName='sqllineClient:kevin@workbuntu'

Connected to: Eigenbase Data Management System (version 0.0.0.14371)

Driver: FarragoJdbcDriver (version 0.0)

Autocommit status: true

Transaction isolation: TRANSACTION_REPEATABLE_READ

sqlline version 1.0.8-eb by Marc Prud'hommeaux

0: jdbc:farrago:http://localhost> select * from sys_root.dba_schemas;

Error: net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: From line 1, column 15 to line 1, column 34: Table 'SYS_ROOT.DBA_SCHEMAS' not found

at org.eigenbase.resource.EigenbaseResource$_Def12.ex(EigenbaseResource.java:1026)

at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:744)

at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:731)

at org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3818)

at org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:82)

at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:94)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:812)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:800)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2788)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2773)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3030)

at org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:73)

at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:94)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:812)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:800)

at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:159)

at org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:763)

at org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:457)

at net.sf.farrago.query.FarragoSqlValidator.validate(FarragoSqlValidator.java:100)

at net.sf.farrago.db.FarragoDatabase.prepareStmtImpl(FarragoDatabase.java:1036)

at net.sf.farrago.db.FarragoDatabase.prepareStmt(FarragoDatabase.java:956)

at net.sf.farrago.db.FarragoDbSession.prepareImpl(FarragoDbSession.java:1272)

at net.sf.farrago.db.FarragoDbSession.prepare(FarragoDbSession.java:1197)

at net.sf.farrago.db.FarragoDbStmtContext.prepare(FarragoDbStmtContext.java:130)

at net.sf.farrago.jdbc.engine.FarragoJdbcEngineStatement.execute(FarragoJdbcEngineStatement.java:111)

at de.simplicit.vjdbc.command.StatementExecuteCommand.execute(StatementExecuteCommand.java:34)

at de.simplicit.vjdbc.server.command.ConnectionEntry.executeCommand(ConnectionEntry.java:166)

at de.simplicit.vjdbc.server.command.CommandProcessor.process(CommandProcessor.java:180)

at net.sf.farrago.server.FarragoServletCommandSink.handleRequest(FarragoServletCommandSink.java:125)

at net.sf.farrago.server.FarragoServletCommandSink.doPost(FarragoServletCommandSink.java:91)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:530)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:427)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)

at org.eclipse.jetty.server.session.SessionHandler.handle(SessionHandler.java:182)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:933)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:362)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113)

at org.eclipse.jetty.server.Server.handle(Server.java:334)

at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559)

at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007)

at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747)

at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203)

at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462)

at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436)

at java.lang.Thread.run(Thread.java:662) (state=,code=0)