Code Forums - View Single Post

technobard · 04-08-2005, 01:21 PM

I'm starting a new job soon and while I won't be doing any EJB stuff personally, the developers I support will. They're using Websphere as the app server, and they've implemented CMP (container managed persistence). In CMP, the SQL is creating dynamically which I suppose gives you some database independence. Anyway, tuning the SQL is part of my task, but since you have to live with whatever is generated, tuning on the database side will be limited.

So, has anyone used CMP with or without Websphere as the app server? And if so, any tuning tips? For example, is it possible to capture generated SQL on the app server end?

04-08-2005, 01:21 PM	#1 (permalink)
technobard Centurion Nova Prime Join Date: May 2002 Location: Oak Park, IL (USA) Posts: 285	EJBs, Websphere, and SQL Tuning I'm starting a new job soon and while I won't be doing any EJB stuff personally, the developers I support will. They're using Websphere as the app server, and they've implemented CMP (container managed persistence). In CMP, the SQL is creating dynamically which I suppose gives you some database independence. Anyway, tuning the SQL is part of my task, but since you have to live with whatever is generated, tuning on the database side will be limited. So, has anyone used CMP with or without Websphere as the app server? And if so, any tuning tips? For example, is it possible to capture generated SQL on the app server end? __________________ It takes 2 points to draw a straight line, but at least 3 points to draw a conclusion.