EJBs, Websphere, and SQL Tuning

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?

Belisarius · 04-09-2005, 02:47 AM

What do you mean by "capture"?

technobard · 04-09-2005, 06:16 AM

Quote:

Originally Posted by Belisarius

What do you mean by "capture"?

Well, collect or log...anything that allows me to look at all of the SQL generated over some period of time. I can do it at the database level (in Oracle anyway) by querying data dictionary tables or by tracing the connected sessions. It's cleaner if I can grab it at the app server level.

Belisarius · 04-09-2005, 06:23 AM

Ah. I haven't done too much with either EJB or CMP; I've only started to look into EJB. I'll let you know if I come across anything in the course of my travels.