JDBC Programming

Posted on 2005-04-27
Last Modified: 2010-03-31
My servlet application is used to get data using SQL statement from the AS/400 DB2. But recently found that the work load is pretty heavy since people said AS/400 is not good on handling SQL statement. So I am now thing to get all the kinda static data from the DB2 when the servlet init, and manipulate those object around. But I would like to know is there anything like that out there, is Hibernate / iBatis do something like this ? Can you guys experts give me some advice on how to speed up my web application ? Thanks !
Question by:clo1
    LVL 35

    Accepted Solution

    You *could* use something like Hibernate, as that will provide a caching layer for your static objects...

    Personally, I'd look into using

    I've not tried it, but I have heard good things about it :-)
    LVL 15

    Assisted Solution

    Hibernate can be a good fit which can prove pretty helpfull when using the second layer cache option (which is pluggable and can use the suggested oscache) especially when having many repeatable queries.
    Though if you know that some queries are static and you want to provide a transparent solution to your buisness (which will not effect existing code) I would recommend you to use a JDBC driver
    that provides chaching (see c-jdbc or ... [you can google for it]).
    I actually wrote one by extending the java.sql.Driver wrapping the real JDBC driver and delegating the calls to the driver and caching back the results (when not having in the query result in cache already) .

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
    Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
    Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
    This video teaches viewers about errors in exception handling.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now