I have configured the connection pool with admin console and the entry in config.xml
is as follows:
<JDBCDataSource JNDIName="dataSource-Oracle" Name="Oracle Data Source" PoolName="oraclePool"
RowPrefetchEnabled="true" Targets="examplesServer" />
The WL server started no problem. But I got an error loading a jsp page with
the <sql:query> tag:
<sql:query dataSource="dataSource-Oracle" var="list" >
SELECT TABLE_NAME columnname FROM ALL_TABLES where owner='PRODUCT' order
by 1
</sql:query>
The error is:
<Feb 15, 2003 9:27:47 PM EST> <Error> <HTTP> <101017> <[ServletContext(id=493601
2,name=examplesWebApp,context-path=/examplesWebApp)] Root cause of ServletExcept
ion
javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid:
"No suitable driver"
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnect
ion(QueryTagSupport.java:308)
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag
(QueryTagSupport.java:192)
Any suggestions? I can't find any examples in the BEA jsp docs showing how to
code jstl tags.
The same page works fine with Tomcat.
Thanks.
Colin