Database validation question

[earlwer]

If I have a field like Customer Number that has to be validated against a large SQL table (10,000 entries), can the validation be done on a field basis and on the server? (ie. dynamically & quickly)

This is a common requirement for an Order Entry type application.

Ideally, I would like to have a dynamically created list of Customer codes that the user could select.. even better would be the ability to press an icon/button and switch to the Customer table for data-entry..

I develop business applications where 90% of the data-entry consists of direct entry into various SQL tables. Validation of the data is very important.

I'm not used jBoss yet, and I want to make sure that it can do what I want before jumping in..

thanks Earl Wertheimer

[pvamstel]

That is not the quesstion to ask.

You have to model the things you want to persist in a EntityEJB.

And have all the bussiness logic in that class as well.

(You should not talk directly to the database.)

grt Patrick