Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

tMomInput & JMS selector? by rhuiser
EBCDIC file extract using Community Edition by narasi
Discover Talend's new v5.3 big data developer tools on May, 29 2013 by pcoffre
Talend MDM Server log messages by erop
tNetezzaInput [...] by Davy.Huijgens
LDAP timeout? by fvalentim
General question about jobservers and runtimes ... by rbadev

Index
» Usage, Operation
» concat

Post a reply

Write your message and submit

Name

E-mail

Message

[quote=wesleychristelis]when i do any sort of query with concat

eg :

select ('hello','world')

i get the following :

Exception in component tMysqlInput_1
java.sql.SQLException: Invalid value for getInt() - 'helloworld'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
	at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2788)
	at clienteledata.event_presentation_attendance_resp_v2_0_1.Event_Presentation_Attendance_Resp_v2.tMysqlInput_1Process(Event_Presentation_Attendance_Resp_v2.java:824)
	at clienteledata.event_presentation_attendance_resp_v2_0_1.Event_Presentation_Attendance_Resp_v2.runJobInTOS(Event_Presentation_Attendance_Resp_v2.java:2057)
	at clienteledata.event_presentation_attendance_resp_v2_0_1.Event_Presentation_Attendance_Resp_v2.main(Event_Presentation_Attendance_Resp_v2.java:1925)

my columns match in my schema and DB... so it is not that[/quote]

Options

Never show smilies as icons for this post

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

pedro: 2012-06-28 05:08:36

Hi

Could you show us the structure of your DB table, the query on tMysqlInput and the schema of tMysqlInput?
There must be some wrong settings. Because the exception indicates the wrong data type.

Regards,
Pedro

wesleychristelis: 2012-06-27 16:16:13

when i do any sort of query with concat

eg :

select ('hello','world')

i get the following :

Exception in component tMysqlInput_1
java.sql.SQLException: Invalid value for getInt() - 'helloworld'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2788)
at clienteledata.event_presentation_attendance_resp_v2_0_1.Event_Presentation_Attendance_Resp_v2.tMysqlInput_1Process(Event_Presentation_Attendance_Resp_v2.java:824)
at clienteledata.event_presentation_attendance_resp_v2_0_1.Event_Presentation_Attendance_Resp_v2.runJobInTOS(Event_Presentation_Attendance_Resp_v2.java:2057)
at clienteledata.event_presentation_attendance_resp_v2_0_1.Event_Presentation_Attendance_Resp_v2.main(Event_Presentation_Attendance_Resp_v2.java:1925)

my columns match in my schema and DB... so it is not that

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer