• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Which patterns to apply?

 
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have been assigned a project which includes conversion of existing database dependent application to database independent application.Most of the database queries are written as stored procedures and stored in packages.The database being oracle. The path we have chosen is to implement all these packages as java beans and the stored procedures in the packages as bean methods.
Can anyone suggest what other patterns to use apart from DAO pattern?

Waiting for help,

Piyush
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In my experience, the most rewarding use of design patterns does not result from upfront planning of their usage, but from looking out for smells in the code that suggest the use of one while coding.
Take a look at Refactoring to Patterns
 
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well, it pretty much begs for the strategy pattern, but I'm with Ilja on this one.
Kyle
 
Leverager of our synergies
Posts: 10065
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Martin Fowler has his new book
Patterns of Enterprise Application Architecture online. You may find it useful.
Also, banner on this page recommends this as a possible solution.
[ August 31, 2002: Message edited by: Mapraputa Is ]
 
Piyush Daiya
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks everyone for your valuable advice.
reply
    Bookmark Topic Watch Topic
  • New Topic