tDBBulkExec - Oracle - null pointer exception

[talendtester]

I have a table created in an Oracle database.

I have a delimited data file with data I have already successfully loaded into the table in the past.

I truncated the table.

I am trying to load the table using the tDBBulkExec component so all the data is loaded with a single commit.

I am using Encoding WE8ISO8859P15 which was used to create the data file I am trying to load.

Record Format Steam Record terminator "\\n"

Any ideas?

Exception in component tDBBulkExec_1 (Test_BulkLoad)
java.lang.NullPointerException

job |context|priority|type |origin |message |code|
-------------|-------|--------|--------------|-------------|-----------------------------------|----|
Test_BulkLoad|Default|6 |Java Exception|tDBBulkExec_1|java.lang.NullPointerException:null|1

[akumar2301]

Do you have any column defined as not null , you might be getting null

[talendtester]

All the columns are VARCHAR(255) and Nullable.

[akumar2301]

hmm , do you have more detail on error , looks like java error rather than database

we need to identify which line of code is giving this error ?

[talendtester]

The component successfully completes the Truncate table.

I looked at the code window, it doesn't point to a specific line of code.

[talendtester]

For this limitation, does it mean if the Oracle SQL*Plus database client is installed on the same virtual machine where Talend Studio DI is installed it will work? Or is that maybe the reason for the null pointer error?

https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/OiE9c8HiCI9t0YIWF97K9w

Limitation

The database server/client must be installed on the same machine where the Studio is installed or where the Job using tOracleBulkExec is deployed, so that the component functions properly.

[akumar2301]

Yes SqlPlus should be in machine of jobserver.

Can you please do a java debug of your code and check which line it is giving this error ?

[talendtester]

Here is the Java Debug:

Here is the warning:

[talendtester]

What does this mean? Is it one of those phantom errors where I need to delete folders and have the project rebuild?

org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
at org.eclipse.swt.SWT.error(SWT.java:4441)
at org.eclipse.swt.SWT.error(SWT.java:4356)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:139)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.talend.rcp.intro.Application.start(Application.java:265)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
Caused by: java.lang.NullPointerException
at org.talend.designer.runprocess.ui.DebugProcessTosComposite$16$1.run(DebugProcessTosComposite.java:1139)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)
... 23 more

[talendtester]

I found this:

This issue seems to be reproducible when an external program (e.g. MS-Word) is set as the Default Editor in Eclipse for opening *.java files.

https://github.com/EvoSuite/evosuite/issues/133