Access Base : Exception InvalidCipherTextException

[Fernandez]

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

[Anonymous]

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

[Fernandez]

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

[Anonymous]

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

[Fernandez]

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)

[Anonymous]

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

[Fernandez]

Hi,

There's nothing in Advanced settings:

[Anonymous]

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

[Fernandez · Accepted solution]

Hi,

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