JCoMetaData cannot be resolved to a type / Can't find libsapjco3.jar file

[RMotta2408]

Hello everyone,

I have imported some Jobs that have a common problem:

• There is a tLibraryLoad component that requires a jar file (libsapjco3.jar) I can't seem to find.
• Maybe, related to that problem, a tJavaFlex component has the following errors:
  • "JCoMetaData cannot be resolved to a type" is some Jobs (A)
  • "The import com.sap cannot be resolved" in other Jobs. (B)

In the (A) cases, the code is the following:

• JCoMetaData table_meta_data = table.getMetaData();

In the (B) case, the advanced settings are as follows:

• import com.sap.conn.jco.*;

Can anyone please help me?

Any help would be tremendously appreciated.

Rui

[Anonymous]

Hello @Rui Motta​ ,

Please try to download the sap java connector from ​https://support.sap.com/en/product/connectors/jco.html

then import the sapjco3.jar by Window-show view->Talend->Modules view in the studio

see https://help.talend.com/r/en-US/8.0/studio-user-guide/installing-external-modules-manually-using-modules-view

then you can select the jar from tLibraryLoad component in the job

Best regards

Aiming

[RMotta2408]

Hi @Aiming Chen​ ,

Thanks for replying, as always.

I created an account to log in to https://support.sap.com/en/product/connectors/jco.html but I do not have permission to download software.

But I managed to get the jar file and that error is gone.

Now I'm left with the following message, after running the Job:

"java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path: [/usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]"

What do I need to do?

Thanks so much,

Rui

[Anonymous]

Hello @Rui Motta​ ,

1. on Windows, the sapjco3 DLL files needs to be copied to the current working directory or in a directory listed in the Windows PATH environment variable, e.g. C:/windows/system32

2 on Linux, the sapjco3 *.so files need to be copied to the folder /usr/lib64

Thanks

Aiming

[RMotta2408]

Hi @Aiming Chen​ ,

It did not work for me.

The Job still gives this message:

"java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path: [/usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]"

But the file is where you mentioned.

 

Maybe I must restart the computer.

Thank you,

Rui

[RMotta2408]

I have restarted the computer but still unable to get rid of the messagem.

Rui

[Anonymous]

Hello @Rui Motta​ ,

Please copy the sapjco3.dll file to the folder under {JRE home}/bin, thanks

[RMotta2408]

Hi @Aiming Chen​ ,

I have done that but I think the problem is the version of the sapjco3.dll file.

Is there (or could it be) a difference between a sapjco3.dll file for Windows 32-bit and for Windows 64-bit?

Thanks,

Rui

[Anonymous]

Hello @Rui Motta​ ,

Yes, there is difference between sapjco3.dll file of win-32 bit and win-64 bit. For your case, to be compatible with the windows, it should use win-64bit of sapjco3.dll

Thanks

Aiming

[RMotta2408]

Hi @Aiming Chen​ ,

Thanks for clearing that up for me.

I will try to get the correct version of the files.

Rui