jdbc Statement hangs

[Former Member]

Folks ,

I have writen some jdbc code and my applications hangs intermittently, we are using oracle database .

Thanks,

Manish

[Former Member · Accepted solution]

Hi Manish,

Your SQL query is running into infinite loops and because of that your application is hanging intermittently.

Did you check your SQL query by executing it before implementing it in your application. If it was working fine in SQL browser then data might causing some issue. Try to execute the query in SQL browser with the same data what your application is passing.

Hope this helps!

Regards,

Jaya.

[Former Member · Accepted solution]

Folks,

Thanks for reply. Actaully my query works fine when I run in standalone program . But with Webdynpro sometime it runs and sometime it hangs. I am using the same datasource which J2EE Engine uses.

Thanks

Manish

[Former Member]

Hi,

What do you mean by "applications hangs intermittently"?

But try to put following logic to figure out what is the time taken by jdbc sql query.

a) get system time before the execution of sql query and store it in temp variable t1

b) get system time after the execution of sql query and store it in temp variable t2

c) Find out the difference and print it

Once you are confident that SQL query is the one taking longer than expected time, check with Oracle experts in your org. for analyzing the log for the query and reasons for taking so much time

regards,

ganga