Four Stars

Cannot connect to access DB - NullPointerException

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 Smiley Happy

  • Data Integration
Tags (1)
2 REPLIES
Moderator

Re: Cannot connect to access DB - NullPointerException

Hello,

Did you use tAccessConnection component in your work flow? Is there any connector(onsubjobOK or oncomponentOk) between tAccessConnection and your tAccessInput component?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Cannot connect to access DB - NullPointerException

A null pointer means that the compiler is trying to reference an object that hasn't been instantiated yet. The stack trace you posted tells you that the error is at line 1168 of your Java code: try opening the Code editor and see what objects are referred to in that area. Also, look for any errors earlier in the code that may cause an initialization failure (all errors will be marked with a red block on the right-hand side of the editor).

Good luck!

David