<sas:JDBCConnection>

The JDBCConnection Custom Tag allows the user to include JDBC connectivity within a JSP page. The JDBCConnection Tag may be used in all four scopes, PAGE, REQUEST, SESSION, and APPLICATION. If the JDBCConnection Tag is used with a scope of PAGE, all code must be contained within the body of the JDBCConnection Tag. If the scope is of the JDBCConnection Tag is PAGE and a body is present, the connection will be stopped at the end of the JDBCConnection Tag's body. If the id or ref attributes are null the connection will be stopped at the end of the JDBCConnection Tag's body.

Syntax

<sas:JDBCConnection databaseURL="java.lang.String" driverName="java.lang.String"
   [autoCommit="true|false"]
   [catalog="java.lang.String"]
   [connectionInfo="java.lang.String"]
   [id="value"]
   [instantiate="true|false"]
   [loginCommand="java.lang.String"]
   [password="java.lang.String"]
   [readOnly="true|false"]
   [ref="java.lang.String"]
   [scope="page|request|session|application"]
   [transactionIsolation="int"]
   [typeMap="java.lang.String"]
   [username="java.lang.String"]>
      [<sas:SetProperty ...>
         The value to set on the parent tag
      </sas:SetProperty>]
      [Additional <sas:SetProperty> tags...]
</sas:JDBCConnection>

Attributes

autoCommit
catalog	the name of the catalog to select
connectionInfo	the String representing the Properties object used in obtaining a Connection
databaseURL	the String representing the database url used to obtain a java.sql.Connection
driverName	the name of the JDBC Driver class
id	Case-sensitive name used to identify the object instance.
instantiate	Flag that, if true, indicates that a new instance of the underlying class should be loaded if one cannot be found in PageContext. Must be used with an id attribute.
loginCommand	the String representing the login command
password	password
readOnly	indicates if the connection should be in read-only mode.
ref	The variable String value that represents an object created earlier in the same scope.
scope	The scope (or page context) within which the reference is available.
transactionIsolation	the desired transaction isolataion level for the Jdbc Connection
typeMap	the String representing the type map used for custom mapping of SQL structured types and distinct types
username	username

More Information

To view the documentation for the related InformationBean, see com.sas.storage.jdbc.JDBCConnection.

If you need to subclass the tag handler class for the sas:JDBCConnection tag, extend com.sas.taglib.storage.jdbc.JDBCConnectionTag.