topic Re: Using tOleDbInput component - janet-win64.dll dependent librairies in Talend Studio

Using tOleDbInput component - janet-win64.dll dependent librairies

Anonymous — Thu, 29 Sep 2016 16:50:14 GMT

Hello,
I am trying to use the tOleDbInput component to get data out of a database. I am using Talend Open Studio for Data Integration 6.2.1.
So far I have added the janet-java-1.1.jar and load the janet-win64.dll to c:\windows\system32. I have also installed .net framework 4.5.
My job is very simple: tOleDbInput => tLogRow
Running the job is causing the following error:
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\Windows\System32\janet-win64.dll: Can't find dependent libraries
    at java.lang.ClassLoader$NativeLibrary.load(Native Method)
    at java.lang.ClassLoader.loadLibrary0(Unknown Source)
    at java.lang.ClassLoader.loadLibrary(Unknown Source)
    at java.lang.Runtime.loadLibrary0(Unknown Source)
    at java.lang.System.loadLibrary(Unknown Source)
    at org.talend.net.Object.loadLibrary(Object.java:201)
    at org.talend.net.Object.<clinit>(Object.java:164)
    at proficy_connection.proficy_0_1.Proficy.tOleDbInput_1Process(Proficy.java:417)
    at proficy_connection.proficy_0_1.Proficy.runJobInTOS(Proficy.java:796)
    at proficy_connection.proficy_0_1.Proficy.main(Proficy.java:653)
Any help would be greatly appreciated !
Thanks,
Bertrand
Job1.zip_20161006-0338.zip
Job2.zip_20161006-0338.zip

Re: Using tOleDbInput component - janet-win64.dll dependent librairies

Anonymous — Sun, 09 Oct 2016 09:06:53 GMT

Hi,
Have you already checked component reference about: TalendHelpCenter:tOleDbInput
To use this component, you must first install the runtime DLLs, for example janet-win32.dll for Windows 32-bit version and janet-win64.dll for Windows 64-bit version, from the corresponding Microsoft Visual C Redistributable Package. This allows you to avoid errors like the UnsatisfiedLinkError on dependent DLL.
Best regards
Sabrina

Re: Using tOleDbInput component - janet-win64.dll dependent librairies

Anonymous — Tue, 11 Oct 2016 09:55:24 GMT

Hello,
I am trying to use the tOleDbInput component to get data out of a database. I am using Talend Open Studio for Data Integration 6.2.1.
So far I have added the janet-java-1.1.jar and load the janet-win64.dll to c:\windows\system32. I have also installed .net framework 4.5.

Hello Sabrina,
As I said in my first post, I have already done this step.
I have been helped by one of your colleague. It seems that the issue comes from the fact that my Talend is not connected to the Internet. Dependant librairies are downloaded in the background.
I am carrying on tests. I will publish the result if they are successful.
Best regards,
Bertrand

Re: Using tOleDbInput component - janet-win64.dll dependent librairies

Anonymous — Tue, 20 Nov 2018 16:05:10 GMT

I have the same issue,

I installed the dll and the .NET Framework but I always get this error message

Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\Windows\System32\janet-win64.dll: Une routine d’initialisation d’une bibliothèque de liens dynamiques (DLL) a échoué

Can someone help please ?

Re: Using tOleDbInput component - janet-win64.dll dependent librairies

Anonymous — Tue, 20 Nov 2018 19:27:21 GMT

To use this component, you must first install the runtime DLLs, for example janet-win32.dll for Windows 32-bit version and janet-win64.dll for Windows 64-bit version, from the corresponding Microsoft Visual C Redistributable Package. This allows you to avoid errors like the UnsatisfiedLinkError on dependent DLL.
Best regards

audacity find my iphone origin

Re: Using tOleDbInput component - janet-win64.dll dependent librairies

Anonymous — Wed, 21 Nov 2018 09:27:44 GMT

Thanks for your answer

Does it mean that just copy paste the dll in the folders like above mentionned doesnt' work ?

Must I use an installation package? If I must, where can I find Microsoft Visual C Redistributable Package?

Regards