why doesn't metadata class work?!! retrieving sql columns

[Emiliano <br...@libero.it>]

why doesn't metadata class work?!!
i have stdlib1.0.3 ,when i
<sql:setDataSource var="mysql" scope="application"

driver="org.gjt.mm.mysql.Driver"

url="jdbc:mysql://localhost/mysql"

user="root"

password=""

/>

<sql:query

var="table"

dataSource="${mysql}" 

sql="select * from user "

/>

<c:forEach items="${table.rows}" var="rowdb" >

<c:out value="${rowdb.user}%>" />



<c:forEach var="coldb" items="${table.metaData}" >



tomcat give :

Unable to find a value for "metaData" in object of class "org.apache.taglibs.standard.tag.common.sql.ResultImpl" using operator "." (null)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)

WHYYY? 

Thanks

Emiliano

Re: why doesn't metadata class work?!! retrieving sql columns

["Jefferson O. Andrade" <je...@yahoo.com.br>]

The type used by the <sql:query> tag is not java.sql.ResultSet. I 
beleave that the type used has not a getMetaData() method.

Regards,
Jefferson.


Emiliano wrote:

>why doesn't metadata class work?!!
>i have stdlib1.0.3 ,when i
><sql:setDataSource var="mysql" scope="application"
>
>driver="org.gjt.mm.mysql.Driver"
>
>url="jdbc:mysql://localhost/mysql"
>
>user="root"
>
>password=""
>
>/>
>
><sql:query
>
>var="table"
>
>dataSource="${mysql}" 
>
>sql="select * from user "
>
>/>
>
><c:forEach items="${table.rows}" var="rowdb" >
>
><c:out value="${rowdb.user}%>" />
>
>
>
><c:forEach var="coldb" items="${table.metaData}" >
>
>
>
>tomcat give :
>
>Unable to find a value for "metaData" in object of class "org.apache.taglibs.standard.tag.common.sql.ResultImpl" using operator "." (null)
>
>at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
>
>WHYYY? 
>
>Thanks
>
>Emiliano
>
>
>
>
>
>
>  
>


---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org