A database problem

Reply

Join Date: Jan 2008
Posts: 54
Reputation: Xessa is an unknown quantity at this point 
Solved Threads: 0
Xessa Xessa is offline Offline
Junior Poster in Training

A database problem

 
0
  #1
Jun 10th, 2009
Hello people.

I seem to connect and select the data i want from a specific and big table. But when the information to be selected is small, everything is allright. But when i try to select information that is not that much small. For example when i select from 3000 columns, my program gives error.

Web container has been active for 80000 miliseconds.

Also says that there are some number of threads that are hung.
Last edited by Xessa; Jun 10th, 2009 at 8:50 am.
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 2,612
Reputation: adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of adatapost has much to be proud of 
Solved Threads: 463
Moderator
adatapost's Avatar
adatapost adatapost is offline Offline
Posting Maven

Re: A database problem

 
0
  #2
Jun 10th, 2009
Originally Posted by Xessa View Post
Hello people.

I seem to connect and select the data i want from a specific and big table. But when the information to be selected is small, everything is allright. But when i try to select information that is not that much small. For example when i select from 3000 columns, my program gives error.

Web container has been active for 80000 miliseconds.

Also says that there are some number of threads that are hung.
Which database product are you using?
Failure is not fatal, but failure to change might be. - John Wooden
Reply With Quote Quick reply to this message  
Join Date: Jan 2007
Posts: 706
Reputation: stultuske is a jewel in the rough stultuske is a jewel in the rough stultuske is a jewel in the rough 
Solved Threads: 84
stultuske's Avatar
stultuske stultuske is offline Offline
Master Poster

Re: A database problem

 
0
  #3
Jun 10th, 2009
and what kind of exception does your program give?
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 54
Reputation: Xessa is an unknown quantity at this point 
Solved Threads: 0
Xessa Xessa is offline Offline
Junior Poster in Training

Re: A database problem

 
0
  #4
Jun 10th, 2009
"J2CA0294W: Deprecated usage of direct JNDI lookup of resource"


But i don'T get any warnings or errors when i choose small numbers.


select * from myTable where (myId between 1 and 100) works

select * from myTable where (myId between 1 and 10000) doesn'T work...

HELP needed. What might the problem be?
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC