That will depend on what bean scope you have given in the usebean tag ,if it
is session it will last for the full session
Sanjay
>From: Rupali Bains Goswami <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Fwd: Re: Connection Pool
>Date: Fri, 30 Jun 2000 07:08:14 PDT
>
>I already have the properties file setup the way u had specified,
>
>I have the login bean for the initial database connection, then i get the
>username and password entered and compare it with the values specified in
>my
>customer table. After validation i need to go to the next jsp page. My
>question is that will I have the connection to the database throughout the
>session so that when i go to the different jsp pages and need to retrieve
>data from the database, how do i do it?
>
>Thanks
>
>
>>From: "Jaffa, Dan" <[EMAIL PROTECTED]>
>>Reply-To: A mailing list about Java Server Pages specification and
>> reference <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Re: Connection Pool
>>Date: Fri, 30 Jun 2000 09:30:19 -0400
>>
>>I am a little confused by your question but I will tell you what we have
>>been doing
>>
>>In our EJB's and Beans we use the following code to connect to the
>>database.
>>Once we connect and retrieve all the necessary data we close the
>>connection.
>>I am using Weblogic Type II Oracle Driver.
>>
>>This code should be in your weblogic.properties file
>>
>>weblogic.jdbc.connectionPool.atlasPool=\
>> url=jdbc:weblogic:oracle,\
>> driver=weblogic.jdbc.oci.Driver,\
>> initialCapacity=1,\
>> maxCapacity=2,\
>> capacityIncrement=1,\
>> props=user=XXXXX;password=XXXXX;server=XXXXXX
>>
>>weblogic.allow.reserve.weblogic.jdbc.connectionPool.atlasPool=atlas
>>
>>the following code should be in your jsp, ejb or Beans or servelts
>>
>>Properties props = new Properties();
>>props.put("user","####");
>>props.put("password","#####");
>>Driver myDriver =
>>(Driver)Class.forName("weblogic.jdbc.pool.Driver").newInstance();
>>Connection conn = myDriver.connect("jdbc:weblogic:pool:atlasPool", props);
>>sql = "Select * from dual
>>QueryDataSet qds=new QueryDataSet(conn, sql);
>>ResultSet rs = qds.getResultSet();
>>
>>
>>
>>
>>Daniel Jaffa
>>
>>
>>
>>-----Original Message-----
>>From: Rupali Bains Goswami [mailto:[EMAIL PROTECTED]]
>>Sent: Friday, June 30, 2000 8:54 AM
>>To: [EMAIL PROTECTED]
>>Subject: Connection Pool
>>
>>
>>I Have a very basic question.
>>
>>I am using weblogic and have created the connection pool in the properties
>>file.
>>
>>How do i then connect to the database? should i have an init method for
>>the
>>initial connection?
>>
>>All I want to do is initially connect to the database and query some
>>tables
>>
>>the code is something like this
>>
>>Class.forName (jdbcClass).newInstance();
>>Connection conn = DriverManager.getConnection(jdbcURL,user,password);
>>
>>how would i then maintain the connection through all my jsp pages.
>>
>>Thanks for all the help.
>>
>>-Nisha
>>
>>________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>>===========================================================================
>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>>JSP-INTEREST".
>>Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>>
>>===========================================================================
>>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>>JSP-INTEREST".
>>Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>http://java.sun.com/products/jsp/faq.html
>http://www.esperanto.org.nz/jsp/jspfaq.html
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
