Return-Path: 
 <taglibs-user-return-1240-apmail-jakarta-taglibs-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-taglibs-user-archive@jakarta.apache.org
Received: (qmail 93319 invoked by uid 500); 8 Aug 2001 13:23:10 -0000
Mailing-List: contact taglibs-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: taglibs-user@jakarta.apache.org
list-help: <mailto:taglibs-user-help@jakarta.apache.org>
list-unsubscribe: <mailto:taglibs-user-unsubscribe@jakarta.apache.org>
list-post: <mailto:taglibs-user@jakarta.apache.org>
Delivered-To: mailing list taglibs-user@jakarta.apache.org
Delivered-To: moderator for taglibs-user@jakarta.apache.org
Received: (qmail 11223 invoked from network); 8 Aug 2001 09:04:52 -0000
Sender: sphilp
Message-ID: <3B7100AC.7A038990@ameritech.net>
Date: Wed, 08 Aug 2001 05:04:44 -0400
From: Steve Philp <sphilp@ameritech.net>
X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.7 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: taglibs-user@jakarta.apache.org
Subject: Re: Problem with DBTags
References: <000201c11a43$490e75e0$6401a8c0@21stcentury.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

Morgan Delagrange wrote:
> 
> The syntax of DBTags definitely does not support multiple queries per statement tag (i.e. your pseudo-code example will not work.)
> 
> It's curious that using separate statement tags did not work however.  Could you send pseudo code for that usage?

I'm not the original poster, but I'm experiencing similar problems with
all pages that use multiple statements.  The pages work correctly with
Resin 1.2.7, but fail on Resin 2.0.1.  The dbtags library I'm using is
dated 20010508.

The pages look like this:

	<sql:connection id='conn'>
	  <sql:jndiName>java:comp/env/jdbc/dbname</sql:jndiName>
	</sql:connection>

	<sql:statement id='foo' conn='conn'>
	  <sql:query>
		select * from tablename_1
	  </sql:query>
	  <sql:resultSet id='rs'>
	    <sql:getColumn position='1'/><br><sql:getColumn position='2'/><br>
	  </sql:resultSet>
	</sql:statement>

	<sql:statement id='bar' conn='conn'>
	  <sql:query>
		select * from tablename_2
	  </sql:query>
	  <sql:resultSet id='rs2'>
	    <sql:getColumn position='1'/><br><sql:getColumn position='2'/><br>
	  </sql:resultSet>
	</sql:statement>

	<sql:closeConnection conn='conn'/>

The pages respond with a NullPointerException when run under the newer
Resin.  If I remove _either_ of the queries, the page displays
correctly.  It doesn't matter which I remove... just have to leave a
single <sql:statement>.

Thanks,

--
Steve Philp
Advance Packaging Corporation
sphilp@advancepkg.com