get JDBC error when I use Guess schema

[Anonymous]

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)

[Anonymous]

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]

I am using tOracleInput.

[Anonymous]

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)

[Anonymous]

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]

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]

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]

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.