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

  1. 0

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

    Stack Overflow | 2 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 | 2 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

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

    Stack Overflow | 5 months ago | Guyb
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'searcherdb.hibernate_sequence' doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Does Citadel setup the db's itself?

    GitHub | 12 months ago | ttk2
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'pumpkin.reinforcement_id' doesn't exist
  6. 0

    JPA is not accepting @table(name = "table")

    Stack Overflow | 10 months ago | vertuso
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'Feedback.coach_mark' doesn't exist

  1. Kialandei 1 times, last 2 weeks ago
  2. MoYapro 1 times, last 2 weeks ago
  3. tvrmsmith 6 times, last 3 weeks ago
  4. linxiaolong 2 times, last 1 month ago
  5. DoktorDoener666 9 times, last 1 month ago
27 more registered users
68 unregistered visitors
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