Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-1902

Setup throws an NPE error when using SQL Server with Integrated Security

    XMLWordPrintable

Details

    Description

      Current Situation

      When having a mssql database configured with integrated security
      JOC Cockpit Setup and JOC Cockpit start fails with an NPE.

      java.sql.SQLException: java.lang.NullPointerException: Cannot invoke "String.startsWith(String)" because "propertyValue" is null
      	at com.sos.commons.hibernate.configuration.resolver.SOSHibernateEncryptionResolver.hasEncryptedValue(SOSHibernateEncryptionResolver.java:167)
      
      url                  = jdbc:sqlserver://sql_host:49554;IntegratedSecurity=true;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler
      

      Desired Behaviour

      JOC Cockpit installation should run without nullpointer exception.

      Workaround 1

      Change the configuration file hibernate.cfg.xml. Use User/Password instead of integreated security.

      Workaround 2

      • configure empty username and password hibernate elements
        <property name="hibernate.connection.username"></property>
        <property name="hibernate.connection.password"></property>
        

      Attachments

        Issue Links

          Activity

            People

              ur Uwe Risse
              ur Uwe Risse
              Aakash Rao Aakash Rao
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: