File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes Log SQL Statement... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Log SQL Statement..." Watch "Log SQL Statement..." New topic

Log SQL Statement...

Tejas V Shah

Joined: Mar 20, 2008
Posts: 20
Hi Everybody,
Can you help me how to log SQL statement
I am using EJB3.0

Thanks in Advance
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 13884

This does not belong in the Sun Certification Results forum. Please choose a more appropriate forum next time you ask a question.

I'll move this one to a more appropriate forum.

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29275

Originally posted by Tejas V Shah:
HCan you help me how to log SQL statement

Log it where? Can you elaborate?

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Tejas V Shah

Joined: Mar 20, 2008
Posts: 20
Originally posted by Jeanne Boyarsky:

Log it where? Can you elaborate?

Temporary consider I want to log it in my local host
Bill Shirley
Ranch Hand

Joined: Nov 08, 2007
Posts: 457
By "localhost" I'm assuming you mean the client host and not the server.

The SQL is happening on the server and that's where you'd want to log it.

You can log it in a million ways, but a common way is to use the log4j package.

You can create a logger for the class you want, and log the query as INFO.

google "log4j" and you find a myriad of resources, if you have any specific questions once you start using it, "Java in General (intermediate)" is likely an appropriate forum to ask
[ May 19, 2008: Message edited by: Bill Shirley ]

Bill Shirley - bshirley -
if (Posts < 30) JavaRanchFAQ);
I agree. Here's the link:
subject: Log SQL Statement...
Similar Threads ?
Jconnect logging service
Servlet Displays Old DB Entries
JDBC and Stored Procedure
ntext problem