Re: Dreamweaver MX (announced today) adds JSP custom tag library
After a quick glanse it seems to me they have not yet implemented the one feature I think would be really useful in JSP development; possibility to define the preview of tags. Assume I'm using Struts (I'm not, but we have a tag library quite similary to that of Struts). If I want to create a form in Dreamweaver I want to be able to preview that form in the Desin View. But the is invisible in Design View. Instead I would like it to show as -Original Message- yeah, yeahonly question is : What took them so long ? That initial implementation of JSP in 4.0 was a big P O S. > -Original Message- > From: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Bang > Sent: Monday, April 29, 2002 5:40 AM > To: [EMAIL PROTECTED] > Subject: Dreamweaver MX (announced today) adds JSP custom tag library > support > > > Today Macromedia announced Dreamweaver MX, which replaces both Dreamweaver > and Dreamweaver Ultradev. With this new version, you can quickly > import tag > library information from TLD files and make this information available in > Code Hints drop-down menus, a Tag Chooser, and the Tag Inspector. > For more > details, go to: > > http://www.macromedia.com/software/dreamweaver/ > > A Preview version is available. > > Steve > > Disclaimer: I don't work for Macromedia, but have been a Dreamweaver user > since v. 1.0. Mattias Jiderhamn Expert Systems [EMAIL PROTECTED] === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: GET A Random picture
Hello everybody, How can refer to my website with a virtual address instead of the real directory path? The site has been hosted on Apache Tomcat4.0. I think that I need to change something in the web.xml but I am not what exactly I got to do. Kindly help. Thanx in advance. Regards, aruniima This message contains privileged and confidential information and is intended only for the individual named. If you are not the intended recepient you should not disseminate, distribute, store, print, copy or deliver this message. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and immediately delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Virtual path for website...
Hello everybody, How can refer to my website with a virtual address instead of the real directory path? The site has been hosted on Apache Tomcat4.0. I think that I need to change something in the web.xml but I am not what exactly I got to do. Kindly help. Thanx in advance. Regards, aruniima This message contains privileged and confidential information and is intended only for the individual named. If you are not the intended recepient you should not disseminate, distribute, store, print, copy or deliver this message. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and immediately delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: Dreamweaver MX (announced today) adds JSP custom tag library
This is typical of Macro. they listen to NO ONEand have this "know it all" attitudeso California-like. We told them about the terrible limits of their DW extension model 2 years ago when it was apparent that Adobe's GoLive had a much more robust DHTML extension framework. Their response was "so what ?" ! meaning: "you can't tell us what to do" > -Original Message- > From: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED]]On Behalf Of Mattias J > Sent: Thursday, May 02, 2002 3:28 AM > To: [EMAIL PROTECTED] > Subject: Re: Dreamweaver MX (announced today) adds JSP custom tag > library > > > After a quick glanse it seems to me they have not yet implemented the one > feature I think would be really useful in JSP development; possibility to > define the preview of tags. > > Assume I'm using Struts (I'm not, but we have a tag library quite similary > to that of Struts). > If I want to create a form in Dreamweaver I want to be able to > preview that > form in the Desin View. But the is > invisible > in Design View. Instead I would like it to show as > > -Original Message- > > yeah, yeahonly question is : What took them so long ? > > That initial implementation of JSP in 4.0 was a big P O S. > > > > -Original Message- > > From: A mailing list about Java Server Pages specification and reference > > [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Bang > > Sent: Monday, April 29, 2002 5:40 AM > > To: [EMAIL PROTECTED] > > Subject: Dreamweaver MX (announced today) adds JSP custom tag library > > support > > > > > > Today Macromedia announced Dreamweaver MX, which replaces both > Dreamweaver > > and Dreamweaver Ultradev. With this new version, you can quickly > > import tag > > library information from TLD files and make this information > available in > > Code Hints drop-down menus, a Tag Chooser, and the Tag Inspector. > > For more > > details, go to: > > > > http://www.macromedia.com/software/dreamweaver/ > > > > A Preview version is available. > > > > Steve > > > > Disclaimer: I don't work for Macromedia, but have been a > Dreamweaver user > > since v. 1.0. > > Mattias Jiderhamn > Expert Systems > [EMAIL PROTECTED] > > == > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: Dreamweaver MX (announced today) adds JSP custom tag library
Anyone know which JSP versions they're going to support? I don't see anything on their website. "M. Simms" <[EMAIL PROTECTED]> wrote: > This is typical of Macro. > they listen to NO ONEand have this "know it all" attitudeso > California-like. > > We told them about the terrible limits of their DW extension model > 2 years > ago when it was apparent that Adobe's GoLive had a much more robust > DHTML > extension framework. > > Their response was "so what ?" ! > > meaning: "you can't tell us what to do" > > > -Original Message- > > Wrom: KPNKMBIPBARHDMNNSKVFVWRKJVZCMHVIBGDADRZFSQHYUCDDJBLVLMHAALPTCXLYRW > > [mailto:[EMAIL PROTECTED]]On Behalf Of Mattias J > > Sent: Thursday, May 02, 2002 3:28 AM > > To: [EMAIL PROTECTED] > > Subject: Re: Dreamweaver MX (announced today) adds JSP custom tag > > library > > > > > > After a quick glanse it seems to me they have not yet implemented > the one > > feature I think would be really useful in JSP development; possibility > to > > define the preview of tags. > > > > Assume I'm using Struts (I'm not, but we have a tag library quite > similary > > to that of Struts). > > If I want to create a form in Dreamweaver I want to be able to > > preview that > > form in the Desin View. But the is > > invisible > > in Design View. Instead I would like it to show as > > > > -Original Message- > > > > yeah, yeahonly question is : What took them so long ? > > > > That initial implementation of JSP in 4.0 was a big P O S. > > > > > > > -Original Message- > > > Wrom: TQTIPWIGYOKSTTZRCLBDXRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGS > reference > > > [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Bang > > > Sent: Monday, April 29, 2002 5:40 AM > > > To: [EMAIL PROTECTED] > > > Subject: Dreamweaver MX (announced today) adds JSP custom tag library > > > support > > > > > > > > > Today Macromedia announced Dreamweaver MX, which replaces both > > Dreamweaver > > > and Dreamweaver Ultradev. With this new version, you can quickly > > > import tag > > > library information from TLD files and make this information > > available in > > > Code Hints drop-down menus, a Tag Chooser, and the Tag Inspector. > > > For more > > > details, go to: > > > > > > http://www.macromedia.com/software/dreamweaver/ > > > > > > A Preview version is available. > > > > > > Steve > > > > > > Disclaimer: I don't work for Macromedia, but have been a > > Dreamweaver user > > > since v. 1.0. > > > > Mattias Jiderhamn > > Expert Systems > > [EMAIL PROTECTED] > > > > == > > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set > > JSP-INTEREST DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > === > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Just when I thought I was starting to understand....
I'm new to JSP and have been doing a little tutorial from O'reilly for the past week in an attempt to run servlets using packages. I'm getting close, but am running into a problem with my web.xml file (I think). This is what my doctype header looks like: http://java.sun.com/dtd/web-app_2_3.dtd";> login com.onjava.login and this is my Tomcat Startup Error: Parse Error at Line 1 Column 10 org.xml.sax.SAXParseException: Element type "servlet" must be declared Any help is greatly appreciated. Thanks in advance. Beau === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: Just when I thought I was starting to understand....
-Mensagem original- De: Beau Hebert [mailto:[EMAIL PROTECTED]] Enviada: quinta-feira, 2 de Maio de 2002 18:47 Para: [EMAIL PROTECTED] Assunto: Just when I thought I was starting to understand I'm new to JSP and have been doing a little tutorial from O'reilly for the past week in an attempt to run servlets using packages. I'm getting close, but am running into a problem with my web.xml file (I think). This is what my doctype header looks like: http://java.sun.com/dtd/web-app_2_3.dtd";> login com.onjava.login and this is my Tomcat Startup Error: Parse Error at Line 1 Column 10 org.xml.sax.SAXParseException: Element type "servlet" must be declared Any help is greatly appreciated. Thanks in advance. Beau well based on your example your complete web xml could look something like this http://java.sun.com/j2ee/dtds/web-app_2_2.dtd";> login com.onjava.login login /login check all tags.. hope this helps wills === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
PreparedStatement vs Statement
is there a considerable difference, if I create PreparedStatement instead of Statement after i get my DB connection? are there pitfalls i should be aware about (using PreparedStatement)? kenny === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: PreparedStatement vs Statement
Dear all, >From the DB Perspective, use of Prepared statement reduces the memory usage as prepared statement uses bind variables . The query is parsed once for several execution. It is always recommended to use prepared statement where ever possible . Suresh >From: "Lai, Kenny" <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and >reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: PreparedStatement vs Statement >Date: Thu, 2 May 2002 14:41:20 -0400 > >is there a considerable difference, if I create PreparedStatement instead >of >Statement after i get my DB connection? >are there pitfalls i should be aware about (using PreparedStatement)? > >kenny > >=== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: PreparedStatement vs Statement
Hi, I think other wise. Prepared statements are best to be avoided unless you are trying to execute some queries which cannot be done from statement object.like batch processing. From the article below I can conclude that gain in performance of the PStatement becomes visible only after 50-100 successive inserts. Doing a simple search on google gives so much info. Instead of guessing which is better please have a look at this link. http://www.onjava.com/pub/a/onjava/excerpt/oraclejdbc_19/ ~ Cheers Ashwani Kalra http://www.geocities.com/ashwani_kalra/ ~ - Original Message - From: "suresh kumar Durairaj" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 6:51 AM Subject: Re: PreparedStatement vs Statement > Dear all, > > From the DB Perspective, > use of Prepared statement reduces the memory usage as prepared statement > uses bind variables . The query is parsed once for several execution. It is > always recommended to use prepared statement where ever possible . > > Suresh > > > >From: "Lai, Kenny" <[EMAIL PROTECTED]> > >Reply-To: A mailing list about Java Server Pages specification and > >reference <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED] > >Subject: PreparedStatement vs Statement > >Date: Thu, 2 May 2002 14:41:20 -0400 > > > >is there a considerable difference, if I create PreparedStatement instead > >of > >Statement after i get my DB connection? > >are there pitfalls i should be aware about (using PreparedStatement)? > > > >kenny > > > >=== > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > >JSP-INTEREST". > >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > >DIGEST". > >Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > === > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: PreparedStatement vs Statement
The primary reason to use PreparedStatement has nothing to do with performance. When you are building your query for a Statement: String sql = "SELECT * FROM theTable WHERE name = '" + name + "'"; What malicious code do you think could be inserted by users free to pick their own names? Answer: lots. With PreparedStatement, you never need to worry about escaping. Jeff Schnitzer [EMAIL PROTECTED] > -Original Message- > From: Ashwani Kalra [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 8:58 PM > To: [EMAIL PROTECTED] > Subject: Re: PreparedStatement vs Statement > > Hi, > I think other wise. Prepared statements are best to be avoided unless you > are trying to execute some queries which cannot be done from statement > object.like batch processing. From the article below I can conclude that > gain in performance of the PStatement becomes visible only after 50-100 > successive inserts. > > Doing a simple search on google gives so much info. Instead of guessing > which is better please have a look at this link. > > http://www.onjava.com/pub/a/onjava/excerpt/oraclejdbc_19/ > > ~ > Cheers > Ashwani Kalra > http://www.geocities.com/ashwani_kalra/ > ~ > > > > > > > - Original Message - > From: "suresh kumar Durairaj" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 03, 2002 6:51 AM > Subject: Re: PreparedStatement vs Statement > > > > Dear all, > > > > From the DB Perspective, > > use of Prepared statement reduces the memory usage as prepared statement > > uses bind variables . The query is parsed once for several execution. It > is > > always recommended to use prepared statement where ever possible . > > > > Suresh > > > > > > >From: "Lai, Kenny" <[EMAIL PROTECTED]> > > >Reply-To: A mailing list about Java Server Pages specification and > > >reference <[EMAIL PROTECTED]> > > >To: [EMAIL PROTECTED] > > >Subject: PreparedStatement vs Statement > > >Date: Thu, 2 May 2002 14:41:20 -0400 > > > > > >is there a considerable difference, if I create PreparedStatement > instead > > >of > > >Statement after i get my DB connection? > > >are there pitfalls i should be aware about (using PreparedStatement)? > > > > > >kenny > > > > > > >=== == > == > > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > >JSP-INTEREST". > > >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > >DIGEST". > > >Some relevant FAQs on JSP/Servlets can be found at: > > > > > > http://archives.java.sun.com/jsp-interest.html > > > http://java.sun.com/products/jsp/faq.html > > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > > http://www.jguru.com/faq/index.jsp > > > http://www.jspinsider.com > > > > > > _ > > Join the world's largest e-mail service with MSN Hotmail. > > http://www.hotmail.com > > > > > == > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > == > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP- > INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com ==To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
Re: PreparedStatement vs Statement
Absolutely. It's my favorite tricks to break into asp sites ;-) Besides this security argument: - PreparedStatements save you the trouble of escaping single quotes in names like O'Connor. - They save you from the trouble of date formats - They allow better updating of longer fields. After all, the performance argument is certainly valid. The JDBC driver or DBMS can cache the parsed PreparedStatements, and a web container typically runs for weeks without stopping or restarting, so 50-100 queries is no issue at all. Geert Van Damme > -Original Message- > From: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED]]On Behalf Of Jeff Schnitzer > Sent: vrijdag 3 mei 2002 8:02 > To: [EMAIL PROTECTED] > Subject: Re: PreparedStatement vs Statement > > > The primary reason to use PreparedStatement has nothing to do with > performance. > > When you are building your query for a Statement: > > String sql = "SELECT * FROM theTable WHERE name = '" + name + "'"; > > What malicious code do you think could be inserted by users free to pick > their own names? Answer: lots. > > With PreparedStatement, you never need to worry about escaping. > > Jeff Schnitzer > [EMAIL PROTECTED] > > > -Original Message- > > From: Ashwani Kalra [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, May 02, 2002 8:58 PM > > To: [EMAIL PROTECTED] > > Subject: Re: PreparedStatement vs Statement > > > > Hi, > > I think other wise. Prepared statements are best to be avoided unless > you > > are trying to execute some queries which cannot be done from statement > > object.like batch processing. From the article below I can conclude > that > > gain in performance of the PStatement becomes visible only after > 50-100 > > successive inserts. > > > > Doing a simple search on google gives so much info. Instead of > guessing > > which is better please have a look at this link. > > > > http://www.onjava.com/pub/a/onjava/excerpt/oraclejdbc_19/ > > > > ~ > > Cheers > > Ashwani Kalra > > http://www.geocities.com/ashwani_kalra/ > > ~ > > > > > > > > > > > > > > - Original Message - > > From: "suresh kumar Durairaj" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, May 03, 2002 6:51 AM > > Subject: Re: PreparedStatement vs Statement > > > > > > > Dear all, > > > > > > From the DB Perspective, > > > use of Prepared statement reduces the memory usage as prepared > statement > > > uses bind variables . The query is parsed once for several > execution. It > > is > > > always recommended to use prepared statement where ever possible . > > > > > > Suresh > > > > > > > > > >From: "Lai, Kenny" <[EMAIL PROTECTED]> > > > >Reply-To: A mailing list about Java Server Pages specification and > > > >reference <[EMAIL PROTECTED]> > > > >To: [EMAIL PROTECTED] > > > >Subject: PreparedStatement vs Statement > > > >Date: Thu, 2 May 2002 14:41:20 -0400 > > > > > > > >is there a considerable difference, if I create PreparedStatement > > instead > > > >of > > > >Statement after i get my DB connection? > > > >are there pitfalls i should be aware about (using > PreparedStatement)? > > > > > > > >kenny > > > > > > > > > > >=== > == > > == > > > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > > >JSP-INTEREST". > > > >For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST > > > >DIGEST". > > > >Some relevant FAQs on JSP/Servlets can be found at: > > > > > > > > http://archives.java.sun.com/jsp-interest.html > > > > http://java.sun.com/products/jsp/faq.html > > > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > > > http://www.jguru.com/faq/index.jsp > > > > http://www.jspinsider.com > > > > > > > > > _ > > > Join the world's largest e-mail service with MSN Hotmail. > > > http://www.hotmail.com > > > > > > > > > > == > > = > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST > > DIGEST". > > > Some relevant FAQs on JSP/Servlets can be found at: > > > > > > http://archives.java.sun.com/jsp-interest.html > > > http://java.sun.com/products/jsp/faq.html > > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > > http://www.jguru.com/faq/index.jsp > > > http://www.jspinsider.com > > > > > > == > > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP- > > INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperan