PreparedStatement Debug Question

I have been having a problem with a PreparedStatement not executing correctly and I wanted to get into the guts of the PreparedStatement object (SerialPreparedStatement) actually.

I have been searching through the members of this object in the Eclipse debugger and I can't seem to find the parameters that I set in the object.

Does anybody have any idea where to look in the actual SerialPreparedStatement object to get to the parameters? (Eg. stmt.setString(1, "Hello") Where can I find the string Hello or the collection object that contains it?

Thanks!

[581 byte] By [maple_shafta] at [2007-11-26 17:48:07]

«« Is there any way for a java program to restart by itsef.
»» Blueprints autocompletion component failure

# 1

Unfortunately, I don't know if there's a simple way to do this. Here's an older [url= http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html]article[/url] giving some tips on how to accomplish this programatically.

bckrispia at 2007-7-9 5:00:27 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

So basically it looks like a PreparedStatement wrapper is neededto extend that functionality...

Its alright though I already figured out the problem. The column type of the column in the WHERE clause of my query was of type CHAR in Oracle 9i.

CHAR types are fixed length so I had to perform a sql TRIM() on the column to remove unwanted white space before I perform the comparison. Either that or change the column type in the database to a VARCHAR2.

Thank you anyway though, I will give you the Dukes. ^_^

maple_shafta at 2007-7-9 5:00:27 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

PreparedStatement Debug Question

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified