TOS 5.1 MySql Connection Error

[Anonymous]

Hi guys! I just installed TOS 5.1 over Linux Ubuntu and it run with no problem, but once i try to execute the Connection Job sample i am facing an error that follow below:

Starting job Connection at 23:28 20/05/2012.
connecting to socket on port 3538
connected
Exception in component tMysqlConnection_1
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
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:321)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at demojava.connection_0_1.Connection.tMysqlConnection_1Process(Connection.java:339)
at demojava.connection_0_1.Connection.runJobInTOS(Connection.java:1199)
at demojava.connection_0_1.Connection.main(Connection.java:1067)
disconnected
Job Connection ended at 23:28 20/05/2012.

For org.gjt.mm.mysql.Driver, i already did the download from www.jarfinder.com and put it over classpath variables.. but no way to works, may could someone give some hint how to solve this issue?

Note: My first install was under /opt/ directory and for testing i change it to /home/user/

Best regards,

Sandro Regis

[Anonymous]

Hi
Welcome to Talend Community!
The mysql-connector-java-5.1.0-bin.jar file should be in TOS Installation directory.
Unarchive the installation file with 7-zip and try again.
Regards,
Pedro

[Anonymous]

Hi Pedro, thanks for reply!

So, i did what you said but the error remains, i put the jar file under /home/myuser/TOS_BD-r82787-V5.1.0/ but doens't works.. may have you another hint?

Thanks again,

Sandro Regis

[Anonymous]

Hi
Got you.
You are using TOS_BD-r82787-V5.1.0.
Now the workaround is if you have other versions of TOS, just copy this jar file into <TOS for BD installation dir>\lib.
Regards,
Pedro

[Anonymous]

Okay Pedro, are suggesting to me for migrate to and older version, am i right?

If yes, what stable version should i install?

Just in addition for this one i already put the jar file under lib/java/ directory and doens't works also.

Regards,

Sandro Regis

[Anonymous]

Hi
Maybe you can download Talend Open Studio for Data Integartion. What you are using now is TOS for Big Data.
Regards,
Pedro

[Anonymous]

Hi Pedro, good news!

Now the connection works properly. Thank u!

Just a single question r u from Brasil?

Regards,

Sandro Regis

[Anonymous]

Hi
Great! Glad to hear that.
Regards,
Pedro

[Anonymous]

Hi All
Root Reason: TOS for BD is released under Apache license.
All Libraries non compatible with Apache license must be added manually to the module view.
Regards,
Pedro

[Anonymous]

Pedro, thanks for your last post. But the question is where can i find this module view?

May could you explain to us?

Regards,

Sandro Regis