List:MySQL and Java« Previous MessageNext Message »
From:Mark Matthews Date:May 30 2003 9:39pm
Subject:Re: Data type for int
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Twibell, Cory L wrote:

> Mark,
>
> It's when I call resultSet.getObject() that I would have expected
Integer as
> the class and not Long for the MySQL data type integer.

Okay. Is the 'INT' column in MySQL defined as 'INT UNSIGNED'? If not, I
can make up a quick testcase, but I'm pretty sure this is working as
designed.

To shorten the question/response cycle, it would be helpful for me (and
for other people on the list) if when you posted questions, you added a
code snippet and/or table schema/sample data when appropriate, or show
the methods you are calling, etc...E-mail can be a vague medium at
times, and it's not very high-bandwidth (compared to in-person, or on
the phone, etc). Having this information in your questions saves a lot
of back-and-forth, and makes the problem you're trying to fix a lot
clearer to me, and everyone else on the list (who might potentially be
able to help you out!)

Also, unless you're transmitting sensitive information, could you please
use 'REPLY ALL', so that our posts go back to the list...That way
everyone can benefit from the information!

Thanks!

	-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+18+ntvXNTca6JD8RAn4zAKDJtm/sBqSIxqGphxxRuyhYXBZbNwCbBMOM
C6FE3qyQxkPKnwg3ePKYxks=
=/5lr
-----END PGP SIGNATURE-----

Thread
Data type for intCory L Twibell30 May
  • Re: Data type for intMark Matthews30 May
Re: Data type for intMark Matthews30 May
Re: Data type for intMark Matthews31 May