[resolved] got minus one from a read call...ERROR!

[Anonymous]

Hi,
my job consist in read froma a table and match this with other and insert in the same table. See th screenshot IS BETTER!
I have the error got minus one from a read call, randomly on the tables of the job and if i close and reopen Talend, all warks good!!!
Why?
I work on oracle 11g and windows server2008
Thanks in advance,
Gino.

[Anonymous]

I suppose you mean an error message like this: "...the socket returns a negative value...." or similar message. In this case this means you have network problems randomly.
The other possible explanation (it would be better to know the exact message) is: some Oracle error codes are in fact negative. E.g. all user defined error messages are negative.
Please provide an example of the actual error message.
I see you read a lot tables as lookup. Your job establish alway a new connection and this could lead to a lack of possible connections. Please try to use one connection which is used by all input components and another separate connection for all output components..

[Anonymous]

Hi jlolloing,
probably is a connection problem (I work on a server and DB is in another server), infact i coud not reply the error...is RANDOM!
Now if i want to use one connection which is used by all output or input components, can you explain me the way?
Thanks in advance,
Gino.

[Anonymous]

Hi,
This is component reference about tOracleConnection.
In addition, here are some related forums about tOracleConnection https://community.talend.com/t5/Design-and-Development/tOracleConnection-gt-performances/td-p/93888, https://community.talend.com/t5/Design-and-Development/How-to-use-the-same-tOracleConnection-in-the-.... Hope it will be helpful for you.
Best regards
Sabrina

[Anonymous]

Hi,
i have the error again:
Inizio job Applicazione_Regole_DAT_NOMAP_NOEST: 14:39 19/04/2013.
connecting to socket on port 3659
connected
Exception in component tOracleOutput_9
java.sql.SQLException: Got minus one from a read call
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at sba.applicazione_regole_dat_nomap_noest_0_1.Applicazione_Regole_DAT_NOMAP_NOEST.tOracleInput_1Process(Applicazione_Regole_DAT_NOMAP_NOEST.java:9481)
at sba.applicazione_regole_dat_nomap_noest_0_1.Applicazione_Regole_DAT_NOMAP_NOEST.runJobInTOS(Applicazione_Regole_DAT_NOMAP_NOEST.java:24574)
at sba.applicazione_regole_dat_nomap_noest_0_1.Applicazione_Regole_DAT_NOMAP_NOEST.main(Applicazione_Regole_DAT_NOMAP_NOEST.java:24442)
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:243)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 9 more
disconnected
For Sabrina...now I will read your suggestions, thanks.
Best Regards,
Gino.

[Anonymous]

Could you please check this connection with a external JDBC based SQL client like SQLSquirrel or SQLWorkbench?
It looks like you have a network problem or a problem in the configuration of the database.

[Anonymous]

I'm always connect with the Oracle Db with a sql client...i don't understand... but probably is a connection problem. On Monday, make a test with oracleconnection component...
Thanks

[Anonymous]

Hi,
What is your new designed work flow with tOracleConnection? Do you use tOracleClose and tOracleCommit. More screenshots of your job will be appreciated.

[Anonymous]

Hi Sabrina,
at this moment I have not changed the job with the tOracleConnection component, when I do I will use also tOracleClose and tOracleCommmit componets, thanks for suggentions...
Gino.

[Anonymous]

Hi,
Thanks for your response, if you have any problem when using tOracleConnection component, feel free post your issue on forum.
Best regards
Sabrina