Hi Ariel,
Your problem relates to the inner workings of Poolman. Internally, poolman
uses a some ArrayList (as far as I could determine from a quit look at the
SmartResultSet.java code).
Apparantly the oracle driver implementation does not suffer from this. Their
getInt() implementation probably differs from the one in Poolman.
It might also be related to the underlying table structure/field definition,
but it appears that poolman loads your value in a BigDecimal instance
instead of an Integer class.
What is the database data type of the concerned field in Oracle ?
I'm sure you could get around it by using getDouble() instead.
Patrick.
> -----Original Message-----
> From: Ariel [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 11:48
> To: '[EMAIL PROTECTED]'
> Subject: RE: poolman
>
>
>
> Hello Patrick,
>
> Onjce you have been lucky with poolman maybe you can help me
> with teh following problem:
>
> I am getting the following exception everytime getInt() is invoked:
>
> java.lang.ClassCastException: java.math.BigDecimal at
> com.codestudio.sql.SmartResultSet.getInt(SmartResultSet.java:506)
>
> Needless to say that the same code was working fine using jdbc
> oracle driver
> (classes12.zip)
> without PoolMan
>
>
> Thx,
>
> Ariel
>
> -----Original Message-----
> From: Patrick Vanden Driessche
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 2:37 AM
> To: [EMAIL PROTECTED]
> Subject: RE: poolman
>
>
>
> Hi Ryan,
>
> I've been using Poolman for a while in my development environment without
> problems.
> I'm running MySQL, Tomcat 3.2.1. on Win2K system for development...
>
> Are you sure that the poolman.jar and the jdbc2.0-stdext.jar are
> in Tomcat's
> classpath ?
> (in my case I placed them in the %TOMCAT_HOME%\lib directory.
>
> Secondly... Make sure that the jdbc driver used by Poolman to connect to
> your database is also available in the classpath.
> (In my case, the mm.mysql driver is in the same folder)
>
> Hope this helps,
>
> Patrick.
>
>
> -
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
