I am getting sql exception saying "ORA-01008: not all variables bound" when I was trying to execute a sql on oracle database. How do I actual print the table column name that is giving such error. Does the JDBC api provide easy methods to trace without putting check/debug points to trace the problem ?
No. That's an Oracle exception, so all JDBC is doing is repeating what Oracle is telling it. A "not all variables bound" error should easy enough to spot though - you should be a ble to see that there is a set method for every variable in your PreparedStatement by carefully checking your code.
This most often happens with a precompiled SQL statement and you pass the various variables at runtime. I have come across this error when i call a Java Prepared Statement and i haven't bound all the IN variables.
Nitin S<br />Sun Certified Java Programmer for the Java 2 platform.<br />Tekmetrics Certified Java Programmer For the Java 2 Platform.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads