setBoolean - not working properly

[Alessandro Ilardo]

That subject doesn't says much, but I really can't figure out what's wrong with my code or configuration.

On a mysql 4.1 table I've a boolean field called switchUnique

CREATE TABLE `catalog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `code` varchar(45) NOT NULL default '',
  `item` varchar(255) NOT NULL default '',
  `category_id` int(10) unsigned NOT NULL default '0',
  `manufacturer_id` int(10) unsigned NOT NULL default '0',
  `line` varchar(255) default NULL,
  `description` text,
  `filePath` varchar(255) default NULL,
  `quantity` int(10) unsigned NOT NULL default '0',
  `price` double NOT NULL default '0',
  `width` double NOT NULL default '0',
  `length` double NOT NULL default '0',
  `SFbox` double NOT NULL default '0',
  `boxWeight` double NOT NULL default '0',
  `onPalletPieces` int(10) unsigned NOT NULL default '0',
  `palletWeight` double NOT NULL default '0',
  `colorGradient` int(10) unsigned NOT NULL default '0',
  [B]`switchUnique` tinyint(1) unsigned NOT NULL default '0'[/B],
  PRIMARY KEY  (`id`),
  KEY `Index_category` (`category_id`),
  KEY `Index_manufacturer` (`manufacturer_id`),
  CONSTRAINT `FK_catalog_category` FOREIGN KEY (`category_id`) REFERENCES `catalog_category` (`id`),
  CONSTRAINT `FK_manufacturer` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

On a class which dialogs with the table above I've got the following method

            conn = DriverManager.getConnection(connProps.get_url(), connProps.get_user(), connProps.get_password());
         
            pst = conn.prepareStatement("UPDATE catalog SET code = ?, item = ?, category_id = ?," +
                    "manufacturer_id = ?, line = ?, description = ?, filePath = ?," +
                    "quantity = ?, price = ?, width = ?, length = ?, SFbox = ?," +
                    "boxWeigtht = ?, onPalletPieces = ?, palletWeight = ?, colorGradient = ?," +
                    "switchUnique = ? WHERE id = ?;");
            pst.setString(1, product.getCode());
            pst.setString(2, product.getItem());
            pst.setInt(3, product.getCategory_id());
            pst.setInt(4, product.getManufacturer_id());
            pst.setString(5, product.getLine());
            pst.setString(6, product.getDescription());
            pst.setString(7, product.getFilePath());
            pst.setInt(8, product.getQuantity());
            pst.setDouble(9, product.getPrice());
            pst.setDouble(10, product.getWidth());
            pst.setDouble(11, product.getLength());
            pst.setDouble(12, product.getSFbox());
            pst.setDouble(13, product.getBoxWeight());
            pst.setDouble(14, product.getOnPalletPieces());
            pst.setDouble(15, product.getPalletWeight());
            pst.setInt(16, product.getColorGradient());
            logger.debug("TASK update switchUnique boolean value: "+new Boolean(product.isSwitchUnique()).toString());
            pst.setBoolean(17, product.isSwitchUnique());
            pst.setInt(18, product.getId());
            
            pst.executeUpdate();

As you can see there's a line which show me what actually is the boolean value of the object wich I'm trying to store on the table fields.

The problem is: the database always store a false value even if the logger above says that is a true value.

Any helps or suggestions are welcome.
Thanks in advance.

[ October 09, 2006: Message edited by: Alessandro Ilardo ]
[ October 09, 2006: Message edited by: Alessandro Ilardo ]

[Shailesh Chandra]

I have never worked on mysql but only thing I can suggest to try this one

pst.setInt(17, (product.isSwitchUnique() ? 1 : 0 ) );

Shailesh
[ October 09, 2006: Message edited by: Shailesh Chandra ]

[Alessandro Ilardo]

yes, it now works. But I'm still wondering what didn't work with setBoolean...

Anyway, thanks for your help.