Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

get JDBC error when I use Guess schema

Getting ClassNotFound exception when I try to use Guess Schema on CentOS OS.
Talend Open Studio
Version: 5.2.1.r95165
Build id: r95165-20121212-0909
Also found this in error log.
!STACK 0
org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaProcess$1: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaProcess.run(GuessSchemaProcess.java:256)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.runShadowProcess(GuessSchemaController.java:341)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.access$1(GuessSchemaController.java:325)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController$4$1.run(GuessSchemaController.java:778)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3515)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3164)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(ModalContext.java:173)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:388)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.useMockJob(GuessSchemaController.java:770)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.openParamemerDialog(GuessSchemaController.java:835)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController.access$2(GuessSchemaController.java:829)
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController$5.run(GuessSchemaController.java:795)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3515)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3164)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.rcp.intro.Application.start(Application.java:127)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
at org.eclipse.equinox.launcher.Main.main(Main.java:1383)
0683p000009MDmy.jpg
Labels (4)
7 Replies
Anonymous
Not applicable
Author

Hi jmagana
Are you using tJDBCInput or tOracleInput component? if former, you are required to specify the driver jar first in the Driver JAR table.
Shong
Anonymous
Not applicable
Author

I am using tOracleInput.
Anonymous
Not applicable
Author

I've got the same problem when I click on "Guess Schema" button on a tOracleInput component :

* Talend Open Studio For Data Integration 5.2.1
* build r95165-20121212-0909
* OS: Windows 7 64bit
(see picture bellow)
0683p000009MD3y.png
Anonymous
Not applicable
Author

I have no such problems in my Open Studio (same version+release).
But I know, Talend has always problems with libraries and one approved way to solve them is to delete the file:
configuration/ComponentCache.javacache
Restart studio and try it again. Most missing ja problems can be solved this way.
Anonymous
Not applicable
Author

I've removed the "configuration/ComponentsCache.javacache" file, but the file is recreated with exactly the same size (175 012 bytes) at TOSDI startup, and the problem still occurs when I click on "guess schema"
Anonymous
Not applicable
Author

When looking at 1st line of logs, we can see that the command line doesn't include the jar ojdbc5.jar
(the class oracle.jdbc.OracleDriver is included in ojdbc5.jar)
(the jar ojdbc5.jar is present in D:/workspace/.Java/lib/)
!ENTRY org.talend.platform.logging 1 0 2013-03-06 11:09:46.786
!MESSAGE 2013-03-06 11:09:46,786 INFO org.talend.designer.core.runprocess.Processor - Command line: D:/jdk1.7.0_07/jre/bin/java.exe -Xms256M -Xmx1024M -Dfile.encoding=UTF-8 -cp D:/workspace/.Java/lib/talend-oracle-timestamptz.jar;D:/workspace/.Java/lib/talendcsv.jar;D:/workspace/.Java/classes;D:/workspace/.Java/lib; my_job.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema --context=Default %*

!ENTRY org.talend.platform.logging 4 0 2013-03-06 11:09:47.378
!MESSAGE 2013-03-06 11:09:47,363 ERROR org.talend.commons.exception.CommonExceptionHandler - java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
Anonymous
Not applicable
Author

I've totally removed and reinstalled TOS 5.2.1, nothing changed.
I've installed TOS 5.2.2, after project update, the button "guess schema" works.