aspose file tools*
The moose likes JDBC and the fly likes DB problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB problem" Watch "DB problem" New topic
Author

DB problem

Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

Hi guys,

i'm facing a weird problem with oracle db ,i'm trying to connect ot it to get some data then put this data in Vector to use it later , the problem is sometime the db staty without retriving any thing so i check the sql statment it;s ok , i check the db connection it's ok , so i debugued my code i found it some times it stops (i mean sitting without any response) in this code :



PS: no exception given

here is the code for more clarification


Thanks,
Sherif
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Sounds like it could be a performance problem. Have you tried profiling your SQL statements?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19696
    
  20

This would fit better in the JDBC forum. Off we go!


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 483

Originally posted by Paul Sturrock:
Sounds like it could be a performance problem. Have you tried profiling your SQL statements?


Hi , i tried the the SQL statements outside the code , the weird thing sometimes it getting results , and sometimes it hangs !!! although the db connection is fine !!!
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I'd profile your queries. You may be missing indices or their statistics may need rebuilt. If you are unsure how to do this, have a read of your Oracle docs for "explain plan" in the performance tunning book.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB problem