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]

What version of Access was used to create the database? There is a known issue with the Jet format on older versions of Access: you can read about it here:

http://netdat.ru/accdb/

David

[Anonymous]

@DVSCHWAB I'm using Access 2007 to read my database but it seems like it was created with Access 97. I guess the real problem is coming from this.

[Anonymous]

Hi,

Have you tried to use other Access DB to see if the DB connection is Ok with you?

Best regards

Sabrina

[Anonymous]

@xdshi

Sabrina,

I just created a test database with Access 2007 and used tAccessInput -> tLogRow and the connection works fine.

The problem might very well be the access version of the database I need to use then. The problem is that I can't duplicate or update the database I need to use. Unfortunately, I really have to use this Access 97 database.

[Anonymous]

Hi,

What's talend build version you are using?

Best regards

Sabrina

[Anonymous]

@xdshi

I'm using TOS DI v6.4.0

[Anonymous]

Hi,

Please take a look at this document about:TalendHelpCenter: Supported systems, databases and business applications by Talend components for 6.4

Best regards

Sabrina

[Anonymous]

@xdshi

I just looked  at the document you linked. Does it mean I definitely can't use Talend to move my data from access 97 database?

[Anonymous]

Hi,

In the documentation we provide a list of databases that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) databases will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.

Best regards

Sabrina

[Anonymous]

@xdshi

So you can't help me with my issue?