Recent content by shashi12

Greg, Sorry for the confusion. The formatting got messed up during my last post. Here's what I meant. ABL ETIME First Run: 286 ms (Time measured on the Java end: 380 ms) ABL ETIME Second Run: 319 ms (Time measured on the Java end: 350 ms) ABL ETIME First Run: 288 ms...

Its just two consecutive AppObject method calls. So I would say less than a second apart. appObj.getallFotos2(resultSetHolder, timeTaken); appObj.getallFotos2(resultSetHolder, timeTaken);

Greg, Many thanks for replying. As suggested by you, I have used ETIME to measure the time taken on the AppServer end. I found that consistently the program runs slower the second time! Also I found that the time computed by ETIME matches with the time difference in the AppServer logs. Another...

Thanks for the quick reply Greg. Its good to know that many people use SQL ResultSets. :) Thanks for the tip on the server.log file. Here's what our server.log file says... [09/05/27@14:39:42.206-0600] P-003508 T-003440 2 AS AS -- TRACE: Non-PERSISTENT Procedure 'getall-fotos2.p' START. (5498)...

Hi All, This is what I read from the Java Open Client Manual (page 65): "In the Java Open Client, the default mechanism for passing either a single temp-table or a ProDataSet parameter (static or dynamic) is the OpenEdge ProDataGraph. An alternative mechanism for passing temp-tables (but not...

Thanks for your help Casper. After some trial and error stuff, I got the stored procedure to work! The bottomline is for some reason, progress doesn't like it when I declare an output parameter (OUT) of type "DATE". So, I had to resort to an INOUT parameter instead. /* Java code */...

I am not creating any tables. The error occurs even when the stored procedure is empty! thanks for your reply, casper. regards, Shashi

I am getting the following error... java.sql.SQLException: [JDBC OpenEdge Driver]:[]Invalid date value (7496) at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6636) at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6821) at...