When I run the jsp page below, and then look at the Oracle cursor count
with:select * form v$sysstat where name='opened cursors
current'I see the cursor count jump, and linger long after the page
has finished loading. Eventually the count drops, BUT I would like to know
WHY the
.
-Original Message-From: Keith Kwiatek [mailto:[EMAIL PROTECTED]]Sent:
Wednesday, August 01, 2001 4:12 PMTo:
[EMAIL PROTECTED]Subject: Why won't my JSP page bean
release Oracle cursor?
When I run the jsp page below, and then look at the Oracle cursor
count
cursor limit set to 50.
you need to increase the limit.
Zahid
- Original Message -
From:
Keith Kwiatek
To: [EMAIL PROTECTED]
Sent: Monday, July 30, 2001 9:32
PM
Subject: JSP JDBC bean doesn't seem to
release cursor
it is virtually closed, of course it returns it to the pool
BUT what about my explicit calls for the result set and statement to be
closed? Why doesn't this immediately release the cursor from the oracle
database... instead it lingers
Keith
- Original Message -
From: Mattias
1 9:31
AM
Subject: Re: JSP JDBC bean doesn't seem
to release cursor !?
A
proper value for open_cursors is about 800 because Oracle uses a lot of
recursive SQL statements in the server.
-Original Message-From: Keith Kwiatek [mailto:[EMAIL PROTECTED]]Sent:
Tuesday, July
Hello,
I am running oracle 8.1.6, and the 1.5.2 orion
server.
I am using connection pooling.
I am using a JSP page with a jdbc java bean.
Everything works fine, except if I execute about 40-50 rapid
executions of the JSP page, I run out of cursors.
I have rs.close, stmt.close commands
Hello,
In my pursuit of mastering JSP/JDBC/Java I wrote a utility that interrogates
an oracle database table and then generates the correlated JSP forms and
JDBC beans to search/update/insert/delete rows from the database table. By
pointing the utility at a few related tables you can quickly
Hello,
I was thinking of a utility that would interrogate a set of database tables,
and then generate java beans that would be able to get/set, update, delete,
insert, and validate.. the beans could then be dropped onto an html
page (as in Macromedia Ultradev 4).
Has anyone found anything
Yes but this is a variation of a client side solution that I have already
used. Client side solutions without serverside validation rules are not
wise. The golden rules of client/server systems is the server should never
trust the client, and also users are stupid.
Keith
- Original
Yes, I think this is what does in fact happen... BUT there must be a
serverside method for handling this, since this is potentially very
destructive if two requests come in to subtract $10 from account xyz.
I was thinking that the session would contain a sequence number embedded in
the HTML,
Hello,
What is the preferred server side method for handling double clicks on a
submit button.
It would seem that if a user clicks twice on the submit button that there
will be two near simultaneous requests. In the past I have handled this with
some java script that would only send a single
Hello,
I have a jsp application running on a www.orionserver.com platform.
How/when/why does JSP (or is it orion) add the jsessionid to my canned query
link?
I am not familiar with the ; seperating the http variables STATUS and
jsessionid --what is with this ?
1)
Does anyone have some free tickets they can give me to JavaOne?
Keith
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
I think you mean "any time you want to work pessimistically"
This is an outstanding issue I have also been wrestling with the same
thing for a while now and it seems, for now, that the kludgy timestamp
method is about the only solution I saw some more discussion on this
issue
Hello,
Anyone have examples of using javamail and JSP I am particularly
interested in example with receiving attachments...
Keith
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For
Hello,
I need a quick example of a jsp page doing insert, update and deletes of
CLOB fields in oracle or please point me to a specific "how to"...
Thanks!
Keith
===
To unsubscribe: mailto [EMAIL PROTECTED] with body:
Hello,
I have an application that get email with attachments is there a
JSP/java package that will parse the email and decode the attachments (for
writing out to a file)?
Thanks!
Keith
===
To unsubscribe: mailto [EMAIL
dreamweaver ultradev is out. I am not sure about webgain... I sent them an email
asking them about rumors of a visual jsp product --their response didn't make it seem
that it was going to be "all that visual a jsp product".
Keith
--Original Message--
From: Kevin Duffey [EMAIL
Hello,
Which JSP engine to use ---Tomcat, Resin, orion, websphere ?
Which is the most popular/supported?
Resin seems very fast
Keith
===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Hello,
What do you guys think about Dreamweaver UltraDev? I don't think the generated code is
very pretty (no beans?!) BUT it is able to visually (and quickly) pull together a
database query/insert/update and bind it to HTML "widgets". you can visually move
JSP tags around, and jump to
Hello,
Pardon the newbie question, but as I understand it, when designing jsp applications,
you have two options:
1) call the jsp page directly, and then reference a bean
2) call a servlet that instantiates the bean for display in a jsp page.
Off-hand I think I like option 1 best, call the jsp
Hello,
Ok, I am sold on JSP's seperation of code/html, But I also understand that
there are a few different JSP "MODELS" Which is the most widely used for
general JDBC access?
Can I call a JSP page directly, that references a JDBC bean? Does the "bean"
therefore become the main code body
If you are using JSP to do web applications, how are you using JSP
to hand the fact that the web server connection to the database is
non-persistant?
For example, User "A" fetches a row for display in web page (db connection
ends). At the same time user"B" fetches the same data for display in
Seperation of data/logic is critical to dynamic and "multi-view" web sites.
What I question is the overhead of JSP compared to a regular servlet that
just uses a template object like : http://freemarker.org/ . Seems to me
that there MIGHT be overhead issues with jsp.
Keith
- Original
Does anyone have any performance benchmarks on this vs. "model 1" vs. the
standard templating model to which Keith was referring? Does the 0.92
getRequestDispatcher() stuff address these issues?
I agree, where is the benchmarking! I can't believe everyone here is charging
full ahead with
The difference is that http://www.bgeer.com/dexios doesn't "compile" the
templates into servlets. The templates have macro variables, loops, and
conditionals --that are evaluated by the servlet, and then macro variable
substitution is performed and the template is output. (see
Hello all,
I am looking for some simple "hello database" type JSP pages that use JDBC beans
to display rows from a database
Can anyone point me in the right direction?
Thanks!
Keith
===
To unsubscribe, send email to
In other words --where is there a simple example of "model 2" from the JSP spec?
Thanks
Keith
I am looking for some simple "hello database" type JSP pages that use JDBC
beans
to display rows from a database
Can anyone point me in the right direction?
one more thing the purpose of my original post was also to flesh out in my
own mind the JSP "model 2" flow.+ performance with regards to HTML/code
separation... My understanding is that in the JSP model 2, a servlet takes a
requests, goes to the database to fetch some rows, encapsulates
The dexios templates that I referenced, do not "compile" the template in the
sense that JSP compiles a template. "parse" would be a better word. AND it only
parses it ONCE The dexios method provides for true code/html seperation (an
html person could only manipulate html macro tags), and I
I have been reading some of the emails about JSPI don't see what is so
great about it... What is the big advantage of putting the code in the
template vs. the servlet class directory? If I want to seperate my html from
my application, it seems there are more efficient ways than using JSP
31 matches
Mail list logo
