problems with a database connection

[USCHUKN1ME]

Hello all,

I have problems with a user with a database connection.

Note: The configuration works on other pcs without problems.

Here the driver is no longer found!

The following is the configuration:
I have already x times deleted the settings , Preferences imported, nothing has helped.

---

I also find this message strange, since version 4.7.3 is installed!

Thanks in advance for your support.

[AlexanderFillbrunn]

Hi,
Do your colleagues have exactly the same settings (except of course different path names)? I think you only need the sajdbc4.jar file (see here), but more files might not make a difference.
Can you check in your log file (View → Open KNIME Log…) if it mentions any errors loading the driver?
Kind regards,
Alexander

[USCHUKN1ME]

Hi @AlexanderFillbrunn ,

thank you very much for the quick feedback.

Yes all have the same settings. Our ERP system received an update and after that some workflows where the database is accessed have problems again and again, but they could be solved every time. This problem currently is new. The driver is included in the KNIME database settings and is also displayed correctly. Only in the DB Connect node no longer included!

I restart KNIME now, and to my surprise the driver has now been found and mounted again.

But now I get the following error message:

[AlexanderFillbrunn]

Hi,
Just a shot in the blue, but do you maybe have multiple entries for the same driver in your settings?
Kind regards,
Alexander

[USCHUKN1ME]

Here the JAVA driver is loaded

[AlexanderFillbrunn]

Hi,
What about the entries in the “Database” section of the preferences?
Kind regards,
Alexander

[USCHUKN1ME]

Hi @AlexanderFillbrunn ,

i took out all other directories.

The following error message:

The message is in the error log after starting KNIME.
Without starting the workflow!

[AlexanderFillbrunn]

Hi,
I mean a different list. Please see attached screenshot for the list I had in mind. Do you have multiple entries for the same driver there?

Kind regards,
Alexander

[USCHUKN1ME]

Hello @AlexanderFillbrunn ,

All KNIME users have only this one entry.

regards

[AlexanderFillbrunn]

Hi,
Thanks, then another reason might be that you have C:\Program Files (x86)\Hs\Ab\Sa17\Java and C:\Program Files (x86)\Hs\Ab\Sa17\Java\sajdbc4.jar in your classpath. C:\Program Files (x86)\Hs\Ab\Sa17\Java is a folder and already contains the driver, but since the driver is already mentioned explicitly, can you remove all rows except C:\Program Files (x86)\Hs\Ab\Sa17\Java\sajdbc4.jar from your classpath list and try again? The problem is that there is a native library file that KNIME is trying to load multiple times. I assume that this is because for some reason the driver is imported twice and the classpath setting could be the reason.
Kind regards,
Alexander

[USCHUKN1ME]

Hello @AlexanderFillbrunn ,

nachfolgend die geänderten KNIME DATABASE Einstellungen:

No i got follow message
“ERROR DB Connector 3:58 Execute failed: Der sajdbc.jar-Build stimmt nicht mit dem Shared Object-Build überein”

“ERROR DB Connector 3:58 Execute failed: The sajdbc.jar build does not match the shared object build.”

I do not understand it anymore!

Asked ChatGPT:

"Der von Ihnen genannte Fehler tritt bei der Ausführung eines KNIME-Workflows auf und bezieht sich auf eine Inkompatibilität zwischen dem “sajdbc.jar-Build” und dem “Shared Object-Build”. Dieser Fehler deutet darauf hin, dass die Version des sajdbc.jar-Datei, die Sie verwenden, nicht mit der Version des KNIME-Shared Objects übereinstimmt.

Um das Problem zu lösen, sollten Sie sicherstellen, dass die Version des sajdbc.jar-Builds mit dem KNIME-Shared Object-Build übereinstimmt."

"The error you mention occurs when running a KNIME workflow and refers to an incompatibility between the “sajdbc.jar build” and the “Shared Object build”. This error indicates that the version of the sajdbc.jar file that you are using does not match the version of the KNIME shared object.

To resolve the issue, you should ensure that the version of the sajdbc.jar build matches the KNIME Shared Object build."

[USCHUKN1ME]

Older KNIME Version used this seeting:

Databases (legacy)

[AlexanderFillbrunn]

Hi,
I think ChatGPT is just making stuff up There is no such thing as “KNIME-Shared Objects”. In your new KNIME AP, do you still have the legacy settings for the sajdbc4.jar? This could also cause the issue, because then the native library could be loaded by the legacy settings and the new settings, causing the clash.
Kind regards,
Alexander

[USCHUKN1ME]

“In your new KNIME AP, do you still have the legacy settings for the sajdbc4.jar?”
I honestly do not know where ?
How could I check this?
Above all, it would then be only with this one user so.

“ERROR DB Connector 3:58 Execute failed: The sajdbc.jar build does not match the shared object build.”

kind regards

[USCHUKN1ME]

Hi @AlexanderFillbrunn ,

I started the resource monitor and found that the ddlhost.exe was actively loaded twice. I ended one “process” and then changed the settings in the KNIME database as follows (screenshot):

Database

The workflow or the DB connect works again!

Thank you so much for your support!!!

Kind regards

[AlexanderFillbrunn]

Hi,
Great to hear! That is a weird thing to happen! Anyways, we know for next time. Happy KNIMEing!
Alexander