getting the SQL out of PreparedStatement

[drakonis]

I was wondering, if one can get the SQL out of a PreparedStatement.
For example the code in

public class TestClass {
public void aMethod () {
PreparedStatement sql=con.prepareStatement("INSERT
INTO person(id,adress,age) VALUES(?,?,?,?)");
sql.setInt(1,22);
sql.setString(2,?Str. .....?);
sql.setInt(3,24);
sql.executeUpdate();
}
}
We could write an interceptor, intercept prepareStatement and get the parameter, but the SQL String has those nasty ? ? ? in it.

Next we have another interceptor intercept the ..PreparedStatement->set*(..) but how would i be able to get the info extracted with the first interceptor(the SQL String with ? ? ? in it), if only i could get, that then i would use a regular expresion to parse it and add the info of that perticular set* method instead of the ?
and finally at executeUpdate() i would just have the plain clear as day SQL.

Metadata to pass the data from one Interceptor to the other is out of the question i guess cause i belive that's for chains of interceptors, right?
How about we dinamicaly add a field to the TestClass and put the partial result of all the calls in there. Could we do that?

Is it possible to make it work. Any ideas?

[bill.burke]

proxy the return from prepareStatement(). The proxy can hold the SQL and then you could get it at runtime.

[drakonis]

Something like this?:

public class sqlPreparedStatement implements PreparedStatement {
PreparedStatement st;
SQLString SQLstr;
public sqlPreparedStatement(PreparedStatement st) {
this.st=st;
}
public setString(int par, String str) {
//do the wright work on the string
...
st.setString(par,str);
}
........
.......
}

and in the interceptor:

return new sqlPreparedStatement((PreparedStatement)invocation.invokeNext());

well that would be a great idea. If I understood it corectly i could say the solution is simplisticaly beautiful.

PS: 10x again Bill, just wondering how the hell do u get the time to answer on the forum when i've seen articles on aop,interviews on theserverside, the aop panel(that AspectJ IBM guy was boring:) ), heard u on ejb 3.0 tutorials on jboss, developing JBossAop, jessus u shouldn;t be answering the forum(although not many other people seem to be answering).

[drakonis]

i can't seem to be able to intercept prepareStatement. Could it be because Connection is an interface or i;m doing something wrong?

[drakonis]

"drakonis" wrote:
i can't seem to be able to intercept prepareStatement. Could it be because Connection is an interface or i;m doing something wrong?

Darn XML

<bind pointcut="execution(public * java.sql.Connection->prepareStatement(..))">
 <interceptor class="com.project.SQLInterceptor"/>
</bind>

[kabirkhan]

We ignore all classes in the java.* and javax.* packages for the "normal" pointcuts. Use a caller side pointcut:

http://docs.jboss.org/aop/1.1/aspect-framework/examples/caller/caller.html

[drakonis]

Thanks, it killed the only remaining 2 braincels i got left du!#$2(can't even write) till i gave up. should work now.