ServletExec3.1 running behind iPlanet4.1 and JDK1.2.1_03
mihai manuta wrote:
> What server do you use?... The code is correct and it should work.
>
> Mihai Manuta
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Bob Damato
> Sent: Monday, May 14, 2001 7:21 PM
> To: jakarta taglibs mailing list
> Subject: DBTags Taglib
>
> 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.
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Bob Damato Cox Target Media
Senior Internet Developer http://www.valpak.com
If at first you don't succeed, skydiving is not for you.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
