• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Exception in component connectionStatsLogs (AS400) in TOS 5.0.1

#1 2012-05-14 10:31:43

olivierjurine
Member
Registered: 2011-07-11
Posts: 18

[resolved] Exception in component connectionStatsLogs (AS400) in TOS 5.0.1

Hi,

I'm using TOS 5.0.1 with AS400 SGBD.

When I create Job (named aaaa) with a tMSGBox (without changing) and using Stats & Logs project settings I have this error :

[statistics] connecting to socket on port 3602
[statistics] connected
Exception in component connectionStatsLogs
java.lang.ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:62)
    at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
    at shlmr.aaaa_0_1.aaaa.connectionStatsLogsProcess(aaaa.java:960)
    at shlmr.aaaa_0_1.aaaa.preStaLogConProcess(aaaa.java:733)
    at shlmr.aaaa_0_1.aaaa.runJobInTOS(aaaa.java:3343)
    at shlmr.aaaa_0_1.aaaa.main(aaaa.java:3041)
Exception in component talendStats_DB
java.lang.NullPointerException
    at shlmr.aaaa_0_1.aaaa.talendStats_STATSProcess(aaaa.java:2030)
    at shlmr.aaaa_0_1.aaaa.runJobInTOS(aaaa.java:3356)
    at shlmr.aaaa_0_1.aaaa.main(aaaa.java:3041)
Exception in component talendStats_DB
java.lang.NullPointerException
    at shlmr.aaaa_0_1.aaaa.talendStats_STATSProcess(aaaa.java:2030)
    at shlmr.aaaa_0_1.aaaa.runJobInTOS(aaaa.java:3394)
    at shlmr.aaaa_0_1.aaaa.main(aaaa.java:3041)
[statistics] disconnected


Yesterday it worked fine, but not today without modification in database or in my project.

It's very strange.


See my Stats & Jobs configuration.

Do you have an idea ?

Thanks in advance


Uploaded Images

Offline

#2 2012-05-14 10:50:50

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: [resolved] Exception in component connectionStatsLogs (AS400) in TOS 5.0.1

Hi

The reason you get ClassNotFoundException is you forgot to choose Driver Jar.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-05-14 12:26:07

olivierjurine
Member
Registered: 2011-07-11
Posts: 18

Re: [resolved] Exception in component connectionStatsLogs (AS400) in TOS 5.0.1

Many thanks.

I'm using 'jt400_V5R3.jar' and it's work perfectly.

Regards

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Exception in component connectionStatsLogs (AS400) in TOS 5.0.1

Board footer

Powered by FluxBB