If you are using a recent implementation of the
Servlet specification, you should use Apache's
implementation of the JSTL, not DBTags. DBTags has
been inactive since development on JSTL began, and it
should be considered deprecated for Servlet 2.3 or 2.4
containers.
- Morgan Delag
Yes, the "to" attribute of the getColumn tag writes to a Servlet attribute,
not a scripting variable. A scripting variable would have been awkward
because the "to" attribute is optional; by default the tag will simply write
to the current writer.
- Original Message -
From: "Carole E. Mah
--- Shawn Bayern <[EMAIL PROTECTED]> wrote:
> On Tue, 23 Apr 2002, Morgan Delagrange wrote:
>
> > > > I was just wondering while reading the
> > > specification - how do I test
> > > > on something being not empty?
> > > >
> > >
> >
> >
> > Is this correct?
>
> Sure - or
>
> ${not empty param.name}
>
or ${param.name != null}
=
Morgan Delagrange
http://jakarta.apache.org/taglibs
http://jakarta.apache.org/commons
http://axion.tigris.org
_
I don't know if I agree that the JSTL tags are easier to use (particularly
if you don't know the expression language), but they are in active
development. DBTags will be performing a 1.0 release soon, but after that
it's likely to only perform point releases, at least for the forseeable
future.
Hey gang,
FYI, Michael's implementation of SequencedHashMap is now available int the
Collections CVS. You can go ahead and give it a look.
Submit any additional refinements or unit tests to the "commons-dev" mailing
list (unless you're working on the Commons project, of course).
- Morgan
---
That limitation was just in anticipation of common usage. You should be
able to loosen your TLD in that case (and most other cases) without
affecting the application.
- Original Message -
From: "Rau, Rajesh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 21, 2002 12:11
You do not need to use jsp:getProperty and jsp:setProperty if you are
satisfied with calling the get and set methods in a scriptlet. If you would
rather use jsp:getProperty and jsp:setProperty, you can create your own tag
according to the sample code and put it in whatever namespace you wish.
--
Another possibility is to store the primary key of the last accessed record in the
session and use it when creating the sql query.
P.Miller wrote on 11/15/01 3:00 am:
Hi Dinesh,
take a look at jsptags.com.
(tld-info: The Pager Tag Library helps generate Google[sm] and AltaVista®
style search
Unfortunately, you are correct. Under ordinary circumstances, the PreparedStatement
will not be reused. However, you may consider implementing the database connection
pool sponsored by the Jakarta Commons subproject. That DBCP provides optional pooling
of prepared statements.
- Morgan
Ste
How would you envision such functionality? Since JSPs are a text medium, we did not
put a lot of thought into support for binary data.
- Morgan
Ricardo Rebouças wrote on 10/31/01 5:20 am:
Hi there!
I'm a brazilian dbtags's user. I found it just fantastic, it makes building a database
driven
Sure,that sounds reasonable.
Nick Pellow wrote on 10/10/01 3:41 am:
>Hi,
>I am using the dbtags
>(resultset) for some simple
>looping and displaying of
>static data. It is great,
>however I was wondering if
>there is nice way to get the
>date/time as a long from the
>getColumn, getNumber
Stacy Young wrote on 9/29/01 9:48 pm:
>What you've just described
>does not really apply to my
>environment. I hardly
>implement any of the
>business logic, if any at all, in
>the front end...Unless it's a
>smaller application that I'm
>rolling out, then sure...
>
>Does this mean there a
DBTags probably does not support JDK 1.1. We haven't made any explicit
attempt to do so, and there are probably Java 2 collections at the least.
- Original Message -
From: "Alexander Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 6:38 PM
Subject
Why don't you just read the password from a context parameter? It's
directly supported in the DBTags syntax:
- Original Message -
From: "Karen E. Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 1:53 PM
Subject: Re: DB connection tag question
> I am t
There's nothing intrinsic to the tags that does connection pooling, so
you'll probably want to implement something. You might want to check out
the DBCP component in the Jakarta Commons subproject.
- Original Message -
From: "ranjit lingaiah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
- Original Message -
From: "Karen E. Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 1:26 PM
Subject: DB connection tag question
> I am using DBTags in an app I'm working on... very simple, just one jsp
page. I am confused about how to use a datasource
No I don't think that's something that's currently supported. I
experimented with scrollable result sets a while back, but at the time the
MySQL JDBC drivers did not support it.
- Original Message -
From: "Marcus Andrade" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
fically
addressing a bug in WLS, rather than something
dictated by the spec. Believe me, I use WLS 6 in
production too, so I know how frustrating WLS bugs can
be.
I think my preference would be to not add WLS-specific
workarounds. It's pretty simple to add that code to
your local CVS c
I can use these three handy tags?
>
> wasEmpty
> wasNotEmpty
> rowCount
>
> I'd love to use them, but of course they error out
> because they are not
> contained in a statement tag.
>
>
>
=
Morgan Delagrange
http://jakarta.apache.org/taglibs
http://
ll;
> _rset = null;
> _shouldLoop = true;
> _name = null;
> _scope = null;
> _rowCount = 0;
> _stmtTag = null;
> try {
> getBodyContent().clear();
> } catch (Exception e) { }
> }
>
=
Morgan Delagrange
http://jakarta.apache.org/tagl
sultSet tag does not need to be inside of a
> statement tag."
>
> So my question is if the resultSet tag is not inside
> of a statement tag, is
> there _any_ way I can use these three handy tags?
>
> wasEmpty
> wasNotEmpty
> rowCount
>
> I'd love to us
--- Morgan Delagrange <[EMAIL PROTECTED]> wrote:
> ...
> 1) Somehow I'm pulling the wrong ResultSetMetaData
> object. It's possible, so I'll keep my eye on it.
> Does this page have more than one statement? It's
> possible that some info is being incor
possible that some info is being incorrectly cached,
but I did not think that your version of Tomcat
supported caching taglibs. I'll tack a release() call
into the end tags just to make sure, and you can try
the new build tomorrow.
2) A bug in your Oracle driver wrt. ResultSetMetaData
and Date field
retrieved using position
> attribute.
>
>
> // SUCCESSFULL
> to="cur_date"/> // FAILS
>
> Any one know why this could be failing?
>
> thanks,
>
> -ranjit
>
>
>
> Ranjit R. Lingaiah[EMAIL PR
The name of the init parameter containing the
> driver name.
>*
>* @param paramName driver class name
>*/
> public void setInitParameter(String paramName) {
> _driverClass =
>
pageContext.getServletContext().getInitParameter(paramName);
> }
>
are a closed forum. You
might want to check the Resin website for any outstanding issues.
Steve Philp wrote on 8/8/01 8:24 am:
>Morgan Delagrange wrote:
>>
>> The syntax of DBTags
>definitely does not support
>multiple queries per
>statement tag (i.e. your
>pse
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?
Lavandowska wrote on 7/29/01 4:05 pm:
>No, not t
Hmm, I don't see anythinq wrong with your syntax. I'm not sure what the problem would
be.
As for the missing TLD, that's just a temporary glitch. Today I plan to roll the
DBTags build back to a previous version until I finish enhancing the new build to
support DBTags.
- Morgan
[EMAIL PROTEC
Interestingly, lately I've seen lots of developers come to the
conclusion that EJBs (Entity and Session) are not appropriate for all (or
even most) Enterprise tasks. I've seen several threads lately about
companies that started out with pure EJB solutions and then scaled back to
simple classes ru
You could assign the row count to a variable using a tag library, e.g. the
Page taglib. That's the easiest way to capture output from the page.
On Tue, 26 Jun 2001 [EMAIL PROTECTED] wrote:
> Hi people
>
> I'm using the DBtags and the utility tag libraries, and what I want to
> achieve is prin
Yikes I don't see anything wrong with your syntax, sorry! Thanks for the
terrific amount of detail. Has anyone else had this problem with ODBC?
- Morgan
On Tue, 19 Jun 2001, Emir Alikadic (ADNOC IS&T) wrote:
> Hiya all!
>
> I'm using JDBC taglib with MS SQL Server 6.5 and JDBC:ODBC bridge f
is undefined (as in the case of the memo field),
then the getColumn() method is called.
You could try sending a stack trace to the list. Maybe the specific
exception will help.
- Morgan
On Mon, 11 Jun 2001, Morgan Delagrange wrote:
> Ah, that's interesting. If memo fields don't
Ah, that's interesting. If memo fields don't return one of the standard
JDBC constants, that might cause unpredictable behaviour. Let me take a
look see and make sure that it will default to getColumn().
On Fri, 8 Jun 2001, Yiyi Sun wrote:
> As I said we cannot use DBTags with jdbc-odbc. I thi
Hmm, doesn't sounds quite right. The getColumn tag only uses the
getClob() method for CLOB data types; in all other cases, it uses
getString(). This sounds like a driver issue, but I can't be certain.
On Tue, 5 Jun 2001, Yiyi Sun wrote:
> Hi Morgan,
>
> The memo type is very useful to store t
On Wed, 30 May 2001, Ellis, Neil (FNB) wrote:
> Hi,
>
> could the following be used in setQuery of the PreparedStatementImpl of the
> DBTags taglib library:
>
> public void setQuery(String query) throws SQLException, JspTagException{
> Connection conn = (Connection)pageContext.getAttribu
Hi Bill,
I sent you a couple of emails on this topic.
- Morgan
On Wed, 16 May 2001, Bill Pfeiffer wrote:
> Reposting my proposal for change to DBTAGS:
>
> BACKGROUND:
>
> For my current project, I have reworked the DBTags ResultSet tags (and
> nested tags) to pull a javax.sql.RowSet out of
, there would have to be some tag that
generates the RowSet itself.
On Wed, 16 May 2001, Morgan Delagrange wrote:
> Hey Bill,
>
> I have to admit, I'm not too up on RowSets. I have a general idea what
> they're supposed to do, specifically in terms of portability around the
>
Hey Bill,
I have to admit, I'm not too up on RowSets. I have a general idea what
they're supposed to do, specifically in terms of portability around the
environment, but I don't know them intimately. Do you have any ideas
about how specifically you might alter the API? That might ground your
i
Hi Greg,
Comments below...
On Tue, 15 May 2001, Greg Callaghan wrote:
> Hi,
>
> I am trying to implement in JSP a nested JDBC query, to produce output like
> the following -:
>
> ---
> * Result 1 from Query 1
>- Release 1 from
Hi John,
I don't think we got it. Could you resend please?
- Morgan
On Tue, 15 May 2001, John Foulds wrote:
>
> Hi Morgan
>
> Just a request for help. I am hoping you have a moment or two.
>
> I sub'd to the taglib list in digest form the other day but have rec'd
> nothing.
>
> 1) Did yo
container that supports the
> JavaServer Pages Specification, version 1.2."
>
> - Original Message -
> From: "Morgan Delagrange" <[EMAIL PROTECTED]>
> To: "jakarta taglibs mailing list" <[EMAIL PROTECTED]>
> Sent: Monday, May 14, 2001
Sorry, I can't see the problem off the top of my head. It's not a JSP
version issue; these tags do not have any JSP 1.2-specific traits.
- Morgan
On Mon, 14 May 2001, Bob Damato wrote:
> I'm having trouble with the the dbTags taglib. I've gotten everything to execute,
>but the results are not
On Thu, 10 May 2001, Thomas [iso-8859-1] Förster wrote:
> Morgan Delagrange wrote:
> >
> > You'll probably want to explore changing your web.xml to forward users to
> > a standard error page, rather than showing them a stack trace. This is
> > pretty common.
You'll probably want to explore changing your web.xml to forward users to
a standard error page, rather than showing them a stack trace. This is
pretty common. Take a look at the element of the web.xml,
which will let you forward to specific pages for specific exceptions.
Glad to see folks are
Sure you should be able to do that. Just nest a new statement inside of
rset1. It will probably be pretty verbose-looking though.
On Fri, 4 May 2001, Quaini Michele wrote:
> Hi,
> Suppose that I want to do the following thing:
>
> 1) creating a query query1 that identifies n records.
> 2) lo
I'm pretty sure that it's not possible in the current XSL version, but
we're working on a new version that will. How patient are you? :)
On Thu, 3 May 2001, Aaron Oathout wrote:
>
> It is possible if you are using the transform taglib from epesh.com. I'm
> not for sure about the xsl taglib.
>
On Thu, 3 May 2001, Brent Johnson wrote:
> The documentation for the JDBC statement tag shows a maxRows property and even
>comments how handy they are...but this property is not defined in the current source
>or the TLD. I agree it would be handy. Is this a future enhancement, or did it get
'id' rather than 'conn'
> in the sql:closeConnection tag which is incorrect.
Good catch. Fixed.
>
> - Original Message -
> From: "Morgan Delagrange" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 02, 2001 1:21 P
On Wed, 2 May 2001, Brent Johnson wrote:
> The statement tag gets its connection as follows inside of doStartTag():
> Connection conn = (Connection)pageContext.getAttribute(_connId);
>
> This means that the connection must be defined at PAGE_SCOPE. This seems a bit
>restrictive. What if my
Sorry, there is not currently a way to make sure the connnection closes in
the event of an error.
On Thu, 26 Apr 2001, Dave Dribin wrote:
> Hello,
>
> Is there a way to ensue the tag is evaluated
> even on an SQL error? I'd rather not set ignoreErrors to true as I do
> not want the error disp
(Pierre sent a related response as I was typing this, but I think it's
still helpful.)
Ah, OK, I think I see what you're asking for now. Often when people
talk about scripting variables, they're just talking about assigning
attributes, but you want the real deal. OK, time to introduce you to th
Actually, you did put your attribute in the session context. The
findAttribute(String) method of the page context searches all the context
(first page, then request, then session, then application) for your
attribute. The alternative is the getAttribute(String) method of each
scope, which only
On Tue, 24 Apr 2001, Peter Alfors wrote:
> Hello all,
>
> This is probably a simple question (hopefully) for you all.
> I am writing a tag that is similar to jsp:useBean.
>
> This new tag needs to be able to make an object available as a scripting
> variable.
> example:
>
>
>
> Glenn
>
> Nick Christopher wrote:
> >
> > Newer sybase's are case sensitive with regards to object names (i.e.
>tables/cols/indexes).
> >
> > Morgan Delagrange wrote:
> >
> > > Good catch, I believe you are correct. I'll p
Craig, is there a message here?
On Mon, 23 Apr 2001, Craig R. McClanahan wrote:
>
>
> Nick Christopher wrote:
>
> > Newer sybase's are case sensitive with regards to object names (i.e.
>tables/cols/indexes).
> >
> > Morgan Delagrange wrote:
> >
Good catch, I believe you are correct. I'll patch it up today.
- Morgan
On Thu, 19 Apr 2001, Dave Dribin wrote:
> Hello,
>
> I was just playing around with the 04/19 version of the JDBC tag
> library and trying to run the example pages. I am using Oracle as a
> back-end database and using a
Take out this line:
> >
You are attempting to access a property of java.sql.Connection that does
not exist.
- Morgan
On Fri, 20 Apr 2001, Aron Kramlik wrote:
> In that file, line 215 is:
>
>
>out.print(JspRuntimeLibrary.toString(JspRuntimeLibrary.handleGetProperty(pageContext.findAttribute
There's a typo in your sample JSP. Is this really what your source looks
like?
It should be "initParameter", but your servlet engine should also be
giving you some sort of warning.
On Thu, 19 Apr 2001, Procek, Brett wrote:
> Hello,
> Has anyone gotten the 'initParameter' functionality work
ated, if one uses the
> default location like
><%@ taglib uri="/WEB-INF/jdbc.tld" prefix="sql"
> %>
> for learning or testing purpose. I use some Jakarta
> Taglibs without any
> -Entry in the web.xml.
>
>
> Regards
> Stefan Riegel
>
>
he.tomcat.core.ContextManager.service(ContextManager.java:559)
> at
>
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
> at
>
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
> at java.lang.Thread.run(Thread.java:484)
>
> Please help.
>
> Thanks in advance
> Amar Das
>
=
Morgan Delagrange
Britannica.com
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
Wrapper.doService(ServletWrapper.java:404)
> at
>
org.apache.tomcat.core.Handler.service(Handler.java:286)
> at
>
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
>
org.apache.tomcat.core.Conte
ue being
> returned? In the case
> of NULL, I'd like to forgo the and replace
> it with ' '.
>
> Thanks for any help you can provide! I'm happy to
> provide more
> information/detail if needed.
>
> --
> Steve Phil
> > > <%-- open a database query --%>
> > >
> > >
> > >
> > > select * from tbl_moviegenre
> > >
> > > <%-- loop through the rows of the query
> > >
> > >
> > >
n't know what 'Operation must use an updateable
> query' means.
> Could someone help?
>
> Mit freundlichem Gruß
>
> Achim Weßling
>
>
**
> INFOKOM Gütersloh
> Fachbereich Technische Anwendungen / Zentrale
> Anwendungen
> Tel.: 05241/85-2926
> [EMAIL PROTECTED]
> http://www.infokom-gt.de/produkte/gis/index.htm
>
>
> _\|/_
> (o o)
>---oOO-{_}-OOo---
>
>
=
Morgan Delagrange
Britannica.com
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
but didn't find a mistake
> inside?!
>
> A little hint would be nice! Thanks a lot!
>
> Achim Weßling
>
>
******
> INFOKOM Gütersloh
> Fachbereich Technische Anwendungen / Zentrale
> Anwendungen
Thanks
>
> Daljeet Singh
> ecExperts India
> Ph:- (O) +91-11-4670906
> (R) +91-11-7125680
> ICQ:- 75129600
> Yahoo:- daljeetsinghmaken
>
=
Morgan Delagrange
Britannica.com
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
--- Morgan Delagrange <[EMAIL PROTECTED]> wrote:
>
> --- Steve Philp <[EMAIL PROTECTED]> wrote:
> > [snip]
> >
> > When I execute that page under Resin 1.2.1 (IBM
> JDK
> > 1.3 on Linux) I get
> > the following error:
> >
> > ja
nge the connection tags
> to:
>
>
>
>
java:comp/env/jdbc/advdb
>
>
> gets it working correctly. Tried both the 3/16 and
> 3/17 nightlies just
> to see if it was a bug that'd been ironed out since
> my download.
Good catch. I introduced an error when I changed the
capitalization of the jndiName attribute. It should
work after tonight's build, or feel free to build it
from source.
> Thanks for any help you can provide!
>
> --
> Steve Philp, MCSE/MCP+I
> Assistant IS Manager
> Advance Packaging Corporation
> [EMAIL PROTECTED]
=
Morgan Delagrange
Britannica.com
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
contributions.
- Morgan Delagrange
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
contributions.
- Morgan Delagrange
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
test JDBC tag library. It
> seems to have been removed
> from the zip files and also from the taglibrary home
> page.
>
> Thanx
>
> Daljeet Singh
> ecExperts India
> Ph:- (O) +91-11-5715330/5714420
> (R) +91-11-7125680
> ICQ:- 75129600
> Yahoo:-
Thanx
> > Daljeet Singh
> > ecExperts India
> > Ph:- (O) +91-11-5715330/5714420
> > (R) +91-11-7125680
> > ICQ:- 75129600
> > Yahoo:- daljeetsinghmaken
>
=
Morgan Delagrange
Britannica.com
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
> ecExperts India
> Ph:- (O) +91-11-5715330/5714420
> (R) +91-11-7125680
> ICQ:- 75129600
> Yahoo:- daljeetsinghmaken
=
Morgan Delagrange
Britannica.com
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
74 matches
Mail list logo
