dev@glassfish.java.net

Re: Informix jdbc connection pool on SJSAS 9.0

From: Lance J. Andersen <Lance.Andersen_at_Sun.COM>
Date: Thu, 14 Sep 2006 10:56:24 -0400

Hi Cheng,

We have not done any specific testing against informix recently using
the informix drivers. If the the datasource class provided generates
the same error regarding it cannot cast to javax.sql.DataSource, it
sounds like the person needs to get a different driver.

Cheng Fang wrote:
> 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
>>>
>>>
>>>
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>