Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Printing prepared statement to console  RSS feed

 
Prasad Tamirisa
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

Is there any way that i can print (i mean a debug statement) a prepared statement to the console.

i tried using

prpstmt.toSting();

but it doesn't seem to be working....

can any one suggest in this aspect.
 
Purushoth Thambu
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is not direct way to get the SQL being executed by the preparedstatement from the java side (unless you use JDBC driver wrappers like p6spy). You need to write some sort of reflection code to get the SQL. Here is what I did

1. Used debug to break on preparedstatement execute statement from IDE. Examined the preparedstatement object and figured out the sql is stored in which field.

2. Execute below code



This worked fine with Oracle JDBC driver. The fields may vary based on the DB & Driver.
 
suresh charan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look at this one
[ March 26, 2007: Message edited by: suresh charan ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!