I'm having trouble with the the dbTags taglib. I've gotten everything to execute, but
the results are not what I expected. I used the example code (changing just the url,
driver and query) and the results are very odd. It outputs the data returned from the
database query, but it's not mixed in with the HTML within the resultSet tag (see
below).
My guess is that it's a JSP1.1 vs. JSP1.2 issue. Can anyone verify? I'm confused as to
why the taglib was coded using the 1.2 spec when it's not official and most commercial
app servers only support the 1.1 spec.
Here's my jsp page.
========================================================================
<%@ taglib uri="/dbtags.tld" prefix="sql" %>
<%-- open a database connection --%>
<sql:connection id="conn1">
<sql:url>jdbc:bitmechanic:pool:admin</sql:url>
<sql:driver>com.sybase.jdbc2.jdbc.SybDriver</sql:driver>
</sql:connection>
<%-- open a database query --%>
<table border=4>
<sql:preparedStatement id="stmt1" conn="conn1">
<sql:query>
select super_cat, description, lastupd from super_cat
</sql:query>
<sql:resultSet id="rset1">
<tr>
<td><sql:getColumn position="1"/></td>
<td><sql:getColumn position="2"/></td>
<td><sql:getColumn position="3"/></td>
</tr>
</sql:resultSet>
</sql:preparedStatement>
</table>
<%-- close a database connection --%>
<sql:closeConnection conn="conn1"/>
========================================================================
Here are the results:
========================================================================
<table border=4>
0FIX1998-09-10 17:18:13.313101Auto/Transportation1999-09-30
00:00:00.0102Beauty/Fitness1999-09-30 00:00:00.0103Entertainment/Leisure1999-09-30
00:00:00.0104Home Services/Improvement1999-09-30 00:00:00.0105Medical
Services1999-09-30 00:00:00.0106Professional Services1999-09-30
00:00:00.0107Retail1999-09-30 00:00:00.0108Restaurants1999-09-30
00:00:00.0109Technology/Communication1999-09-30 00:00:00.0<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
</table>
========================================================================
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Bob Damato Cox Target Media
Senior Internet Developer http://www.valpak.com
If at first you don't succeed, skydiving is not for you.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
