topic Re: tAccessOutputBulkExec in Talend Studio

tAccessOutputBulkExec

Anonymous — Sat, 16 Nov 2024 05:19:59 GMT

Hello, i am trying to use tAccessOutputBulkExec because i need to write milions of rows into Access DB.

I am able to write using the standard tAccessOutput component but the action requires lot of time so that's the reason why i wanna use the bulk ones.

Unfortunally when i try to use the component i get the error:

Exception in component tAccessOutputBulkExec_1_tABE (Write_date_Into_DB)
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)

looks like thast some .jar file is missing but i don't have any "yellow" advise in the corner ot the tAccessOutputBulkExec which says that any component is missing....

Re: tAccessOutputBulkExec

Anonymous — Tue, 09 Jul 2019 22:16:46 GMT

And after that the job failed, the csv which i specified in the tAccessOutputBulkExec is emptied. I built this csv with one jobs which output in csv files, i did not use the tAccessOutputBulk. could be this the issue? don't know...

Re: tAccessOutputBulkExec

Anonymous — Tue, 16 Jul 2019 07:44:57 GMT

Any feedback please?

Re: tAccessOutputBulkExec

Anonymous — Mon, 22 Jul 2019 08:18:23 GMT

Hello,

Is your Access DB connection OK with you? Are you using Generic ODBC? More information will be preferred.

Best regards

Sabrina