Is it possible to configure Bonita DataSource with SQL server using dynamic ports?

Q&A
1

Hello guys,

Is it possible to configure Bonita's DataSource with SQL server configured with instances with dynamic ports? 

The issue is that in bonita.xml (extract below) the port needs to be specified :

 <!-- ##################################################### -->
    <!-- Configure Datasource for Bonita standard database -->
    <!-- ##################################################### -->
    <Resource name="RawBonitaDS"
              ...
              serverName="@@ds1_database_server_name@@"
              portNumber="@@ds1_database_port_number@@"
              port="@@ds1_database_port_number@@"
              databaseName="@@ds1_database_database_name@@"
              ...

Platform used:

  • SQL server 2016
  • Bonita-Subscription-7.10.1

Thanks a lot,

 

2

Hello Ismail,

So far, I never heard of dynamic port.

AFAIU how dynamic port works, port is allocated dynamically at SQL Server startup, and is echoed somewhere.

In Bonita, there is no way to "guess", this dynamic port.

I think the solution would be to have a "routine" / "script" that reconfigures Bonita with this port each time the port changes. This is the only way I see.

HTH

Emmanuel