JSF DataWindow Database Driver Support

JSF DataWindow attributes that support connecting to a database are:

connectString
jndiDataSource
Use this with ConnectionCache defined in EAServer or Tomcat. In JSF DataWindows, only JDBC ConnectionCache is supported. ODBC/Native database driver caches are not supported.
onLoadHandler

Supported methods of connecting to a database from a JavaServer Faces (JSF) DataWindow are shown in the following table.

JSF DataWindow driver support

Database driver	JNDI connection cache support	ConnectString support	OnLoadHandler support	Database support
JDBC	Yes	Yes	Yes	ASE, ASA, SQLServer, Oracle, and others with JDBC support
ODBC	No	Yes	Yes	ASE, ASA, SQLServer, Oracle,and others with JDBC support
Native drivers	No	Yes	Yes	ASE Note For Oracle native, use onLoadHandler.

Use the following ConnectString formats.

ConnectString format for ODBC:
ODBC/username/password/DSNName
ConnectString format for ASE Native:
SYBNATIVE/username/password/dbname/servername
Note
For native drivers from other vendors, such as Oracle, use onLoadHandler.
ConnectString format for JDBC:
username/password/Driver/URL