Cannot connect to access DB - NullPointerException

[Anonymous]

Hello,

I'm trying to move data from an Access database to a Microsoft SQL server database. I created my connection to the Access database. When I verify the connection, it tells me it works fine. But when I'm running my Job, I'm getting the following error:

Exception in component tAccessInput_1 (myDB)
java.lang.NullPointerException
	at java.util.Hashtable.put(Unknown Source)
	at cftmc.myJob_0_1.myDB.tAccessInput_1Process(myDB.java:1168)
	at cftmc.myJob_0_1.myDB.runJobInTOS(myDB.java:2050)
	at cftmc.myJob_0_1.myDB.main(myDB.java:1753)

Any help?

Thank you

[Anonymous]

Hi,

We will make an investigation on your issue and then come back to you as soon as we can.

Best regards

Sabrina

[Anonymous]

Ok, I'm looking forward to hear from you.

Thank you.

[Anonymous]

@xdshi

Any update about the issue?

[Anonymous]

Hi,

So far, we cannot find a solution for Access 97. Can you export your data from Access 97 to Access 2003 or 2010?

Best regards

Sabrina

[Anonymous · Accepted solution]

Hi,

Unfortunately I have to use that Access 97 database and I can't convert it. I guess I'm gonna use a PHP script instead of Talend then.

Thanks anyway.

[mhaouach]

Hello,

I use talend 6.4 and database access 97,i want to know if you have find a solution.

Exception in component tAccessConnection_1 (testt)
net.ucanaccess.jdbc.UcanaccessSQLException: jet format 'VERSION_3' does not support writing for C:\Users\ahmed\Desktop\qcompta.mdb
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:247)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.testt_0_1.testt.tAccessConnection_1Process(testt.java:387)
at test.testt_0_1.testt.runJobInTOS(testt.java:1028)
at test.testt_0_1.testt.main(testt.java:877)
Caused by: java.io.IOException: jet format 'VERSION_3' does not support writing for C:\Users\ahmed\Desktop\qcompta.mdb
at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:381)
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:158)
at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:57)

best regard