0.5 seconds for the database to process.
The JDBC driver will get them from across the network
to the Servlet container.
The servlet container will process them using a JSP
/ Servlet and format it to HTML.
1. There is the time to retrieve from the network
2. Formatting time by the JSP.
3. Sending
Along the line Marc was saying, you probably want to limit your resultset by
altering your sql to make a smaller return value.
- Original Message -
From: Marc te Vruchte [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 07, 2002 5:47 AM
Subject: Re: Speeding up Resultsets
PROTECTED]
Subject: Re: Speeding up Resultsets
Along the line Marc was saying, you probably want to limit your
resultset by
altering your sql to make a smaller return value.
- Original Message -
From: Marc te Vruchte [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 07
: Speeding up Resultsets
Have a look at using Count(*) and Limit x,y functions in SQL to achieve
the desired effect.
-Original Message-
From: A mailing list about Java Server Pages specification and reference
[mailto:JSP-INTEREST;JAVA.SUN.COM] On Behalf Of Steven A. Martin
Sent: 07
[mailto:JOSHYMON;NESTEC.NET]
Sent: Thursday, November 07, 2002 5:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Speeding up Resultsets
Hi,
You should be lucky if you saw all the 14000 records in 2.5 minutes.!!
My observation is that I see the browser hung with even 1200
records approx.
The reason
Hi,
I have about 14,000 records and I run a simple query to display that and
it took me half a second to see the results.
But If I display the result on the browser it takes me about 2-2.5 mts.
Is there a way to speed up displaying these records in my browser?
Regards,
Daniel.E
Hi ALL,
Does anybody know how to access multiple resultsets from a Java application
The 'rs.next' only loops thruogh a single recordset. However I need to
handle mulpiple resultsets comming fro a Store procedure
Please Help
Lopez" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 8:54 AM
Subject: multiple resultsets
Hi ALL,
Does anybody know how to access multiple resultsets from a Java
application
The 'rs.next' only loops thruogh a single recordset. However I need to
handle mulpiple
hi,
i think it depends of jdbc driver and database
i try it with oracle and it works, but i try with sqlserver and don't works
regards,
Antonio Jimenez
David Mellado wrote:
Hi!
Is It possible to open two ResultSet objects with a same Connection, at the
same time? When I try, to do it, it
]
Fecha: martes, 13 de febrero de 2001 9:54
Asunto: Re: Resultsets
hi,
i think it depends of jdbc driver and database
i try it with oracle and it works, but i try with sqlserver and don't works
regards,
Antonio Jimenez
David Mellado wrote:
Hi!
Is It possible to open two ResultSet objects
and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of David Mellado
Sent: Tuesday, February 13, 2001 2:47 AM
To: [EMAIL PROTECTED]
Subject: Resultsets
Hi!
Is It possible to open two ResultSet objects with a same Connection, at the
same time? When I try, to do it, it causes an exception.
Regards
.
% Visit my HomePage %
zac:forward http://prosurfr.tripod.com /zac:forward
- Original Message -
From: "Antonio Jimenez" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 4:48 PM
Subject: Re: Resultsets
hi,
i think it depends of jdbc driver and datab
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 14, 2001 12:55 PM
Subject: Re: Resultsets
No
You can use disconnected resulset for it.
--
From: zac[SMTP:[EMAIL PROTECTED]]
Reply To: A mailing list about Java Server Pages specification and
refere
Hi!
Is It possible to open two ResultSet objects with a same Connection, at the
same time? When I try, to do it, it causes an exception.
Regards
David Mellado
[EMAIL PROTECTED]
===
To unsubscribe: mailto [EMAIL PROTECTED]
A suggestion for a "clean" implementation on a model 1 design:
a) Create a bean encapsulating your "table". This bean should take care
of your application logic, calling the database through JDBC and
returning your data as a native object (like a collection of "rows"). A
simple approach is to
/tr
%
}
}
stmt.close();
con.close();
%
/TABLE/BODY/HTML
-Original Message-
From: Walter Priesnitz Filho [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 February 2001 4:43
To: [EMAIL PROTECTED]
Subject: JSP + ResultSets
Hi all,
I need help with an apllication.
I need make
somewhere on these lists.
Good luck.
-Original Message-
From: Walter Priesnitz Filho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:43 AM
To:
Subject: JSP + ResultSets
Hi all,
I need help with an apllication.
I need make a query in an Oracle Table and put the result in a html
Hi all,
I need help with an apllication.
I need make a query in an Oracle Table and put the result in a html table.
How can I pass the resultset from Oracle to JSP?
Does anybody help-me???
You don't "pass the resultset from Oracle to JSP."
I don't know what kind of architecture you're using,
-
- Original Message -
From: "Joseph Ottinger" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 4:01 PM
Subject: Re: JSP + ResultSets
Hi all,
I need help with an apllication.
I need make a query in an Oracle Table and put
11:37 AM
To: [EMAIL PROTECTED]
Subject: Re: JSP + ResultSets
I found a code in Java Developer's Journal and I'm trying but I'm not vad
success.
Could you help-me?
Thanks...
-
Walter Priesnitz Filho
Mestrando em Ciencia da Computacao
[EMAIL PROTECTED
iencia da Computacao
[EMAIL PROTECTED] | [EMAIL PROTECTED]
http://www.inf.ufsc.br/~walterp
-
- Original Message -
From: "Walter Priesnitz Filho" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 5:36 PM
Subject: Re: Re: JS
g Yee" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 5:37 PM
Subject: Re: JSP + ResultSets
You should send us the code that you're having problems with so that we'll
know the details of your problem.
Please be as specific as possible so that we don't have
]
Subject: Re: JSP + ResultSets
Ok...
I'm been clouddy... heheheh
I'm working with Tomcat 4.01b and I have a database in Oracle.
I'd installed tomcat and I know I need use JDBC to do the connection with my
database, so I put the file classes12.zip(Oracle 8i jdbc file) in the
classpath.
But the code I
Hi Folks,
Two (hopefully) quick questions...(and one hard one!)
1. How can I update the value of a session var? When someone on my site fills
in a form, I need the var to update for the rest of the session - do I just
use putValue? This doesn't seem to be working, any suggestions?
2. How
At 08:42 PM 10/31/00 +1000, Kate McNamara wrote:
1. How can I update the value of a session var? When someone on my site fills
in a form, I need the var to update for the rest of the session - do I just
use putValue? This doesn't seem to be working, any suggestions?
putValue is deprecated
Hi!
I have found that I can't ask the same Recordset field two times with
getString() or equals. I get the SQL exception "no Data" on second try. Is
this a rule or a mistake on my side?
here is some code where it happens:
try {
String RSTB3000_Query = "SELECT ROUTING_AREA FROM
Hi
I was wondering how people are handling searches when using the jsp model 2
architecture ??
I am converting an all servlet based application to a jsp/servlet
architecture using model 2. I have a jsp page which displays the search
form. This allows them to enter their search criteria. When
Hi
yeah you can acess the value only once thru getString so stor it in a
variable and acess it wherever u want
with regards,
Kumaran
Cognizant Technology Solutions India Ltd,
1st Floor ,T.S.140 No 2 9,
C.P.T Road .Taramani
Chennai - 600 113.
PROTECTED]
Subject: JPS Model 2 and ResultSets
Hi
I was wondering how people are handling searches when using the jsp model 2
architecture ??
I am converting an all servlet based application to a jsp/servlet
architecture using model 2. I have a jsp page which displays the search
form. This allows
Model 2 and ResultSets
Hi
I was wondering how people are handling searches when using the
jsp model 2
architecture ??
I am converting an all servlet based application to a jsp/servlet
architecture using model 2. I have a jsp page which displays the search
form. This allows them to enter
ResultSets should be used left-to-right, top-to-bottom. There is no
guarantee that once a row/column has bee readm that it can be re-read. Also
there is no guarantee that columns can be read out of order (i.e.
rs.getString(2); rs.getString(1); will probably fail). From the help
'. For maximum
Hi
I am developing a site using JSP and Servlets using the Model View
Controller design pattern. At the moment, any information that is to be
displayed in the page is retrieved from the database in the Servlet, placed
into some sort of Object which is then placed in a Vector. This Vector is
then
Hi Peter,
I suggest u send the whole result set page to the user as a Hidden form
field and fileter out only those elements from the hidden form field that
the user requests. This will keep ur server free and also keep ur client
busy.
regards,
srinirao.
([EMAIL PROTECTED])
"Donald E. Vandenbeld" wrote:
Yes, the resultset beans that I use have a session scope so they are dealt
with when the user either logs out or times out. The problem is one of
scalability. There are a a few resultset beans that could potentially be
quite large. If you multiply this by the
you can use applet bridge for calling your
server-side classes from JavaScript. It works
on the top of HTTP and Ok with firewalls.
See http://coldjava.hypermart.net/servlets/j2j.htm
Another way of doing it would be to use an applet and have the CORBA
connectivity directly between the browser and
sday, March 30, 2000 11:37 PM
Subject: Re: Returning large resultsets
"Donald E. Vandenbeld" wrote:
What I'm after is a methodology for caching a large resultset so that
you can 'page' through it and 'elegantly' being able to dispose of
the resultset cache when you leave the
What I'm after is a methodology for caching a large resultset so that
you can 'page' through it and 'elegantly' being able to dispose of
the resultset cache when you leave the resultset display page.
Did you try to use a cleanup method triggered by a JavaScript onUnload
event ?
/
--
From: Donald E. Vandenbeld[SMTP:[EMAIL PROTECTED]]
Reply To: Donald E. Vandenbeld
Sent: Monday, March 27, 2000 6:58 AM
To: [EMAIL PROTECTED]
Subject: Returning large resultsets
I have a question about implementation that I'd love some input
"Donald E. Vandenbeld" wrote:
What I'm after is a methodology for caching a large resultset so that
you can 'page' through it and 'elegantly' being able to dispose of
the resultset cache when you leave the resultset display page.
Did you try to use a cleanup method triggered by a JavaScript
Hi Donald,
It sounds like my Pager Tag Library is just what your looking for.
Check out http://jsptags.com/tags/navigation/pager/
-James
I have a question about implementation that I'd love some input on.
The Problem:
I have a web application that has to return variable length resultsets
.
It sounds like my Pager Tag Library is just what your looking for.
Check out http://jsptags.com/tags/navigation/pager/
-James
I have a question about implementation that I'd love some input on.
The Problem:
I have a web application that has to return variable length resultsets,
sometimes
I have a question about implementation that I'd love some input on.
The Problem:
I have a web application that has to return variable length resultsets,
sometimes quite large (a few 100 rows max). There are several tables that
might return large resultsets and each gets viewed in a different
Daniel Rönnqvist wrote:
Could someone give me some hints about the following things:
- When should I close my resultsets, statements and connections in
comparrison to commit (I use auto commit off) and each other ?
Close your connection (or free it back into your Connection pool) as soon
I tested the JDBC CachedRowSet
http://developer.java.sun.com/developer/earlyAccess/crs/index.html
"JDBCTM CachedRowSet is an implementation of the Rowset interface. The
Rowset interface is part of the JDBC 2.0 Standard Extension API.
CachedRowSet provides a disconnected, serializable,
, June 15, 1999 7:25 AM
Subject: ADO vs ResultSets
With ADO it is possible to create a disconnected recordset via a
DataFactory
on the web server and hook it up to data aware (ActiveX) controls in a
web
browser. So by writing little more than the SQL statement to define the
data
source it is possible
45 matches
Mail list logo