get JDBC error when I use Guess schema

One Star

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)
Community Manager

Re: get JDBC error when I use Guess schema

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: get JDBC error when I use Guess schema

I am using tOracleInput.

Re: get JDBC error when I use Guess schema

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)
Seventeen Stars

Re: get JDBC error when I use Guess schema

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.

Re: get JDBC error when I use Guess schema

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"

Re: get JDBC error when I use Guess schema

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

Re: get JDBC error when I use Guess schema

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.