topic Re: JCoMetaData cannot be resolved to a type / Can't find libsapjco3.jar file in Talend Studio

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

RMotta2408 — Fri, 15 Nov 2024 21:51:36 GMT

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

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

Anonymous — Fri, 28 Apr 2023 01:13:02 GMT

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

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

RMotta2408 — Fri, 28 Apr 2023 09:10:55 GMT

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

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

Anonymous — Fri, 28 Apr 2023 09:37:49 GMT

Hello @Rui Motta ,

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

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

RMotta2408 — Fri, 28 Apr 2023 15:25:20 GMT

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

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

RMotta2408 — Fri, 28 Apr 2023 16:22:00 GMT

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

Rui

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

Anonymous — Thu, 04 May 2023 00:25:59 GMT

Hello @Rui Motta ,

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

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

RMotta2408 — Thu, 04 May 2023 09:57:09 GMT

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

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

Anonymous — Fri, 05 May 2023 00:18:19 GMT

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

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

RMotta2408 — Fri, 05 May 2023 08:56:04 GMT

Hi @Aiming Chen ,

Thanks for clearing that up for me.

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

Rui