Hi all,
I use a job which takes input frm url & inserts it into table
bufferinput -----> oracle o/p
job is achieved with the help of context params.
the job when exported as war file works fine in my env i.e windows & oracle 11g
when i deploy the same job on a diff machine using solaris & Oracle 10g it gives an error if number of records are on higher side (greater than 100)
no error as such but the rows are rejected saying "No more data to read from socket"
job works fine if number of records are few
regards,
djugal
hi sabrina,
i am gettin the error
Exception in component tOracleOutput_1
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:558)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3674)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at ta.temp_oracle_jas_0_1.temp_oracle_jas.tFixedFlowInput_1Process(temp_oracle_jas.java:2153)
at ta.temp_oracle_jas_0_1.temp_oracle_jas.tFileInputDelimited_1Process(temp_oracle_jas.java:861)
at ta.temp_oracle_jas_0_1.temp_oracle_jas$1.run(temp_oracle_jas.java:2478)
-bash-3.00$
the job works fine in windows env so i guess its not oracle issue
is there some errors happening on sun solaris side
Thanks & regards,
djugal
Hi,
To confirm it, could you connect to the oracle 11g to see if this issue repro? In addition, so far sun solaris Platform is not supported by talend official reference:
Compatible Platforms, however, you can migrate the job script into sun solaris and then execute it.
