Hi,
I tested the example source code for the SQL tags using the orion
application server. I am aware the stuff is only included for
pedagogical reasons. I found it usefull to experiment with the code.
There are a few things I had to change:
-- ConnectionTag and QueryTag are using DefaultTEI as their teiclass.
This is not possible, because the class names of the variables
cannot be String (as in DefaultTEI). They must be
java.sql.Connection respectively java.sql.ResultSet. This raises
the question if the concept of TagExtraInfo classes is really so
useful. The classes ConnectionTEI and QueryTEI I had to introduce
are almost identical.
-- The constructor of ConnectionTag needs to load a JDBC driver.
-- There is an inconsistency between the PR2 documentation and the
sample source code:
On page 133 the tag <x:foreach> has an attribut iterate with value
row. In the source code the attribute's name is row. Also on this
page the methods getAccount() and getBalance() have to be changed
to getString(1) or something similar.
-- I could not use the query
select OrderDate from orders where ORDERID < 11061
because of the character < in the query. Any ideas how to protect
these characters?
After changing this minor details the examples worked. Has anybody
comments or experience with these tags or designed different db tags?
volker turau
FH Wiesbaden Fachbereich Informatik
Tel.: +49-611-9495-205 FAX +49-611-9495-210
http://www.informatik.fh-wiesbaden.de/~turau
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
