topic Re: talend getting error while connecting to sybase database in Talend Studio

talend getting error while connecting to sybase database

cqh — Sat, 16 Nov 2024 00:43:34 GMT

Hi,

I am trying to connect to a sybase database. I have tried with sybase 16(jconn4.jar installed) and sybase12/15(jconn3.jar installed). Both connection failed with error "java.sql.SQLException: JZ00L: Login failed." However, I am able to connect in the dbVisualizer with the same login/pass. And I suspected that this may due to encrypt password is enabled in the sybase. In dbVisualizer, I have checked the JCE_Provider_CLass and ENCRYPTY_PASSWORD. So I tried to put ENCRYPT_PASSWORD=True in the additional parameters. And i am geting the error "java.lang.RuntimeException: java.sql.SQLException: JZ0LA: Failed to instantiate Cipher object. Transformation RSA/NONE/OAEPWithSHA1AndMGF1Padding is not implemented by any of the loaded JCE providers."

Does anyone have ideas of this problem?

Re: talend getting error while connecting to sybase database

cqh — Mon, 01 Feb 2021 16:28:59 GMT

does someone have run into this issue

Re: talend getting error while connecting to sybase database

Anonymous — Tue, 02 Feb 2021 07:18:09 GMT

Hi cqh

Can you try to specify the JCE_PROVIDER_CLASS parameter also in the Aditional parameters Field? refer to these two pages.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39001.0707/html/prjdbc0707/CIHGFHDI.htm

Regards

Shong