You don't need to pass the connection along, if you're using JDBC 2.0
complaint drivers (as is the case with Oracle's thin
named classes1xx.zip an above). In every method where you'll use the
connection, create it (calling DataSource.create()),
then use it, then close() it. In JDBC 2.0 every driver MUST implement a
connection pool. To maximize the perfomance boost
that this will give you, remember to hold on to the connection for the
shortest amounts of time you can. For example,
if within your method you connect to the db, perform so heavy calculations,
then store some results back in, you should do as follows:
(Pseudo Code)
1 - connect()
2 - executeStatement()
3 - close()
4 - Perform Calculations
5 - connect()
6 - executeStatement()
7 - close()
Tough this, in contrast with not executing steps 3 and 5, may seem to lower
the performance of your method (and in fact it does),
it makes your app more scalable (by lowering the pressure on perhaps, IMHO,
the most expensive resource of all: the database).
My 2c,
JP
-----Original Message-----
From: A mailing list for Enterprise JavaBeans development
[mailto:[EMAIL PROTECTED]]On Behalf Of Balachandher S
Sent: Saturday, September 02, 2000 10:40 PM
To: [EMAIL PROTECTED]
Subject: Can I pass Connection object as a parameter to a Session Bean.
Dear all,
Can I pass java.sql.Connection as a parameter to a session bean. I am
trying with Oracle thin Driver. I am creating the java.sql.Connection
object ( using Oracle Thin Driver ) after a login screen. If I am passing
the same as a parameter to the session object, I am getting
"ClassCastException".
Any help in this regard will be useful to me. Is there any alternate
mechanism by which I can reuse the same Connection object created during the
Login.
Thanks in advance.
With regards
sbchand
_________________________________
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
���������������������������������
Srinivasan Balachandher
Software Engineer
MEDICOM Solutions (P) Ltd.
73-D, Electronics City
Hosur Road
Bangalore - 561 229
INDIA
Tel : 91-80-8520230
Fax : 91-80-8520231
URL : http://www.medicomsoft.com
_________________________________
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
���������������������������������
===========================================================================
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".
===========================================================================
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".
===========================================================================
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".
