Please I need help wirh my job so i have a problem with tmap(inner join)

I do a map with inner join between 2 tables(Primera_parte, PNACIMI ) in oracle, and i use globalMap and the query is:

"SELECT PNACIMI.TOMO,
        PNACIMI.CLASE,
        PNACIMI.PAGINA,
        PNACIMI.ACTA,
        PNACIMI.NOMB50,
        PNACIMI.DIA,
        PNACIMI.MES,
        PNACIMI.ANO,
        PNACIMI.LUGNAC,
        PNACIMI.SEXO
FROM    PNACIMI
WHERE NOMB50 like '"+ (globalMap.get("row1.MANOMB"))+ "%'" +
"and DIA = '"+ ((Integer)globalMap.get("row1.MADIAN")) + "'" +
"and MES = '"+ ((Integer)globalMap.get("row1.MAMESN")) + "'" +
"and ANO = '"+ ((Integer)globalMap.get("row1.MAANIN")) + "'"

IS IMPORTANT SAY THAT THE JOB RUN GOOD UNTIL GET ERROR BUT WHEN I TRY DO GuessSCHEMA IN TORACLEINPUT SHOW THIS MESSAGE "Connect to DB error, or some errors in SQL query string, or GUESS SCHEMA not compatible with current SQL query string"

so when i execute running well until get error in undefined row and the error say:


Exception in component tOracleInput_3
java.sql.SQLException: Excepción de E/S: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at talenddemosjava.segunda_parte_0_1.Segunda_Parte.tOracleInput_3Process(Segunda_Parte.java:2672)
    at talenddemosjava.segunda_parte_0_1.Segunda_Parte.tOracleInput_2Process(Segunda_Parte.java:1216)
    at talenddemosjava.segunda_parte_0_1.Segunda_Parte.runJobInTOS(Segunda_Parte.java:3691)
    at talenddemosjava.segunda_parte_0_1.Segunda_Parte.main(Segunda_Parte.java:3519)

Why dont execute everything? Please Anyone could help me ..??? What can i do?

Last edited by eddy (2010-08-25 20:30:18)