Well.... I am using iPlanet 4.0, with the same taglib and it works...
But I am using the default servlet runner from iPlanet and JDK 1.3
Even if it's strange... I remember I had some problems at the begining with
iPlanet.
Then I replaced the line:
<%@ taglib uri="/dbtags.tld" prefix="sql" %>
with something like:
<%@ taglib uri="file:C:/Netscape/Jars/jdbc.jar" prefix="sql"%>
where jdbc.jar is the jar file from the taglibs... and it worked!! (don't
know why but it did)
And Morgan is right: you don't actualy need JSP 1.2 for the taglibs to work.
With JSP 1.1 you only have some limitations.
Sorry if what I said doesn't help...
Mihai
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bob Damato
Sent: Tuesday, May 15, 2001 7:35 PM
To: [EMAIL PROTECTED]
Subject: Re: DBTags Taglib
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.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
