What is the actual problem? Why do you think that if only one connection is used it is not optimized?

Markus H�rnvi wrote:

Hi!

I have a MDB reading a constant stream of messages from a Queue. The MDB is
storing the messages through two CMP entity bean with a CMR. The data written to the database will be read but never updated. I would like to optimize the process from MDB to database.


When I look at the use of database connections, it seems that only one is in
use. I guess this has something to do with my use of transaction attributes.


I use the default transaction settings on Oracle which I believe is
READ_COMMITED. The CMP has "Required" transaction setting. The MDB uses
transaction-type="Container" and "Required".


Primary keys are issued by a session bean that requests blocks of keys from an
entity bean. This bean uses "RequiresNew" and row locking.


What would be the best settings to tweak?

Thanks in advance!

/Markus




------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user






-------------------------------------------------------
This SF. Net email is sponsored by: GoToMyPC
GoToMyPC is the fast, easy and secure way to access your computer from
any Web browser or wireless device. Click here to Try it Free!
https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to