3 Replies Latest reply on Jul 9, 2019 8:39 AM by jrmarchio

    Hibernate Tools 5.4.4 Hibernate 3.5 - Can’t open connection

    jrmarchio

      Hi, I have a problem with Hibernate Tools 5.4.4.v20190328-1505

       

      I am trying to make Hibernate Console work on my new eclipse installation (Version: 2019-03 (4.11.0)).

       

      Exception is: org.hibernate.exception.JDBCConnectionException: Cannot open connection

      Caused by: java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://hidden-hostname:1433/hidden-db-name

       

       

      Now, the driver is in the connection classpath, and I know it is OK, because if I only change the hibernate version to 4.3 or later, it works. With 4.0 or less, same exception.

       

      I can’t just use it with version 4.3, because in my real configuration (many more mappings) I have all mapping files with 3.5 DTD and other characteristics not supported after 3.5 (LONG definitions, etc).

       

      I have used hibernate console since long ago. I have had little struggle to make configuration work on other plugin installations, but this time I am getting out of ideas..

       

      Previous working combination was not much older: eclipse Mars. 2 Release (4.5.2), same hibernate (3.5) Hibernate tools 5.0.1.Final-v20160331-1852-B88

       

      Can anybody help me to find out what could be generating the problem?

       

      Any information about some important changes between 5.0.1 and 5.0.4?

       

      Thank you in advance

      ---

      Juan

        • 1. Re: Hibernate Tools 5.4.4 Hibernate 3.5 - Can’t open connection
          jrmarchio

          Trying to debug the code, I found that no matter which hibernate target version is selected, code always calls a SessionFactoryImpl from hibernate 4.0-Final, which could be the reason why queries start working selecting hibernate version 4.3 or higher (4.3 is the lowest selectable version higher than 4.0).

           

          Could anybody who knows this project check this?

           

          Thank you

          • 2. Re: Hibernate Tools 5.4.4 Hibernate 3.5 - Can’t open connection
            jkopriva

            Hi Juan,

             

            Thank you for reporting this issue. I have created JIRA: [JBIDE-26698] Hibernate 3.5 - Can’t open connection - JBoss Issue Tracker , you can track this issue there.

             

            I will try to get in touch with developers.

             

            Once again thank you for reporting!

            Josef

            • 3. Re: Hibernate Tools 5.4.4 Hibernate 3.5 - Can’t open connection
              jrmarchio

              I managed to find the cause of the problem, which is a missing  org.hibernate.eclipse dependency for hibernate runtimes 3.5, 3.6 and 4.0, which causes that BundleLoader.findClassInternal() when calling findRequiredSource(“org.hibernate.console”, null) doesn’t get any source thus driver class doesn’t get loaded.

               

              The fix is to add org.hibernate.eclipse dependency on manifests for projects:

              orm\plugin\runtime\org.jboss.tools.hibernate.runtime.v_3_5

              orm\plugin\runtime\org.jboss.tools.hibernate.runtime.v_3_6 and

              orm\plugin\runtime\org.jboss.tools.hibernate.runtime.v_4_0

               

              Added missed dependency

               

              I can’t generate a pull request because I can’t build the project and thus neither run tests, as it doesn’t build as indicated in the project readme file, and other build documents (in jbosstools/devdoc) are marked as obsolete.

               

              I’m posting here and will update the bug hoping for some project developer to apply the fix.

               

              Regards