CachedRowSetXImpl - returns 4294967297 instead of 1
Author: LyallInOz  Posts: 5   Registered: 2/3/06
        Feb 5, 2006 12:50 AM
I retrieve data from a query and the returned value is 4294967297
instead of 1 (which is what it is in the database).
This is 0x10000001 rather than the expected 0x0000001
I have dug around in the debugger and found the column values in the
result set, and yes, the object does contain the large number.

The APP code

       CachedRowSet userRowSet = new CachedRowSetXImpl();
       try {
           userRowSet.setDataSourceName("java:comp/env/jdbc/MyAppDB");
           userRowSet.setCommand(
                   "select Users.encryptedPassword,
Users.knownAs,        ApplicationRoles.shortName,
ApplicationRoles.idApplicationRole   from ApplicationRoles inner join
Users on          (ApplicationRoles.idApplicationRole =
Users.idApplicationRole) where Users.nameUser = ?"
                   );
           userRowSet.setString(1,loginUsernameString );
           userRowSet.execute();
           if (! userRowSet.next()) {
               return;
           }

The table in question is

mysql> describe ApplicationRoles;
+-------------------+------------------+------+-----+---------+----------------+

      |
+-------------------+------------------+------+-----+---------+----------------+

auto_increment |

      |
+-------------------+------------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

Output from MySQL using the exact query from the app ->

mysql> select Users.encryptedPassword,        Users.knownAs,
ApplicationRoles.shortName,        ApplicationRoles.idApplicationRole
from ApplicationRoles inner join Users on
(ApplicationRoles.idApplicationRole = Users.idApplicationRole) where
Users.nameUser = 'lyallp';
+-------------------+---------+-----------+-------------------+

+-------------------+---------+-----------+-------------------+

+-------------------+---------+-----------+-------------------+
1 row in set (0.02 sec)

Under Linux, JSC 2
With MySQL 5.0.18
Using jdbc-mysql.jar with manifest info

Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.2
Created-By: Blackdown-1.4.2-03 (Blackdown Java-Linux Team)
Built-By: portage

Name: common
Specification-Title: JDBC
Specification-Version: 3.0
Specification-Vendor: Sun Microsystems Inc.
Implementation-Title: MySQL Connector/J
Implementation-Version: 3.1.10
Implementation-Vendor: MySQL AB

Curiously enough, this whole thing worked fine when I established my
own Context, DataSource, Connection and created my own
PreparedStatement and ResultSet.

Am I doing something silly?

...Lyall