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.

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?

and what kind of exception does your program give?

"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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.