REVENSE
Posts: 46
|
| Posted: 02/21/2007, 6:38 PM |
|
Hello all my name jun , i need some help about Page Navigator.
its about when i store about 90000 data on my database, iam using database oracle and java servelet, and when i click Last Page the page its took long time to show,
but if i click first page it's not took long time to show same as when i click the page number, example Page 6. my problem is when i click last page the page its took long time to show the data.
Can u Guys Help Me to solve this problem, 
Thx,
Jun
|
 |
 |
miko
Posts: 50
|
| Posted: 02/23/2007, 6:32 AM |
|
I think the best way to avoid such grids and use more detailed search criterias.
_________________
Regards,
Michael |
|
|
|
REVENSE
Posts: 46
|
| Posted: 02/26/2007, 5:17 AM |
|
thx for the reply miko, but can u help me more detail.
my case is when i try to lastpage with data 90000 (using grid) its took long time and made
out of memory. on that grid i just using simple sql syntax
select * from data
and on properties i change properties per/page showing to 10 and max row shown up 10
but its nothing hapen, i still got out of memory when i go to last page, can u help me to figure out,
please help me
thx
|
|
|
|
miko
Posts: 50
|
| Posted: 02/26/2007, 5:26 AM |
|
hmm... "out of memory" means that JVM was unable to get memory.
Can you describe your environment?
_________________
Regards,
Michael |
|
|
|
alpabarot
Posts: 1
|
| Posted: 03/07/2007, 8:50 PM |
|
Hey!!
Your Forum rocks!! I have a querry…
- “Seeking experienced programmer with following skills: strong browser UI background, specifically in JavaScript, AJAX, CSS, HTML. Also must have good system & software design skills, e.g. OOP. C++/C knowledge a plus”
There is this amazing site that I came across where u can make money by answering this query and sharing information…check it out here’s the link http://www.myndnet.com/login.jsp?referral=alpa83&channel=A96
The coolest part is…every time ur information gets sold u get paid for it!!
I signed it for it.. very cool stuff… u can also mail me atbarot.alpa@gmail.com
Cheers! :)
Alpa
|
|
|
|
REVENSE
Posts: 46
|
| Posted: 03/10/2007, 11:50 PM |
|
hallo Miko,thx for replay
i am using j2se ver 4, Tomcat 4 and databse oracle10g
|
|
|
|
miko
Posts: 50
|
| Posted: 03/11/2007, 11:41 PM |
|
Hi!
you can try to increase allowed memory for tomcat.
one way to do it is:
1. got to <tomcat>/bin folder
2. edit catalina.bat file
3. add line
Set JAVA_OPTS=%JAVA_OPTS% -Xmx512m
to allow to use up to 512 Mb of memory (you can change this number. default is about 128)
the shippet of file will look like this:
================================
...
:doneSetArgs
Set JAVA_OPTS=%JAVA_OPTS% -Xmx512m
rem Execute Java with the applicable properties
if not "%JPDA%" == "" goto doJpda
...
===============================
_________________
Regards,
Michael |
|
|
|
REVENSE
Posts: 46
|
| Posted: 03/13/2007, 2:40 AM |
|
Hi Miko Thx For Your Replay,
But When i changes the catalina.bat nothing changes, its same. when i am go to last page
the page take a long time to show data.
thx
jun
|
|
|
|
miko
Posts: 50
|
| Posted: 03/13/2007, 2:53 AM |
|
HI!
The main question for now if you still gets "out of memory" exception?
_________________
Regards,
Michael |
|
|
|
REVENSE
Posts: 46
|
| Posted: 03/15/2007, 11:37 PM |
|
hai
can u explain the exception mean ?? thx
btw i am connect to oracle database "oci" conection not "thin" conection, its posible that oci driver have a bug or the apche tomcat 4.1 have a bug ??
Thx
|
|
|
|
|
