Menu

joc cockpit connection to database using hibernate files with error

judith han
2021-12-09
2021-12-09
  • judith han

    judith han - 2021-12-09

    hi ,
    trying to install the js7 joc cockpit using hibernate xml and bum into this error:
    NoClassDefFoundError: com/microsoft/sqlserver/jdbc/TDSReaderMark

    <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>

    my guess is something to do with this part of the hibernate file.
    i am using the sqljdbc_9.4.0.0_enu with java 11.

     

    Last edit: judith han 2021-12-09
  • judith han

    judith han - 2021-12-09

    very strange, using sqljdbc_8.2.2.0 works with Java 11.
    anyone can explain ?

     
    • Andreas

      Andreas - 2021-12-09

      use a version of the JDBC Driver that matches your Java, The Java version is included with the file name of newer SQL Server JDBC Driver .jar files.

       
  • Andreas

    Andreas - 2021-12-09

    Hi Judith

    the hibernate file is ok, however, you have to provide the JDBC Driver .jar file, e.g. included with sqljdbc_9.4.0.0_enu as due to licensing reasons for Microsoft SQL Server we cannot ship a JDBC Driver. Use e.g. mssql-jdbc-9.2.jre11.jar.

    The JOC Cockpit graphical installer asks for the location of the JDBC Driver .jar file.

    The JOC Cockpit installer response file joc_install.xml can be used with the settings:

            <!-- You can choose between 'yes' or 'no' for using the internal JDBC Driver -->
            <entry key="internalConnector" value="no"/>
    
            <!-- Select the path to the JDBC Driver file (*.jar) -->
            <entry key="connector" value="mssql-jdbc-9.2.jre11.jar"/>
    


    See JS7 - JOC Cockpit - Headless Installation on Linux/Windows

    Best regards
    Andreas

     
  • judith han

    judith han - 2021-12-09

    thanks, Andreas for the extra info, tried the headless , my cmd close immediate after execute
    C:\users\<user-account>\joc.<release> setup.cmd joc_install.xml </release></user-account>

    already runs as administrator from the cmd line.
    
    trying back to the GUI , it seem now ok to accept the sqljdbc 9.4.0.0 . strange.
    
    have patience with me, i am evaluating the software so is good to know everything as i bum into error and learn means and ways to overcome it.
    
     

Log in to post a comment.

MongoDB Logo MongoDB