This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
I'm using EJB + Oracle8i, and I would like to trace all SQL statements made to Oracle, or all SQL statements made to a table in Oracle, to tune my code. Anybody knows how can I do it ? Thanks in advance, Horaci Macias
Hi Horaci, Have you deployed the EJB in Oracle 8i DB? If you are using Oracle JDeveloper as an IDE for deployment,this IDE provides you a feature to view SQL statements which is used by the EJB.I believe a similar fearure exists with the Oracle Application Server also. In general, I suppose you need to look at tools provided by Container Vendors for tracing SQL statements. Hope this helps, Sandeep
<b>Sandeep</b> <br /> <br /><b>Sun Certified Programmer for Java 2 Platform</b><br /> <br /><b>Oracle Certified Solution Developer - JDeveloper</b><br /><b>-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java </b><br /><b>-- Object-Oriented Analysis and Design with UML</b><br /> <br /><b>Oracle Certified Enterprise Developer - Oracle Internet Platform</b><br /><b>-- Enterprise Connectivity with J2EE </b><br /><b>-- Enterprise Development on the Oracle Internet Platform </b>