Lance, Jagadish,
Thanks for the help. I will ask the user for more info.
Since he's using admingui, which populates all required fields including
datasource classname (com.informix.jdbcx.IfxDataSource), it's less
likely he got wrong configuration. He tried
com.informix.jdbcx.IfxDataSource and still got the same error.
The admin guide has pretty much the same info as in admingui.
Is the Informix jdbc driver version a factor here? Which driver version
did we test with?
Cheng
Jagadish Prasath Ramu wrote:
>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
>>
>>
>>
>
>
>