Guess Schema not working in tOracleInput Component

[RVeitch_84]

I have a very basic job, see screenshots below:

The job works fine, but when I go to use guess schema I get an error.

Database connection is failed.

 java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle.security.pki.OraclePKIProvider

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:218)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1172)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:317)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:303)

   at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.checkConnection(GuessSchemaController.java:1002)

   at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.useMockJob(GuessSchemaController.java:829)

   at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.createButtonCommand(GuessSchemaController.java:238)

   at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController$1.widgetSelected(GuessSchemaController.java:204)

   at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)

   at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)

   at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209)

   at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043)

   at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026)

   at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3626)

   at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1157)

   at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

   at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)

   at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)

   at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)

   at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

   at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)

   at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)

   at org.talend.rcp.intro.Application.start(Application.java:303)

   at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)

   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:401)

   at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)

   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

   at java.base/java.lang.reflect.Method.invoke(Method.java:566)

   at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:654)

   at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

   at org.eclipse.equinox.launcher.Main.run(Main.java:1462)

 Caused by: java.lang.ClassNotFoundException: oracle.security.pki.OraclePKIProvider

   at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:471)

   at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:588)

   at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)

   at java.base/java.lang.Class.forName0(Native Method)

   at java.base/java.lang.Class.forName(Class.java:398)

   at org.talend.core.utils.ReflectionUtils.newInstance(ReflectionUtils.java:280)

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:183)

   ... 34 more

[Anonymous]

Hello customer,

Regarding to the error log, it's due to the missing oraclepki.jar which cause the issue.

the workaround is to

1. add new tLibraryLoad component to load the attach oraclepki.jar in your job , then run the job again

[Anonymous]

Hello,

And hope this KB article helps for your further processing.

https://community.talend.com/s/article/Resolving-class-and-JAR-related-issues

Best regards

Sabrina

[RVeitch_84]

I have that jar already in a tLibaryLoad and I still have the error?

See screenshot .