sql:param Problems.

[Elam Daly]

Howdy all,

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:

        <sql:query dataSource="jdbc/nmc1" var="basis">
          SELECT INVNO, EACHES, SPECDISC, RETAIL, BODATE, BOPACKLIST, ORIGPO
          FROM BORD WHERE CUST = ?
            <sql:param value="${param.cust}" />
        </sql:query>

This is the error:

        java.sql.SQLException: Object not supported.
com.basis.jdbc.g.setObject(g.java:50)
    org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:165)

Now if I take away the prepared statement and explicitly set the value ie:

    <sql:query dataSource="jdbc/nmc1" var="basis">
          SELECT INVNO, EACHES, SPECDISC, RETAIL, BODATE, BOPACKLIST, ORIGPO
          FROM BORD WHERE CUST = '${param.cust}'
    </sql:query>

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?

Cheers.
[ March 28, 2005: Message edited by: Elam Daly ]

[Adeel Ansari]

Try this.

<c:set var="customer" value="${param.cust}"/>
<sql:query dataSource="jdbc/nmc1" var="basis">
     SELECT INVNO, EACHES, SPECDISC, RETAIL, BODATE, BOPACKLIST, ORIGPO
     FROM BORD WHERE CUST = ?
     <sql :-P	 aram value="${customer}" />
</sql:query>

[ March 28, 2005: Message edited by: Adeel Ansari ]

[Elam Daly]

Hi Adeel,

Same result.