Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

dataSource problem in <sql:query> tag

0 views
Skip to first unread message

Colin Zhao

unread,
Feb 15, 2003, 9:45:14 PM2/15/03
to

WebLogic 7.0
Oracle 9i
Oracle thin drive

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

0 new messages