StringIndexOutOfBoundsException: String index out of range
Here's my job:
My MSSQLInput component does a SELECT * from table "EmpList"
This is the error I receive on the MSSQLInput component:
Exception in component tMSSqlInput_1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(Unknown Source)
at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.parseDatetimeOffset(MSSqlGenerateTimestampUtil.java:116)
at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.getDate(MSSqlGenerateTimestampUtil.java:94)
the order of columns at MSSQLInput schema is different with the order of columns at table in database? MSSQLInput column 1 column 2 column 3 Table column 1 column 3 column 2