Get the SQL from a java.sql.Connection

Question

I have a thread which iterates a pool of occupied connections and verifies if each Connection has reached the maximum time allowed for being at this pool.

If the Connection reaches that time, I perform a rollback, close the Connection and log a message containing information about the Connection.

I would like to add the SQL command performed by that Connection to the logged message. Is there a way of getting the SQL, or the PreparedStatement, from a java.sql.Connection?

I've wondered to extend java.sql.Connection and inject that information to the object before execute the command. So that, I would be able to get it when necessary. Do you know a more elegant way of doing that?

EDIT It isn't duplicate. This question is about PreparedStatement and I don't have it. I only have a java.sql.Connection

Community · Accepted Answer · 2017-05-23 11:44:13Z

2

Just print it with the standard way System.out.println(preparedStatement); .

In case it doesn't work, refer here.

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Dec 14, 2015 at 11:41

teobais

2,9781 gold badge26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hbelmiro Over a year ago

I don't have the PreparedStatement. That's what I'm asking for.

Collectives™ on Stack Overflow

Get the SQL from a java.sql.Connection

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related