Getting sql for Callable or Prepared Statements
[178 byte] By [dmbdmb] at [2007-9-26 1:52:11] 
If I have a PreparedStatement or CallableStatement, and I want to get the sql that was specified when I created the statement from the connection, how do I get it?
JDBC drivers sometimes provide an option which when put ON, the driver will log the actual SQLs to a log file.Don't know how to get the SQL using Java API though.
neville_sequeira at 2007-6-29 3:01:34 >
Database Connectivity New Topic
Database Connectivity Hot Topic
- Does anybody know how to bind multiple values to IN qualifier
- java.sql.SQLException: Invalid handle
- Cached Row Set
- Inserting BLOBS to Oracle using Java
- Failed to switch thread security context w/ Oracle Connection Pooling
- HOW TO CREATE DSN DYNAMICALLY?
- createStatement() does not work on passing parameters
- manipulating JDBC Datasources from a java application or servlet
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding