glenn 01/03/04 10:58:38
Modified: jdbc/doc/web index.html
Log:
Add support for JNDI named JDBC DataSource, contributed by Rich Catlett.
Revision Changes Path
1.7 +102 -3 jakarta-taglibs/jdbc/doc/web/index.html
Index: index.html
===================================================================
RCS file: /home/cvs/jakarta-taglibs/jdbc/doc/web/index.html,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- index.html 2001/02/28 19:07:38 1.6
+++ index.html 2001/03/04 18:58:38 1.7
@@ -138,9 +138,13 @@
</sql:connection></pre>
-<p>The JDBC tag library itself does not instantiate DataSource objects,
-but there are other good ways to get a DataSource (e.g., the JNDI tag library).</p>
+<P><I>3. Use a JNDI named JDBC DataSource</I></P>
+<p>The Connection tag also accepts a JNDI named JDBC DataSource.</p>
+
+<pre><%-- open a database connection --%>
+<sql:connection id="conn1" jndiName="java:/comp/jdbc/test"/>
+
<P><B>Closing connections</B></P>
<P>Close a connection by pasing its reference to the "closeConnection" tag:</P>
@@ -321,7 +325,7 @@
<p>The "format" attribute can be either a pattern as
accepted by SimpleDateFormat or a style: "FULL",
-"LONG", "MEDIUM" or "SHORT". This attribute is optional.</p>
+"LONG", "MEDIUM" or "SHORT". This attribute is optional.</p>
<p>The "locale" attribute can have one to three
components as accepted by the Locale constructor: language,
@@ -427,6 +431,10 @@
<TD>JDBC driver for the database</TD>
</TR>
<TR>
+ <TD><A HREF="#jndiname">jndiname</A></TD>
+ <TD>name of a JNDI JDBC DataSource</TD>
+ </TR>
+ <TR>
<TD><A HREF="#userId">userId</A></TD>
<TD>user id for the database</TD>
</TR>
@@ -586,6 +594,14 @@
<TD COLSPAN="3">name of an existing page attribute that
contains a DataSource object</TD>
</TR>
+ <TR BGCOLOR="#CCCCCC">
+ <TD WIDTH="40%"><B> jndiName</B></TD>
+ <TD WIDTH="20%"> No</TD>
+ <TD WIDTH="40%"> No</TD>
+ </TR>
+ <TR>
+ <TD COLSPAN="3">name used to find a datasource via jndi</TD>
+ </TR>
</TABLE>
</TD>
</TR>
@@ -652,6 +668,11 @@
<%-- optional --%>
<sql:password>notVerySecure</sql:password>
</sql:connection></pre>
+
+<p><i>Method 3: using a jndi named DataSource</i></p>
+
+<pre><%-- open a database connection --%>
+<sql:connection id="conn1" jndiName="java:/comp/jdbc/test"/>
</TD>
</TR>
</TABLE>
@@ -735,6 +756,84 @@
</TD>
</TR>
</TABLE>
+
+<TABLE BORDER="0" WIDTH="90%" CELLPADDING="3" CELLSPACING="0">
+ <TR>
+ <TD COLSPAN="2">
+ <TABLE BORDER="0" BGCOLOR="#CCCCCC" WIDTH="100%" CELLSPACING="0">
+ <TR>
+ <TD><B><FONT SIZE="+1"><A NAME="jndiname"> jndiname</A></FONT></B></TD>
+ <TD ALIGN="RIGHT">Availability: version 1.0 </TD>
+ </TR>
+ </TABLE>
+ </TD>
+ </TR>
+ <TR>
+ <TD COLSPAN="3">Sets the JNDI named JDBC DataSource of the enclosing connection
tag.</TD>
+ </TR>
+ <TR>
+ <TD WIDTH="2%"> </TD>
+ <TD WIDTH="98%">
+ <TABLE BORDER="0" WIDTH="100%">
+ <TR>
+ <TD WIDTH="20%"><B>Tag Body</B></TD>
+ <TD WIDTH="80%">JSP</TD>
+ </TR>
+ <TR>
+ <TD WIDTH="20%"><B>Script Variable</B></TD>
+ <TD WIDTH="80%">No</TD>
+ </TR>
+ <TR>
+ <TD WIDTH="20%"><B>Restrictions</B></TD>
+ <TD WIDTH="80%">Use inside a connection tag.</TD>
+ </TR>
+ <TR>
+ <TD WIDTH="20%"><B>Attributes</B></TD>
+ <TD WIDTH="80%"> </TD>
+ </TR>
+ <TR>
+ <TD WIDTH="20%"> </TD>
+ <TD WIDTH="80%">
+ <TABLE BORDER="0" WIDTH="100%">
+ <TR>
+ <TD WIDTH="40%">Name</TD>
+ <TD WIDTH="20%">Required</TD>
+ <TD WIDTH="40%">Runtime Expression Evaluation</TD>
+ </TR>
+ <TR BGCOLOR="#CCCCCC">
+ <TD WIDTH="40%"><B> initParameter</B></TD>
+ <TD WIDTH="20%"> No</TD>
+ <TD WIDTH="40%"> No</TD>
+ </TR>
+ <TR>
+ <TD COLSPAN="3">Optional attribute, indicating the name of
+ an init parameter</TD>
+ </TR>
+ </table></td>
+ </TR>
+ <TR>
+ <TD WIDTH="20%"><B>Properties</B></TD>
+ <TD>None</TD>
+ </TR>
+ <TR>
+ <TD WIDTH="20%" VALIGN="TOP"><B>Example</B></TD>
+ <TD WIDTH="80%"><BR>
+<PRE><%-- example 1: using the tag body --%>
+<sql:connection id="conn1">
+ <sql:jndiname>java:/comp/jdbc/test</sql:jndiname>
+</sql:connection>
+
+<%-- example 2: using an init parameter --%>
+<sql:connection id="conn1">
+ <sql:jndiname initParameter="jndiDataSource"/>
+</sql:connection></PRE>
+ </TD>
+ </TR>
+ </TABLE>
+ </TD>
+ </TR>
+</TABLE>
+
<TABLE BORDER="0" WIDTH="90%" CELLPADDING="3" CELLSPACING="0">
<TR>