tags:

views:

18

answers:

1
Q: 

Should I create multiple services (using the Spring `@Service` stereotype) to do database lookups for different controllers?

I'm not sure where to do database lookups for Spring controllers.

It seems to make sense to use the Spring @Service stereotype and create multiple "services" to provide lookup support to controllers rather than doing lookups directly in the controllers.

Is this correct or is there a more appropriate place to perform database lookups?

+2  A: 

I don't think controllers should be doing database lookups. If you ditch your web tier, the lookup functionality goes away.

I'd put those behind a layer of repository interfaces. You can test them without the web tier that way. There could also be a separate service layer that owned units of work and transactions. Lookups should be read-only, so they might be safe enough to call directly from controllers.

That's the recommended Spring idiom.

duffymo  2010-08-25 20:13:32
Thanks. This makes sense, especially the bit about "what happens if you get rid of the web tier" - I hadn't thought about that possibility. But could you explain what you mean by "repository interfaces" - I assume this is the "that" in "That's the recommended Spring idiom"? Are there any recommendations about what the "separate service layer" should look like and when you say "separate", do you mean it is "separate" from the "layer of repository interfaces"?
Cornish  2010-08-25 20:19:11
"Repository" == "Data Access Object" == "DAO" It's an interface for CRUD operations. And yes, there's another interface for services that orchestrate DAOs and model objects to implement use cases.
duffymo  2010-08-26 01:02:30

related questions

Maintiaining SQL Transactions over web service calls in .Net
Adding to a Coldfusion classpath running on an instanced JRun server
Accessing network shares from a service
Framework to host web services on a basic hosted web server
Way to Stop a Windows Service when CanStop is set to False (C#)
Way to stop a program from starting up using c#?
Best DNS with API access.
Starting service as a user with no password
What is the best way to change the credentials of a Windows service using C#
Is there a good way of securing an ASP.Net web service call made via Javascript on the click event handler of an HTML button?
IPC on Vista (service and application)
Multiple services from the same executable
Free/open source service (SOA) management and monitoring tools
Displaying Window on Logon Screen Using C# in Windows XP
spring & web service client - Fault Detail
How to communicate with a windows service from an application that interacts with the desktop?
Microsoft SQL Server 2005 service fails to start
Service that provides DVD Covers art?
Troubleshooting a NullReference exception in a service
How SID is different from Service name in Oracle tnsnames.ora
Why won't .NET deserialize my primitive array from a web service?!
Remotely starting and stopping a service on a W2008 server
Best way to perform dynamic subquery in MS Reporting Services?
Printing a PDF in .NET
Timer-based event triggers