AnsweredAssumed Answered

Encountered JDBC errors while trying to query the database

Question asked by zjyi on Jan 26, 2013
Latest reply on Jan 28, 2013 by santosh
Hey gurus,

MYSQL, HIVE, hive-site.xml and the JDBC driver has been installed and configured.
However, when i try to execute hive commands it throws this exception error:

<pre>
2013-01-26 18:52:16,662 ERROR com.mapr.adminuiapp.controllers.JobManagerController sendErrors [413918804@qtp0-2]: com.mapr.adminuiapp.jobmanagement.common.JobManagementException: Encountered JDBC errors while trying to query the database. Please look at '/opt/mapr/logs/adminuiapp.log' file on host: 'ip-10-80-93-189' for details.
2013-01-26 18:52:16,662 ERROR com.mapr.adminuiapp.controllers.JobManagerController service [368345698@qtp0-0]: An Exception occurred:Encountered JDBC errors while trying to query the database. Please look at '/opt/mapr/logs/adminuiapp.log' file on host: 'ip-10-80-93-189' for details.
com.mapr.adminuiapp.jobmanagement.common.JobManagementException: Encountered JDBC errors while trying to query the database. Please look at '/opt/mapr/logs/adminuiapp.log' file on host: 'ip-10-80-93-189' for details.
at com.mapr.adminuiapp.common.HibernateUtil.executeQuery(HibernateUtil.java:138)
at com.mapr.adminuiapp.jobmanagement.hibernate.HibernateJobRepository.getMatchingJobs(HibernateJobRepository.java:168)
at com.mapr.adminuiapp.jobmanagement.query.exec.JobQueryProcessor.executeBarQuery(JobQueryProcessor.java:190)
at com.mapr.adminuiapp.jobmanagement.query.exec.AbstractQueryProcessor.executeQuery(AbstractQueryProcessor.java:23)
at com.mapr.adminuiapp.controllers.JobManagerController.service(JobManagerController.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1124)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
at org.mortbay.jetty.handler.HandlerList.handle(HandlerList.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:741)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:213)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
at org.mortbay.jetty.security.SslSocketConnector$SslConnection.run(SslSocketConnector.java:636)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522)
2013-01-26 18:52:16,663 ERROR com.mapr.adminuiapp.controllers.JobManagerController sendErrors [368345698@qtp0-0]: com.mapr.adminuiapp.jobmanagement.common.JobManagementException: Encountered JDBC errors while trying to query the database. Please look at '/opt/mapr/logs/adminuiapp.log' file on host: 'ip-10-80-93-189' for details.
`

Outcomes