Page History

...

• a domain account has to be set up before installation of the JOC Cockpit for the user account that connects to the database,
• to set up a Hibernate configuration file, see JS7 - Database:
  • Users can create an individual Hibernate configuration file and make the installer use this file. The hibernate.connection.url property in this file has to include the IntegratedSecurity=true setting, no user name or password has to be specified.

  • This configuration will implicitly use the domain account that JOC Cockpit is operated for.

    Code Block
    title Add IntegratedSecurity=true property
    <property name"hibernate.connection.url">jdbc:sqlserver://[servername]:[port];IntegratedSecurity=true;sendStringParametersAsUnicode=falsetrue;selectMethod=cursor;databaseName=[databasename]</property> <property name="hibernate.connection.username"></property> <property name="hibernate.connection.password"></property>

...

• modify JETTY_BASE/resources/joc/hibernate.cfg.xml:

  Code Block
  title Add IntegratedSecurity=true property
  <property name"hibernate.connection.url">jdbc:sqlserver://[servername]:[port];IntegratedSecurity=true;sendStringParametersAsUnicode=falsetrue;selectMethod=cursor;databaseName=[databasename]</property>

...