this is the prob...
Context ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("nehalDS");
Connection con = ds.getConnection();
Statement stmt = con.createStatement();
stmt.execute(some query");
ResultSet rs = stmt.getResultSet();
the same code i am using in all the jsps through out the site to access the oracle database. I need to abstract it into some reuseable pattern.i found out Data Access Object
pattern is the solution but how to use it... can any1 help me with some small example on which i can built up...
Thanks
Nehal.
[ December 02, 2002: Message edited by: Nehal Dave ]