It should be returning an Integer object.  In a brief look at the source 
code it seems to be doing the correct thing.  What version are you using?

Also I noticed your example below:

   System.out.println("The result is: " + (String) obj);

This shouldn't work.  You can't cast any random object to a String.  I 
think what you want is:

   System.out.println("The result is: " + obj.toString());


Dr. Evil wrote:

> I am doing some queries using JDBC.  I use the ResultSet.getObject()
> method to get the result object.  This works fine with SQL VARCHAR,
> etc, but there is a big problem when I try it with an INT4.
> For example:
> Object obj = result.getObject(i);
> It gets the object just fine but then I can't do anything with the
> object.  I can't do this:
> System.out.println("The result is: " + (String) obj);
> or anything else.  I am guessing that the problem may be that it is
> trying to return an integer type, which is not an object.  Any
> sugestions on this?
> One thing I think I could do is to try to detect the type using
> MetaData.getResultType() or something, and then call
> ResultSet.getInt() or whatever is appropriate.  Is this the best way
> to do it?
> Thanks
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

Reply via email to