Hi everybody,
I'm using a tJDBCInput component in a simple job and I have encountered 2 problems.
First of all, when I click the "Guess Query" button, there is "_MyTable_" instead of my table name in the generated query.
And then, when I execute my job, I have an error message saying that the table doesn't exist :
Exception in component tJDBCInput_1 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: La table 'etemptation._mytable_' n'existe pas
Is it a bug?
The second problem appears whith the use of a context variable in the dynamics settings for the Driver Jar. (see the 1st attached picture)
In this case, I have this error message when executing the job :
Exception in component tJDBCInput_1 java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver 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.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at test.test_0_1.test.tJDBCInput_1Process(test.java:590) at test.test_0_1.test.runJobInTOS(test.java:937) at test.test_0_1.test.main(test.java:844)
It seems that TOS doesn't recognise my context parameter.
I tried to write directly the name of the driver jar file instead of the context parameter and the job worked fine.
Any ideas about this problem ?
Best Regards,
Karine
First of all, when I click the "Guess Query" button, there is "_MyTable_" instead of my table name in the generated query.
Yes, it should be a bug on TOS2.4.1 and it have been fixed on the latest version.
It seems that TOS doesn't recognise my context parameter. I tried to write directly the name of the driver jar file instead of the context parameter and the job worked fine.
Please report a bug on our bugtracker.
Thanks for your support!
Best regards
