Shawn,
Alternatively you can write a stored procedure and execute it from
the ejbload() and ejbstore(). That way the query string is not
hardcoded in bean and also gives flexibility to change the query
based on the schema and db selected. This will leave more freedom as
it is keeping database functions completely external to bean.
Just a suggestion...
Jaya Gali
-----Original Message-----
From: mckisss [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 15, 1999 2:54 PM
To: EJB-INTEREST
Cc: mckisss
Subject: SQL query string outside of the bean?
As opposed to hardcoding a query string inside a bean, can anyone
suggest a good
method for getting SQL into the ejbLoad and ejbStore methods?
I've considered property files and reading from a file, but there is
some
administration overhead that deals with wich queries belong to which
beans/methods.
Should I use the database to store database queries?
Has anyone written a tool that addresses this "problem"?
Thanks.
--shawn
======================================================================
=====
To unsubscribe, send email to [EMAIL PROTECTED] and include in
the body
of the message "signoff EJB-INTEREST". For general help, send email
to
[EMAIL PROTECTED] and include in the body of the message "help".
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
