Hi Vijay,
Have you ever tried iBatis?
It is a framework that allows you to map sql statements to POJOs and
takes care of a lot of issues like: mapping database types to java
types, caching, dynamic sql, etc.
It really works great, specially for legacy databases.
You can get more information on this regard here: http://ibatis.apache.org
Hope that helped,
Daniel Silva.
On 7/22/05, Vijay K Anand <[EMAIL PROTECTED]> wrote:
>
> Hi All
>
> I get error : "java.sql.SQLException: Closed Connection: next " when
> number of concurrent requests is more
>
> public class PortfolioMgmtAction extends Action{
> private Connection con;
> public ActionForward execute(..){
> this.con = dao.getConnection();
> }
> }
>
> public class DAO
> {
> private Connection objConnection;
>
> public Connection createConnection() {
> Class.forName("oracle.jdbc.driver.OracleDriver");
> "dashboard");
> objConnection =
> DriverManager.getConnection("jdbc:oracle:thin:@10.64.34.107:1521:spsdweb",
> "NPI_DBRD_AD", "RTAM70PW");
> return objConnection;
>
> }
>
> What is the problem in architecture??
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
