Database connection pooling is not a new concept. Typically, one would want to apply this concept into their application when dealing with database connections. The old style of creating database connections from scratch, maintaining them and closing them upon finishing the request is a very expensive process and takes a heavy load on the server itself.

Apache Tomcat supports connection pooling. One advantage of pooling is that it reduces the garbage collection load. Using connections objects that are in the pool, we do not need to worry about memory leaks of sort.

Once we request a connection and close it, the connection object will be sent back to the pool and wait for other requests. Hence, we are actually going to use existing connection objects. If the pool has ran out of connection objects, it will create a new one and adds it up to the total number of connections inside the pool.

To enable connection pooling in java, you only need to add this tag in the context.xml in the conf/ folder of apache tomcat’s working folder.

<Resource name="jdbc/dbname"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
username="micmic"
password="micmic"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/dbname"
maxWait="1000"
removeAbandoned="true"
maxActive="30"
maxIdle="10"
removeAbandonedTimeout="60"
logAbandoned="true"/>

This tag must be inside the <context> tag.

To use this connection, you can have a method that looks similar to this

public static Connection getConnection() throws Exception {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/dbname");
ds.getConnection();
}

And use that same method to get a connection object from the pool:

Connection con = getConnection();

When you close this connection object after use, it will not close the object and garbage collect. Rather, it puts it back in the pool for the next use.

Please note that this sample code uses the MySQL Database. If you use other databases, check the appropriate driver class for the JDBC driver and make sure that you include the JDBC driver library in Apache Tomcat’s lib/ folder.

There are many tools and/or libraries to use if you want to parse html pages. In java, one of the popular ones is called HTML Parser, which is what i use. It is not an application but a java library that you can plug into your classpath when compiling and executing your application using it. Go over to their site http://htmlparser.sourceforge.net/ and download it. When you extract the archive file, it contains the JAR file library , samples and documentation.

I mainly use HTML Parser for extraction purposes. However, you can also use it for transformation. Some cool features include having filters which help immensely in getting the html tags that you only need.

Here is a sample code that uses the HasAttributeFilter class to filter out only tags that contain this attribute. I use the FilterBean class in this example to access the site page’s content. You can also use the Parser class to do the same thing. Using either is up to your preference.

try {
  NodeFilter[] nff = {new HasAttributeFilter("id", "spoof")};
  FilterBean fb = new FilterBean();
  fb.setFilters (nff);
  fb.setURL(link);
  NodeList pageNodeList = fb.getNodes();
  System.out.println(pageNodeList.toHtml());
} catch (Exception e) { }

Suppose our link page contains the following html contents:

<body>
<p id="spoof">This is a sample paragraph</p>
<p id="officeid">Office id is 000123</p>
</body>

Once you execute that code, the output for System.out would be:

<p id="spoof">This is a sample paragraph</p>

the NodeList class is patterned after the Vector class and can be broken into separate tags. You just need to loop them. The documentation API contains all the classes of HTML Parser that you can use in your parsing needs. Take another filter as example, the TagNameFilter. if you replace HasAttributeFilter in the code with this

new TagNameFilter("p")

System.out will output as one string:
<p id="spoof">This is a sample paragraph</p>
<p id="officeid">Office id is 000123</p>

if you need to acecss each <p> tag separately you need to loop the pageNodeList object like this:

for (int i=0; i<pageNodeList.size(); i++) {
  System.out.println(((Node) pageNodeList.elementAt(i)).toHtml());
}

There you have it. HTML Parsing is so easy when using this helper library. It saves you the time and trouble of creating your own parser. Feel free to comment out if you have questions and/or problems.

Having an apple gadget is pretty … wooooh. The elegance, the design, etc ;). Just dont talk about its specs and price. Why? Apple has this nasty habit of selling new stuffs containing hardware specs that are not so satisfying at an expensive price. After a few months.. whammo! you get a price drop.

Take the latest gadget as an example. the ipod touch was released late last year of 2007 (october i think). i bought one last november, a 16 gig ipod touch. Then just this month (february of 2008), they announce a 32gig version of it with a slight price gap than the 16 gig model. I know, i know.. why did i buy one knowing that apple does this all the time? it’s a cool gadget for one. and 16gig of space is good enough for me. i dont keep movies anyway so it’s alright. the problem will be if you want to keep lots of movies in it and you want your converted files not to have its quality degraded. the filesizes are awfully big if you are a quality freak.

my worst experience was with the very first model of the ipod. back then, it was only a 4gig model. i was so pissed when i got one because after a few months they slashed the price of the bigger capacity models to the same price as the 4gig model that i just got. my advice to you, if you want to buy an apple gadget/accessory or whatever. Make sure that you wont regret what you just bought and that your gadget will keep you contented for many years. check out the specs and see if it will suit your needs for many years. if not, have it upgraded (like in a laptop or desktop’s case). im not regretting the 16gig ipod touch that’s for sure. i already learned my lesson…

let’s hope the macbook air wont disappoint a lot of people too. its specs didnt impress me. yes, it’s attractive because it’s sooooo thin. but it doesnt have a dvd writer. you’d have to buy one as an accessory which means, added cost. thiiiin as in so thin which makes it gullible to damage. not only that, its introductory price is very very very expensive it’s not worth it. if you have the cash though, go get it.

what’s in store for me next? probably nothing.. i am very contented with my macbook and itouch… good for 10 years or more.. so id probably get a new ipod after 1 decade haha

Related Posts Plugin for WordPress, Blogger...