Hi Cheng,
As Lance has told,
"com.informix.jdbc.IfxDriver cannot be cast to javax.sql.DataSource"
indicates that the configuration of conn. pool is incorrect.
Please refer the Admin Guide for a typical configuration using Informix.
http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklk?a=view#beanj
If you are not able to solve the problem, please post
1) con. pool configuration
2) complete exception stack trace from server.log
Thanks,
-Jagadish
On Thu, 2006-09-14 at 10:20 -0400, Cheng Fang wrote:
> Hi,
>
> This user is having trouble creating Informix jdbc connection pool on
> SJSAS 9.0, using admingui. He/she was using informix jdbc 3.0 from ibm
> web site, including ifxjdbc.jar and ifxlang.jar. When pinging the
> newly-created connection pool, he got this error:
>
> Operation 'pingConnectionPool' failed in 'resources' Config Mbean.
> Target exception message: com.informix.jdbc.IfxDriver cannot be cast to
> javax.sql.DataSource
>
> I already suggested using com.informix.jdbcx.IfxDataSource as datasource
> classname, copying jars to domain1/lib, restart server. But he said it
> still failed.
>
> Have anyone seen this type of error before? or any further suggestions?
>
> The forum post in Chinese:
> http://gceclub.sun.com.cn/NASApp/sme/jive/thread.jsp?forum=22&thread=40422
>