topic Re: Access Base : Exception InvalidCipherTextException in Talend Studio

Access Base : Exception InvalidCipherTextException

Fernandez — Tue, 01 Oct 2019 15:19:34 GMT

Hi,

I get this error when I try to use the component tAccessConnection :

Exception in thread "main" java.lang.NoClassDefFoundError: org/bouncycastle/crypto/InvalidCipherTextException
at com.healthmarketscience.jackcess.CryptCodecProvider.createHandler(CryptCodecProvider.java:110)
at com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:105)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:512)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:386)
at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:248)
at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:18)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:169)
at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:90)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at iss.iss_masterdata_3_insertintoaccessbase_0_1.ISS_Masterdata_3_InsertIntoAccessBase.tAccessConnection_1Process(ISS_Masterdata_3_InsertIntoAccessBase.java:5511)

Is there a library missing ?

Thanks

Re: Access Base : Exception InvalidCipherTextException

Anonymous — Tue, 01 Oct 2019 16:29:03 GMT

Hi,

It says that InvalidCipherTextException class of org.bouncycastle.crypto jar is missing. Could you please double check whether you have installed all dependency jars for the component?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Access Base : Exception InvalidCipherTextException

Fernandez — Tue, 01 Oct 2019 16:47:19 GMT

Hi,

I'm not sure to have installed all necessary jars.

But I can't verfiy in Modules Tab, nothing appears:

I could use tLibraryLoad but I don't know which library to load...

Re: Access Base : Exception InvalidCipherTextException

Anonymous — Tue, 01 Oct 2019 16:59:37 GMT

Hi,

If the jars are missing, it will be displayed in a yellow ribbon as shown below.

But if you need any additional jars, you can always use tLibraryLoad after downloading the jar.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Access Base : Exception InvalidCipherTextException

Fernandez — Tue, 01 Oct 2019 17:27:01 GMT

I load the library below before using tAccessConnection :

But I have an error quiet similar

Exception in thread "main" java.lang.NoClassDefFoundError: org/bouncycastle/crypto/CipherParameters
at com.healthmarketscience.jackcess.CryptCodecProvider.createHandler(CryptCodecProvider.java:110)
at com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:105)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:554)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:415)
at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:267)
at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:18)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:169)
at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:90)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at iss.iss_masterdata_3_insertintoaccessbase_0_1.ISS_Masterdata_3_InsertIntoAccessBase.tAccessConnection_1Process(ISS_Masterdata_3_InsertIntoAccessBase.java:5647)

Re: Access Base : Exception InvalidCipherTextException

Anonymous — Tue, 01 Oct 2019 17:29:11 GMT

Hi,

Could you please share the screenshot of Advanced section of tLibraryLoad? I hope you have added the import statement there.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Access Base : Exception InvalidCipherTextException

Fernandez — Wed, 02 Oct 2019 08:13:15 GMT

Hi,

There's nothing in Advanced settings:

Re: Access Base : Exception InvalidCipherTextException

Anonymous — Wed, 02 Oct 2019 14:34:08 GMT

Hi,

Could you please import the class InvalidCipherTextException in the advanced section?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Access Base : Exception InvalidCipherTextException

Fernandez — Wed, 02 Oct 2019 15:37:57 GMT

Hi,

It's running fine with using the library "bcprov-jdk15on-1.57.jar".