talend getting error while connecting to sybase database

[cqh]

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?

[cqh]

does someone have run into this issue

[Anonymous]

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/prjdbc070...

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

Regards

Shong