Is it possible to modify the default timeout setting for a NexusDB connection?

Data Abstract
1

For some reason, I found when trying to work with the Schema Modeler that the default timeout setting of 10 seconds is not enough for it to complete the queries to the database.

Is it possible to change this value, and if so, where? I don’t see any option on the connection window for this.

2

Hello,

There is no such parameter in Schema Modeler or somewhere else in DA to change default timeout for NexusDB. So you can change it only in runtime using NexusDB approach, for example by pointing
#T n - statement switch before SQL query.

This works in SM too.

Best regards

3

Thanks elenap, but the problem is that I can’t get to the point of doing a specific query. This happens, for instance, trying to retrieve the Master-Child relationships to create the schema, that’s why I was thinking in something more at the connection level.

4

Hi,

I logged the issue to add timeout option for NexusDB connection as #51589 for research.

Best regards

5

Thank you!

6

Hello,

Is this being looked at? I haven’t been able to use the new SM wizard because it always times out. I know that the Timeout Parameter is something “basically” from the provider part, but in the case of Nexus, you can easily bypass the default timeout by adding a #T before all the queries sent to the provider, until Nexus adds the timeout parameter, this can be very helpful. Or, more than helpful, needed, as I said, I haven’t been able to use the new wizard in the SM because it always times out in a FK query.

Is there a way to modify or add this myself? Basically, I can’t work like this.

7

Hello,

Yes, it was implemented. You should set SESSION.Timeout=20000 for example in connection parameters in Schema Modeler.

Best regards

8

Hi,

Where should I add this? I tried adding it to the connection string, so it is something like this:

NexusDB.NET?Server=localhost;Database=thedatabasealias;Port=16001;Native=true;SESSION.Timeout=70000;

But when executing the wizard I can still see in the nxServer log that the query used to get the FK constraints is not passing that value, and the wizard does not finish. After the Wizard returns the error SM crashes.

I’m using the latest available beta.

9

Hello

As I can see you already raised the issue to add appropriate connection string parameter to the NexusDB ADO.NET driver.

Could you try to do the following as a workaround?

  1. Close the Schema Modeler
  2. Open the DataAbstract.daConfig file located next to the Schema Modeler’s .exe using Notepad or any other plain-text editor
  3. Find there line with text ‘’
  4. As you can see this section defines queries used to acquire database metadata
  5. Please add '#T 0 ’ to the queries in sections GetDatabaseNames, GetTableNames, GetForeignKeys, GetStoredProcedureNames and GetViewNames
  6. Save the file
  7. Launch the Schema Modeler. It will now use this adjusted configuration and should be able to retrieve database metadata
10

Hello Anton,

Thanks for the hint. I’ve modified the query (actually the only one that needs a bigger timeout is the FK one) and now the wizard finishes correctly.

Hopefully you can add the timeout for the Driver. I’ve told Nexus already about this (and added a issue to their tracker) but it doesn’t hurt if you remaind them from your side too.