Error in Talend java lang UnsatisfiedLinkError no sapjco3 in java library path

Question

I have a ETL job which I have successfully executed the same job on a Windows 2003 and a XP machine. Now, I am trying to execute this Job in Talend and for that I have placed the jar & dll files in the lib folder of Talend. Both path and the classpath is set as well. Moreover I have also downloaded the missing dlls provided by SAP along with VC++ 2005 redistribution sp 1 patch and have already installed them. But when I am trying to execute the job, its giving me the following error. Please suggest some way out of this:
 

Starting job Chargebacks at 13:57 03/10/2014.

[statistics] connecting to socket on port 3350
[statistics] connected
java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path
   at java.lang.ClassLoader.loadLibrary(Unknown Source)
   at java.lang.Runtime.loadLibrary0(Unknown Source)
   at java.lang.System.loadLibrary(Unknown Source)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.loadLibrary(DefaultJCoRuntime.java:441)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.registerNativeMethods(DefaultJCoRuntime.java:307)
   at com.sap.conn.jco.rt.JCoRuntime.registerNatives(JCoRuntime.java:969)
   at com.sap.conn.rfc.driver.CpicDriver.<clinit>(CpicDriver.java:955)
   at com.sap.conn.rfc.engine.DefaultRfcRuntime.getVersion(DefaultRfcRuntime.java:43)
   at com.sap.conn.rfc.api.RfcApi.RfcGetVersion(RfcApi.java:261)
   at com.sap.conn.jco.rt.MiddlewareJavaRfc.<clinit>(MiddlewareJavaRfc.java:200)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.initialize(DefaultJCoRuntime.java:73)
   at com.sap.conn.jco.rt.JCoRuntimeFactory.<clinit>(JCoRuntimeFactory.java:23)
   at com.sap.conn.jco.rt.RuntimeEnvironment.<init>(RuntimeEnvironment.java:40)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at java.lang.Class.newInstance0(Unknown Source)
   at java.lang.Class.newInstance(Unknown Source)
   at com.sap.conn.jco.ext.Environment.getInstance(Environment.java:121)
   at com.sap.conn.jco.ext.Environment.registerDestinationDataProvider(Environment.java:216)
   at jdi.chargebacks_0_1.Chargebacks.tSAPConnection_1Process(Chargebacks.java:361)
   at jdi.chargebacks_0_1.Chargebacks.runJobInTOS(Chargebacks.java:3718)
   at jdi.chargebacks_0_1.Chargebacks.main(Chargebacks.java:3577)
Exception in thread "main" java.lang.ExceptionInInitializerError: Error getting the version of the native layer: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path
   at com.sap.conn.jco.rt.MiddlewareJavaRfc.<clinit>(MiddlewareJavaRfc.java:212)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.initialize(DefaultJCoRuntime.java:73)
   at com.sap.conn.jco.rt.JCoRuntimeFactory.<clinit>(JCoRuntimeFactory.java:23)
   at com.sap.conn.jco.rt.RuntimeEnvironment.<init>(RuntimeEnvironment.java:40)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at java.lang.Class.newInstance0(Unknown Source)
   at java.lang.Class.newInstance(Unknown Source)
   at com.sap.conn.jco.ext.Environment.getInstance(Environment.java:121)
   at com.sap.conn.jco.ext.Environment.registerDestinationDataProvider(Environment.java:216)
[statistics] disconnected
   at jdi.chargebacks_0_1.Chargebacks.tSAPConnection_1Process(Chargebacks.java:361)
   at jdi.chargebacks_0_o1.Chargebacks.runJobInTOS(Chargebacks.java:3718)
   at jdi.chargebacks_0_1.Chargebacks.main(Chargebacks.java:3577)
Job Chargebacks ended at 13:57 03/10/2014. [exit code=1]

Answer 1

You can start off by placing the .jar files in \lib\java\.

Next, put the dll and the sapjco3.jar files into C:\Windows\system32\ if you are working on Windows.

In case you are working on Linux follow the below steps:

1. In the talend lib/java directory, copy the sapjco3.jar and place the sapjco3.dll in the %PATH%

2. Check the file by double clicking it. If it’s correct then it must display the location info of the jar and dll files

Make sure to use jdks of same versions as your processor.

Hope this helps.

To learn more about Talend' it's recommended to join Talend training today.

Thanks.