I hope someone might give me some comments about how a
stored-procedure can be used with an entity bean.
I have an application which use a database with the following rules :
1. no users have an INSERT, UPDATE, or DELETE access into the database.
2. put every SQL statement, i.e. INSERT, UPDATE, DELETE, or SELECT, into a
3. all stored-procedures are owned by DBO.
4. users are only allowed to execute a SELECT statement or
run/execute a stored-procedure.
Here are my questions :
a. how to use a stored-procedure with an entity bean ?
b. the database containts about 125 tables, with about 10 tables containts more
than 10.000 records. How this can be 'mapped' ?