org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT prof.user_profile_id, prof.user_id, prof.first_name, prof.last_name FROM (SELECT inner_prof.user_profile_id, inner_prof.user_id, inner_prof.first_name, inner_prof.last_name FROM titans.user_profile AS inner_prof WHERE user_id = 1) AS prof ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'titans.*' doesn't exist

tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Spring JDBC Template can't execute Queries containing nested Query in the FROM clause

    Stack Overflow | 5 months ago | Muhammed Zubairuddin
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT prof.user_profile_id, prof.user_id, prof.first_name, prof.last_name FROM (SELECT inner_prof.user_profile_id, inner_prof.user_id, inner_prof.first_name, inner_prof.last_name FROM titans.user_profile AS inner_prof WHERE user_id = 1) AS prof ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'titans.*' doesn't exist
  2. 0

    Spring JDBC Template can't execute Queries containing nested Query in the FROM clause

    Stack Overflow | 5 months ago | Muhammed Zubairuddin
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT prof.user_profile_id, prof.user_id, prof.first_name, prof.last_name FROM (SELECT inner_prof.user_profile_id, inner_prof.user_id, inner_prof.first_name, inner_prof.last_name FROM titans.user_profile AS inner_prof WHERE user_id = 1) AS prof ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'titans.*' doesn't exist
  3. 0

    Exception trying to clone database with Hibernate

    Stack Overflow | 2 months ago | Twinkle Soni
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SHOW TABLES IN crm_prod]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'TABLE_NAMES' in information_schema
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spring 4.3.0.RELEASE + Hibernate 5.2.0.Final - GeneratedValue on mysql

    Stack Overflow | 8 months ago | Guyb
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'searcherdb.hibernate_sequence' doesn't exist
  6. 0

    GitHub comment 2337#247908619

    GitHub | 5 months ago | Turbovix
    com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Table 'titans.*' doesn't exist

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    4 frames
  3. MySQL jdbc
    ResultSetMetaData.isCaseSensitive
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
    2. com.mysql.jdbc.Util.getInstance(Util.java:360)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
    10. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
    11. com.mysql.jdbc.Field.getCollation(Field.java:448)
    12. com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:549)
    12 frames
  4. Java RT
    CachedRowSetImpl.populate
    1. com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:722)
    2. com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:639)
    2 frames
  5. Spring Framework
    JdbcTemplate.queryForRowSet
    1. org.springframework.jdbc.core.SqlRowSetResultSetExtractor.createSqlRowSet(SqlRowSetResultSetExtractor.java:79)
    2. org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:62)
    3. org.springframework.jdbc.core.SqlRowSetResultSetExtractor.extractData(SqlRowSetResultSetExtractor.java:45)
    4. org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)
    5. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
    6. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
    7. org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
    7 frames
  6. com.titansinc.user
    UserService.getUserProfileByUserID
    1. com.titansinc.user.dsp.impl.UserDSP.getUserProfileByUserID(UserDSP.java:188)
    2. com.titansinc.user.service.UserService.getUserProfileByUserID(UserService.java:36)
    2 frames
  7. controllers.com.titans
    Application.testReadMethod
    1. controllers.com.titans.play.controllers.Application.testReadMethod(Application.java:40)
    1 frame
  8. Unknown
    Routes$$anonfun$routes$1$$anonfun$applyOrElse$6$$anonfun$apply$24.apply
    1. Routes$$anonfun$routes$1$$anonfun$applyOrElse$6$$anonfun$apply$24.apply(routes_routing.scala:141)
    2. Routes$$anonfun$routes$1$$anonfun$applyOrElse$6$$anonfun$apply$24.apply(routes_routing.scala:141)
    2 frames
  9. Play
    JavaAction$$anonfun$11.apply
    1. play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264)
    2. play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255)
    3. play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55)
    4. play.GlobalSettings$1.call(GlobalSettings.java:67)
    5. play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82)
    6. play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82)
    6 frames
  10. Scala
    Future$PromiseCompletingRunnable.run
    1. scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
    2. scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
    2 frames
  11. Play
    HttpExecutionContext$$anon$2.run
    1. play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40)
    1 frame
  12. Play Iteratees
    Execution$trampoline$.execute
    1. play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46)
    1 frame
  13. Play
    HttpExecutionContext.execute
    1. play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32)
    1 frame
  14. Scala
    Future$.apply
    1. scala.concurrent.impl.Future$.apply(Future.scala:31)
    2. scala.concurrent.Future$.apply(Future.scala:492)
    2 frames
  15. Play
    Action$$anonfun$apply$1$$anonfun$apply$4.apply
    1. play.core.j.JavaAction$class.apply(JavaAction.scala:82)
    2. play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252)
    3. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130)
    4. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130)
    5. play.utils.Threads$.withContextClassLoader(Threads.scala:21)
    6. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129)
    7. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128)
    7 frames
  16. Scala
    Option.map
    1. scala.Option.map(Option.scala:145)
    1 frame
  17. Play
    Action$$anonfun$apply$1.apply
    1. play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128)
    2. play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121)
    2 frames
  18. Play Iteratees
    Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply
    1. play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483)
    2. play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483)
    3. play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519)
    4. play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519)
    5. play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496)
    6. play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496)
    6 frames
  19. Scala
    Future$PromiseCompletingRunnable.run
    1. scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
    2. scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
    2 frames
  20. Akka Actor
    ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec
    1. akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
    2. akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)
    2 frames
  21. Scala
    ForkJoinWorkerThread.run
    1. scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
    2. scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
    3. scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
    4. scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
    4 frames