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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Error Exception in component talendStats_DB

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
Labels (5)
14 Replies
Anonymous
Not applicable

Hi,
What's your JDK?  And did you set the CLASSPATH for java/bin?  Does this issue repro on other build version(Talend 5.6)?

Have you already checked document: TalendHelpCenter:How to install external modules in the Talend products?

Best regards
Sabrina
_AnonymousUser
Specialist III
Specialist III
Author

Hello, I use the
java version "1.6.0_33"
OpenJDK 64-Bit Server VM (build 23:25-b01, mixed mode)
I state that use the Implicit tContextLoad from File
and the problem occurs when I value the context during export.
As soon as I start the .sh returns the above error because Talend can not see the connection Db Connections "General JDBC".
How do I make him see the connections from file?

Best regards
Anna
Anonymous
Not applicable

Hi,
Would you mind sharing your current job screenshots with us? How did you set your implicit tContextLoad in job review?
Best regards
Sabrina
_AnonymousUser
Specialist III
Specialist III
Author

Below the images of the context set in the project
_AnonymousUser
Specialist III
Specialist III
Author

Below the images of the context set in the project
_AnonymousUser
Specialist III
Specialist III
Author

I can not upload the pictures ... it the url of the images
_AnonymousUser
Specialist III
Specialist III
Author

Hi,
I configured the connection  General JDB and exported has context:
https:// imagizer.imageshack.us/v2/517x437q90/r/633/IYjG4g.jpg
and I removed all parameters from the context:
http:// imagizer.imageshack.us/v2/784x490q90/r/674/TjVdvw.jpg
Then I set the project properties:
http:// imagizer.imageshack.us/v2/473x437q90/r/901/bEAIoQ.png
http:// imagizer.imageshack.us/v2/784x467q90/r/674/IVMIjE.png

and it returns the error already attached previously.
The error occurred when I used a set connection with Oracle DB:
http:// imagizer.imageshack.us/v2/451x437q90/r/673/1NxN7E.jpg
and I removed all parameters from the context:
http:// imagizer.imageshack.us/v2/784x491q90/r/912/wBFJzf.jpg

(I have problems with the link, remove the blank space after http:// )
Anonymous
Not applicable

hi,
are you that values from context file (you connection.properties) are loaded ?
did you try to see the result by printing the load of your context (check box in implicit load definition)?
the location of your driver is in a context variable ? it it in your file properties ?
regards
laurent
_AnonymousUser
Specialist III
Specialist III
Author

Hi,
office file correctly connection.properties (with free OracleSID works while with GeneralJDBC not work).
DriverJar the file exists and is on the path EC_DATA_TRG_DriverJar = / opt / ETL / Talend / lib / ojdbc5.jar
 
regards
Anna