Did you configure a connection pool in Tomcat? Then,
get a connection object from the pool for each data
search method invocation.
I am at work now. I do not have the configuration
with me. I can post the configuration and the
database access code when I get home.
Meanwhile, do a search on the internet.
--- Michael Ni <[EMAIL PROTECTED]> wrote:
> i don't get any error when there isn't that much
> traffic
>
> but i dont close my jdbc connections, could that be
> a problem?
>
> this is the function i use to query
>
>
----------------------------------------------------------------------------------------
> public ResultSet getData(String queryStr) throws
> Exception
> {
>
> try {
> DBConstants db = new DBConstants();
> Class.forName(db.getDrivername());
> Connection conn;
> conn =
>
DriverManager.getConnection("jdbc:microsoft:sqlserver://"
> +
> db.getHostname() + "","" + db.getUsername() + "",""
> + db.getPassword() +
> "");
>
>
> Statement stmt = conn.createStatement();
> ResultSet rs = stmt.executeQuery(queryStr);
> return rs;
> }
> catch(Exception e) {
> e.printStackTrace();
> System.out.println("getData error");
> throw new Exception();
> }
> }
>
----------------------------------------------------------------------------------
>
> then if i want to use it in a jsp page i will do
> something like this
>
------------------------------------------------------------------------
>
> <%
> DBPoolBean dbpb = new DBPoolBean();
>
> ResultSet rs = dbpb.getData("SELECT * FROM drops
> order by hnm,
> itemname_en");
> while ( rs.next() ) {
> out.println("<tr><td width=\"50\">" +
> rs.getString("hnm") + " </td>");
> out.println("<td width=\"50\">" +
> rs.getString("itemname_en") + "
> </td></tr>");
> }
> %>
>
>
>
> >From: Darek Czarkowski
> <[EMAIL PROTECTED]>
> >Reply-To: "Tomcat Users List"
> <users@tomcat.apache.org>
> >To: Tomcat Users List <users@tomcat.apache.org>
> >Subject: Re: web application - student need help
> >Date: Fri, 05 Jan 2007 12:52:19 -0800
> >
> >Michael Ni wrote:
> >>
> >>the web application uses simple queries, like
> search a table for a certain
> >>condition. i realize when multiple people access
> the database it hangs,
> >>and causes the jsp pages to error.
> >Just a guess, your connection to the database is a
> problem, perhaps errors
> >in queries, not closed connections.
> >What are the error messages? (page/log)
> >
> >--
> >Darek Czarkowski
> >Ph: 604 294 6557 (Ext. 113)
> >Fx: 604 294 6507
> >www.infinitesource.ca
> >darekc at infinitesource dot ca
> >
> >
>
>---------------------------------------------------------------------
> >To start a new topic, e-mail:
> users@tomcat.apache.org
> >To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> >For additional commands, e-mail:
> [EMAIL PROTECTED]
> >
>
>
_________________________________________________________________
> Type your favorite song. Get a customized station.
> Try MSN Radio powered
> by Pandora.
> http://radio.msn.com/?icid=T002MSN03A07001
>
>
>
---------------------------------------------------------------------
> To start a new topic, e-mail:
> users@tomcat.apache.org
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
