Close or disconnect connection

[tomswinkels]

Hi,

Is there an option to close the connection?

Like $client->disconnect(); ?

In the bolt client, there is an option for it ->

neo4j-php-client/src/Bolt/Connection.php

Line 45 in c91a479

$this->connection->disconnect();

[transistive]

Hello @tomswinkels,

Thank you for the question. @exaby73 and I have been discussing this very heavily and are busy implementing it properly. He is sick today, but we hope to circle back to this on Friday!

[tomswinkels]

Any update @transistive and @exaby73 ?

[transistive]

Hello @tomswinkels,

We have thoroughly discussed this as the connection logic is quite complicated.

In more general terms these are some relevant factors:

• The client does not have a single connection, but rather a collection of drivers.
• A driver holds a connection pool that dynamically creates connections as required.
• The session object borrows a connection every time it runs a transaction
• The only object actually holding a connection is a Transaction object, which is the only place we can theoretically expose it.
• The new PR with logging actually silently included a closeConnections method here

  neo4j-php-client/src/Basic/Driver.php

  Line 61 in bc4b9e5

  public function closeConnections(): void

  . This actually clears the routing tables connections but is very dangerous as it will break any running transactions.

A long story short: we ended up in a long theoretical discussion of how this disconnecting of the connections would even be needed.

It seems like a valuable learning opportunity for all of us to see how this need arose, because under the current architecture exposing a single connection in the client, driver or session object is simply impossible.

I'll ping you in the internal slack to discuss further.