Error Exception in component talendStats_DB

[_AnonymousUser]

Hi, I have a problem with version 5.2 of Talend:
Exception in component connectionStatsLogs
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:323)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:268)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:191)
        at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:62)
        at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.connectionStatsLogsProcess(TW_COMPLETE.java:2727)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.preStaLogConProcess(TW_COMPLETE.java:752)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.runJobInTOS(TW_COMPLETE.java:5130)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.main(TW_COMPLETE.java:4934)
Exception in component talendStats_DB
java.lang.NullPointerException
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.talendStats_STATSProcess(TW_COMPLETE.java:3857)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.runJobInTOS(TW_COMPLETE.java:5142)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.main(TW_COMPLETE.java:4934)
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:323)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:268)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:191)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.tJDBCInput_1Process(TW_COMPLETE.java:1707)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.runJobInTOS(TW_COMPLETE.java:5151)
        at ecce_etl.tw_complete_0_1.TW_COMPLETE.main(TW_COMPLETE.java:4934)
Exception in component talendStats_DB
Has anyone had a similar problem?
thanks

[Anonymous]

a simple question : why not use OracleSID so ?
regards

[_AnonymousUser]

Why I did a test with OracleSID but we use different DB and so we need JDBC General
 
regards
Anna

[_AnonymousUser]

hello, having received no response I made various tentivi and I found a solution valuing only the field and the field context.EC_DATA_SRC_DriverJar and context.EC_STAGE_SRC_DriverJar with a nonexistent path /opt/Talend/lib/ojdbc5.jar and I worked reading values right to file CONNECTIONS.properties
As this is not an ideal solution rest waiting for another solution.
regards
Anna

[Anonymous]

hi Anna,
Do you got a default value for your driver path in your context or values are only in file properties ?
I guess that when you build job Talend find driver path as it 's in that file.
When you build job, is there the driver .jar in lib repository ?
 

I guess no, because Talend seems to not find the driver jar as it's in a context value.
perhaps try to configure CLASSPATH variable system in your .bashrc

export CLASSPATH=$CLASSPATH;/path/to/your/lib/ojdbc6.jar 

or try to copy driver jar directly in th lib package 
hope I've been clear enought .. not sure
regards

[_AnonymousUser]

hello,
in the properties file have the correct value.
While in the context I put a default value otherwise I would go wrong.
The .jar is present in lib repository.
 
There is no way not to exploit the context and not make it go wrong?
regards
Anna