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

Submitted by ismail.lagouill... on Fri, 05/29/2020 - 20:57
1
0
-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 :

...
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,

1 answer

Submitted by emmanuel.duchas... on Tue, 06/02/2020 - 21:54
1
+1
-1

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

Notifications