org.hibernate.exception.SQLGrammarException: could not execute query

Google Groups | Mr. DingSauce | 4 years ago
  1. 0

    prodDb.properties issue

    Google Groups | 4 years ago | Mr. DingSauce
    org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    Exception when generating report

    GitHub | 6 months ago | tbitowt
    com.querydsl.core.QueryException: Caught SQLException for select project.pname as projectName, project.pkey as projectKey, (project.pkey || ? || cast(issue.issuenum as varchar(10))) as issueKey, issue.summary as issueSummary, issue.id as issueId, issuetype.pname as issueTypeName, issuetype.iconurl as issueTypeIconUrl, issuetype.avatar as issueAvatarId, issuestatus.pname as issueStatusName, (case when exists (select cwdUserExists.display_name from PUBLIC.cwd_user cwdUserExists left join PUBLIC.app_user appUserExists on appUserExists.lower_user_name = cwdUserExists.lower_user_name left join PUBLIC.cwd_directory cwdDirectoryExists on cwdUserExists.directory_id = cwdDirectoryExists.id where appUserExists.user_key = issue.assignee order by cwdDirectoryExists.directory_position asc limit ?) then (select case when issueUser.display_name is not null then issueUser.display_name else issue.assignee end from PUBLIC.cwd_user issueUser left join PUBLIC.app_user appUserForIssue on appUserForIssue.lower_user_name = issueUser.lower_user_name left join PUBLIC.cwd_directory cwdDirectoryForIssue on issueUser.directory_id = cwdDirectoryForIssue.id where appUserForIssue.user_key = issue.assignee order by cwdDirectoryForIssue.directory_position asc limit ?) else issue.assignee end) as issueAssignee, issue.timeoriginalestimate as issueOriginalEstimate, issue.timeestimate as issueRemainingEstimate, worklog.worklogbody as worklogBody, worklog.timeworked as worklogTimeWorked, project.description as projectDescription, priority.pname as priorityName, priority.iconurl as priorityIconUrl, (case when exists (select cwdUserExists.display_name from PUBLIC.cwd_user cwdUserExists left join PUBLIC.app_user appUserExists on appUserExists.lower_user_name = cwdUserExists.lower_user_name left join PUBLIC.cwd_directory cwdDirectoryExists on cwdUserExists.directory_id = cwdDirectoryExists.id where appUserExists.user_key = issue.reporter order by cwdDirectoryExists.directory_position asc limit ?) then (select case when issueUser.display_name is not null then issueUser.display_name else issue.reporter end from PUBLIC.cwd_user issueUser left join PUBLIC.app_user appUserForIssue on appUserForIssue.lower_user_name = issueUser.lower_user_name left join PUBLIC.cwd_directory cwdDirectoryForIssue on issueUser.directory_id = cwdDirectoryForIssue.id where appUserForIssue.user_key = issue.reporter order by cwdDirectoryForIssue.directory_position asc limit ?) else issue.reporter end) as issueReporter, issue.created as issueCreated, issue.updated as issueUpdated, resolution.pname as resolutionName, worklog.startdate as worklogStartDate, worklog.created as worklogCreated, worklog.updated as worklogUpdated, (case when exists (select cwdUserExists.display_name from PUBLIC.cwd_user cwdUserExists left join PUBLIC.app_user appUserExists on appUserExists.lower_user_name = cwdUserExists.lower_user_name left join PUBLIC.cwd_directory cwdDirectoryExists on cwdUserExists.directory_id = cwdDirectoryExists.id where appUserExists.user_key = worklog.author order by cwdDirectoryExists.directory_position asc limit ?) then (select case when issueUser.display_name is not null then issueUser.display_name else worklog.author end from PUBLIC.cwd_user issueUser left join PUBLIC.app_user appUserForIssue on appUserForIssue.lower_user_name = issueUser.lower_user_name left join PUBLIC.cwd_directory cwdDirectoryForIssue on issueUser.directory_id = cwdDirectoryForIssue.id where appUserForIssue.user_key = worklog.author order by cwdDirectoryForIssue.directory_position asc limit ?) else worklog.author end) as worklogUser from PUBLIC.worklog worklog join PUBLIC.jiraissue issue on worklog.issueid = issue.id join PUBLIC.project project on issue.project = project.id join PUBLIC.issuetype issuetype on issue.issuetype = issuetype.id join PUBLIC.issuestatus issuestatus on issue.issuestatus = issuestatus.id join PUBLIC.priority priority on issue.priority = priority.id left join PUBLIC.resolution resolution on issue.resolution = resolution.id where 1 = 1 and project.id in (?, ?) and worklog.startdate >= ? and worklog.startdate < ? order by project.pkey || ? || cast(issue.issuenum as varchar(10)) asc, worklog.startdate asc limit ? offset ?
  3. 0

    Spring 4 and Hibernate 4 - GenericJDBCException: could not prepare statement

    Stack Overflow | 3 years ago | Kyle Walker
    org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into Customer (customerId, address, dateOfBirth, email, firstName, lastName, middleName, phone) values (null, ?, ?, ?, ?, ?, ?, ?)]; SQL state [IM001]; error code [-20]; could not prepare statement; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Struts 1.3.10 javax.servlet.UnavailableException :: 4programmers.net

    4programmers.net | 1 year ago
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'loginDao' defined in ServletContext resource [/WEB-INF/beans.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    Spring 4 and Hibernate 4 - could not prepare statement - Tech Forum Network

    techforumnetwork.com | 11 months ago
    org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into Customer (customerId, address, dateOfBirth, email, firstName, lastName, middleName, phone) values (null, ?, ?, ?, ?, ?, ?, ?)]; SQL state [IM001]; error code [-20]; could not prepare statement; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement

    8 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. java.sql.SQLException

      Table not found in statement [select this_.id as id0_0_, this_.version as version0_0_, this_.description as descript3_0_0_, this_.email as email0_0_, this_.email_show as email5_0_0_, this_.enabled as enabled0_0_, this_.last_login as last7_0_0_, this_.prev_login as prev8_0_0_, this_.user_real_name as user9_0_0_, this_.username as username0_0_ from person this_ where this_.username=?]

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcConnection.prepareStatement
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
      3. org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
      3 frames
    3. Commons DBCP
      PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement
      1. org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
      2. org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
      2 frames
    4. Unknown
      BootStrap$_closure1.doCall
      1. $Proxy12.prepareStatement(Unknown Source)
      2. BootStrap.createNewUser(BootStrap.groovy:642)
      3. BootStrap.this$2$createNewUser(BootStrap.groovy)
      4. BootStrap$_closure1.doCall(BootStrap.groovy:112)
      4 frames
    5. Grails
      Environment.executeForCurrentEnvironment
      1. grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:251)
      2. grails.util.Environment.executeForEnvironment(Environment.java:244)
      3. grails.util.Environment.executeForCurrentEnvironment(Environment.java:220)
      3 frames
    6. Jetty
      XmlConfiguration$1.run
      1. org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:781)
      2. org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:425)
      3. org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:773)
      4. org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:275)
      5. org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1321)
      6. org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:725)
      7. org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:490)
      8. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)
      9. org.eclipse.jetty.util.component.ContainerLifeCycle.addBean(ContainerLifeCycle.java:279)
      10. org.eclipse.jetty.util.component.ContainerLifeCycle.addBean(ContainerLifeCycle.java:193)
      11. org.eclipse.jetty.util.component.ContainerLifeCycle.updateBeans(ContainerLifeCycle.java:718)
      12. org.eclipse.jetty.server.handler.HandlerCollection.setHandlers(HandlerCollection.java:89)
      13. org.eclipse.jetty.server.handler.ContextHandlerCollection.setHandlers(ContextHandlerCollection.java:165)
      14. org.eclipse.jetty.server.handler.HandlerCollection.addHandler(HandlerCollection.java:155)
      15. org.eclipse.jetty.deploy.bindings.StandardDeployer.processBinding(StandardDeployer.java:41)
      16. org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)
      17. org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:495)
      18. org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:146)
      19. org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:175)
      20. org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64)
      21. org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:605)
      22. org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:528)
      23. org.eclipse.jetty.util.Scanner.scan(Scanner.java:391)
      24. org.eclipse.jetty.util.Scanner.doStart(Scanner.java:313)
      25. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)
      26. org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:145)
      27. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)
      28. org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:557)
      29. org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:232)
      30. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)
      31. org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:108)
      32. org.eclipse.jetty.server.Server.start(Server.java:348)
      33. org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:90)
      34. org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:58)
      35. org.eclipse.jetty.server.Server.doStart(Server.java:296)
      36. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)
      37. org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1236)
      37 frames
    7. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    8. Jetty
      XmlConfiguration.main
      1. org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1160)
      1 frame
    9. Jetty :: Start
      Main.main
      1. org.eclipse.jetty.start.Main.invokeMain(Main.java:453)
      2. org.eclipse.jetty.start.Main.start(Main.java:595)
      3. org.eclipse.jetty.start.Main.main(Main.java:96)
      3 frames