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
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.
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
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."
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
“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.”
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):