[makkd001]

I’m in process of developing a utility that transfers data from Informix to tables in SQL Server. Stored procedure gets the data from Informix and then Java Bean gets this data and puts in the SQL Server database. It was working earlier and then we’d added more fields in SP (more than double), Now the SP is running OK. As the Bean starts getting data (thro’ Iterator), at some point it gets out of the loop at random before it gets all the data (without any exception raised). Through Log files, we found at which point its bailing out but that is random and there is no error in that. I don’t know what’s causing this… Have any of you have got in the problem like that ?

[Haris Peco]

makkd001,

This is too general and probably Informix and/or Sql Server problem
However , try catch Throwable and sql warnings

Best

[Author]

Posts