I am writing a jsp application which uses a proprietary JDBC database driver. I am getting errors thrown and am having trouble drilling down to the cause. The error is thrown when I use a prepared statement and the <sql:query> tag ie:
This is the error:
Now if I take away the prepared statement and explicitly set the value ie:
everything works fine, but I'd rather not do this.
So before I talk to the jdbc provider describing the problem, am I correct in assuming that the driver is not casting the prepared statement value correctly? Is there some way to explicitly cast the value myself using the <sql:query> tag?