topic Re: tMysqlOutput error in Talend Studio

tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 08:51:36 GMT

Hi,
I'm now on Talend Open Studio and I'm trying to import data from a tMap component to a tMysqlOutput component.
I've checked every data type, access and rights but I can't get through a pstmt_tMysqlOutput_1 error.
Here is the complete exception error message :
Exception in thread "main" java.lang.Error: Problèmes de compilation non résolus :
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
connected
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
pstmt_tMysqlOutput_1 ne peut pas être résolu
batchSizeCounter_tMysqlOutput_1 ne peut pas être résolu en tant que variable
batchSize_tMysqlOutput_1 ne peut pas être résolu en tant que variable
batchSizeCounter_tMysqlOutput_1 ne peut pas être résolu en tant que variable
pstmt_tMysqlOutput_1 ne peut pas être résolu
batchSizeCounter_tMysqlOutput_1 ne peut pas être résolu en tant que variable
pstmt_tMysqlOutput_1 ne peut pas être résolu en tant que variable
pstmt_tMysqlOutput_1 ne peut pas être résolu
I don't know where to search to solve this problem.
Thanks in advance for your help,
Nicolas

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 09:29:35 GMT

Hi Nicolas
It is a compilation error, there must be something wrong in your job settings. We usually open the Code tab and see which line of code has error and locate the component which has the error. Some screenshots of your job will be helpful for us to find out the cause.
Shong

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 10:09:53 GMT

Thanks Shong for your answer.
I think my problem comes from the fact that I want to initialize some columns with fixed values and some with datas coming from row1 (for now, a tFileInputDelimited component but at last a ldap component).
For each compilation error, should I create a variable or a field or a class or a parameter as told in the annotations ?
Here are some screenshots to help you.
Thanks in advance,
Nicolas

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 11:15:01 GMT

The error is related to a tMysqloutput, please upload also a screenshot of job and the component setting of tMysqlOutput.
Shong

Re: tMysqlOutput error

janhess — Thu, 07 Mar 2013 11:35:36 GMT

I think password and one_time_pw should be defined as string in the map output?

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 13:02:36 GMT

@ Shong : here are the job and component screenshots
@ janhess : I'll try to define those 2 values and see what happens
Thanks to you both,
Nicolas

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 13:21:27 GMT

Hi
On tmysqloutput, the option 'use an existing connection' is selected, but there is no tmysqlconnection used to create a db connection in your job! This option is always used with tMysqlconnection together, I suggest to learn tMysqlconnection.
Shong

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 13:29:09 GMT

OK ! As I've created a connection in metadata panel, I thought 'use an existing connection' was refering to it... Newbie error
Now there is just one last error :

 connecting to socket on port 3402
 connected
Exception in component tMysqlOutput_1
java.lang.NullPointerException
	at ldap_ls_connector.push_to_mysql2_0_1.push_to_mySQL2.tFileInputDelimited_1Process(push_to_mySQL2.java:2898)
	at ldap_ls_connector.push_to_mysql2_0_1.push_to_mySQL2.runJobInTOS(push_to_mySQL2.java:3783)
	at ldap_ls_connector.push_to_mysql2_0_1.push_to_mySQL2.main(push_to_mySQL2.java:3651)
 disconnected

Re: tMysqlOutput error

janhess — Thu, 07 Mar 2013 14:15:30 GMT

Looks like a parameter missing from your connection details.

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 14:32:43 GMT

You mean tMysqlOutput parameter details ? I've checked it when creating the Mysql connection in Metadatas, so where should I look now ?

Re: tMysqlOutput error

Anonymous — Thu, 07 Mar 2013 14:58:40 GMT

Hi
Make sure the db connection is created before it is used. The job looks like:
tMysqlConnection
|
onsubjobok
|
tFileInputDelimited---main--tMysqlOutput
--onsubjobok--tmysqlCommit
--onsubjoberror--tmysqlRollback

Re: tMysqlOutput error

Anonymous — Fri, 08 Mar 2013 14:28:09 GMT

Hi,
I still get the same error, but maybe I've done something wrong and I can't find anything in the doc to tell me how to use tMysqlConnection and co.
Nicolas

Re: tMysqlOutput error

Anonymous — Fri, 08 Mar 2013 14:35:49 GMT

Hi
Please upload some screenshots of your job, so we can assist you further.
Shong

Re: tMysqlOutput error

janhess — Fri, 08 Mar 2013 15:31:55 GMT

Have you checked the 'use existing connection' box in tMySQLOutput?

Re: tMysqlOutput error

Anonymous — Mon, 11 Mar 2013 08:16:05 GMT

Yes, 'use existing connection' box in tMySQLOutput : checked,
still the same error :
"Démarrage du job push_to_mySQL3 a 09:14 11/03/2013.
connecting to socket on port 3782
connected
Exception in component tMysqlOutput_1
java.lang.NullPointerException
at ldap_ls_connector.push_to_mysql3_0_1.push_to_mySQL3.tFileInputDelimited_1Process(push_to_mySQL3.java:3063)
at ldap_ls_connector.push_to_mysql3_0_1.push_to_mySQL3.tMysqlConnection_1Process(push_to_mySQL3.java:480)
at ldap_ls_connector.push_to_mysql3_0_1.push_to_mySQL3.runJobInTOS(push_to_mySQL3.java:4052)
at ldap_ls_connector.push_to_mysql3_0_1.push_to_mySQL3.main(push_to_mySQL3.java:3920)
disconnected
Job push_to_mySQL3 terminé à 09:14 11/03/2013.
"

Re: tMysqlOutput error

Anonymous — Tue, 12 Mar 2013 13:08:50 GMT

Ok, I've found why : I had a BLOB type in my DB corresponding to an OBJECT type in Talend. For such DB fields, you must use a string type in Talend...
Many thanks for your help !!!
Nicolas

Re: tMysqlOutput error

Anonymous — Tue, 12 Mar 2013 14:47:50 GMT

Hi
I don't aggree with your point for such a type, you must use a string type. Are there null value in this column?
Shong

Re: tMysqlOutput error

Anonymous — Tue, 12 Mar 2013 14:56:42 GMT

Yes there might be null value in this column. I've seen that on another post in another forum :
http://www.labdecisionnel.com/index.php?option=com_kunena&func=view&id=5172&catid=47&Itemid=101
Nicolas

Re: tMysqlOutput error

Anonymous — Tue, 12 Mar 2013 16:24:51 GMT

hi all,
about the error, I had the same one just yesterday
I was using a mysql connection with a pre-job and get the "smt ... error message".
I had unchecked "use a connection", run the job , and check again the option ... and It was OK ( it was like it didn't see it)
(4.1.1 tis version)
But don't have the reason why
my 2 cents
regards
laurent

Re: tMysqlOutput error

Anonymous — Wed, 13 Mar 2013 01:52:17 GMT

Hi Nicolas
Still select 'Object' as talend type and 'Blob' as DB type, but try to handle the null value for this column on tMap like:
row1.columnName==null?null:row1.columnName
@Kzone, it looks like a refresh problem, the code of tMysqlConnection is not generated yet? You can try to close the job and open it again next time.
Shong