Uploaded image for project: 'Tools (JBoss Tools)'
  1. Tools (JBoss Tools)
  2. JBIDE-29145

Hibernate query result only show one column

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • None
    • hibernate
    • None
    • ---

    Description

      Description of problem:

       
      When using the HQL editor, if I run a multi-column Select query, the query result only shows one column in the "Hibernate Query Result".
       
      I am using the latest version of Hibernate (6.3) integrated in Jboss 4.29 (Maven project). The query is performed against an Oracle XE database version 21c.
       
      Eclipse version 23-12.
       
      If I switch to Hibernate version 5.6 and select another dialect Oracle10gDialect the problem does not occur, however, it is not possible to execute java code as it gives error:
       
      "Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to resolve name [org.hibernate.dialect.Oracle10gDialect] as strategy [org.hibernate.dialect.Dialect].
      at"

      Prerequisites (if any, like setup, operators/versions):

       

      OS: Windows 11, Eclipse EE: 23-12, JBoss: 4.29, Hibernate 6.3, Oracle XE 21c

      Steps to Reproduce

      Query on database
      select profe.nombreApe, profe.fechaNac, profe.c1Centros.nomCentro, profe.c1Centros.codCentro

      from C1Profesores as profe

      Actual results:

      Only first column result is shown.

      Expected results:

      Four columns

      Reproducibility (Always/Intermittent/Only Once):

      Always

      Additional info (Such as Logs, Screenshots, etc):

       *

      Attachments

        Activity

          People

            kaers@redhat.com Koen Aers
            overdrive80 Perico Palote
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: