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

Last edited by wesleychristelis (2012-06-27 22:27:35)