• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB problem

 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like it could be a performance problem. Have you tried profiling your SQL statements?
 
Rob Spoor
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This would fit better in the JDBC forum. Off we go!
 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic