I'm currently involved in a very large project where we have to transfer data from our Informix DB to PostgreSQL.
I am trying to test using Talend Open Studio and I'm running into some problems. I created a job to test and keep getting the following:
Starting job Cards at 15:07 25/06/2009.
Exception in component tInformixInput_1
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3244)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3553)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2380)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2295)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1434)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:205)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1228)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:218)
at nitro.cards_0_1.Cards.tInformixInput_1Process(Cards.java:1399)
at nitro.cards_0_1.Cards.runJobInTOS(Cards.java:2087)
at nitro.cards_0_1.Cards.main(Cards.java:2005)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:397)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3558)
... 10 more
I'm using:
tInformixInput
tMap -- Since the table structures are different
tPostgresqlOutput
I thought this was all I needed but I'm getting the above errors.
I HAVE DOUBLE QUOTES AT THE END OF THE SQL. I also get something new with 3.1.2 when starting the application: An internal error occurred during: "Generation Engine Initia;ization in progres...", java.lang.NullPointerExeption
Hi there,
TMAP Expression: row2.Inactive == "-1" ? true : false
Inactive: String Type
Destination field: Boolean Type
Error:Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Help me with it
