tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Ni" <mikeni...@hotmail.com>
Subject Re: web application - student need help
Date Fri, 05 Jan 2007 21:30:50 GMT
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 <dczarkowski@infinitesource.ca>
>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: users-unsubscribe@tomcat.apache.org
>For additional commands, e-mail: users-help@tomcat.apache.org
>

_________________________________________________________________
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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message