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
