Guess Schema not working in tOracleInput Component

RVeitch_84 — Fri, 15 Nov 2024 22:46:21 GMT

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

Re: Guess Schema not working in tOracleInput Component

Anonymous — Mon, 04 Jul 2022 06:12:07 GMT

Hello customer,

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

the workaround is to

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

Re: Guess Schema not working in tOracleInput Component

Anonymous — Tue, 05 Jul 2022 03:47:46 GMT

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

Re: Guess Schema not working in tOracleInput Component

RVeitch_84 — Tue, 05 Jul 2022 13:08:19 GMT

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

See screenshot .

topic Re: Guess Schema not working in tOracleInput Component in Talend Studio

Guess Schema not working in tOracleInput Component

Re: Guess Schema not working in tOracleInput Component

Re: Guess Schema not working in tOracleInput Component

Re: Guess Schema not working in tOracleInput Component